SSIS MongoDB Source Adapter - NoSQL Connector

SSIS MongoDB Source

MongoDB Source can be used to extract large amount of data from MongoDB Database. This component supports SQL like query language to query MongoDB data without worrying about complex API or proprietary query language. MongoDB is an open-source document database, and the most popular NoSQL database out there.

Features

  • Fast data read/extract from MongoDB inside SSIS using familiar SQL style query language (No need to learn new query language)
  • Support for Aggregation framework (Group by)
  • Support for all MongoDB query operators using MongoDB Native Query for advanced query
  • Extract sub documents or values from array using JSONPath expression (e.g. $.Orders[*].OrderItems[*])
  • Support for extracting raw JSON documents from MongoDB
  • Support for advanced options to skip attributes with certain names or depth
  • Option to include parent attributes when inner documents extracted using JSONPath
  • Support for MongoDB 3.x and advanced options to connect to Replica Set
  • Support for SQL Query for MongoDB.
  • Support for SQL Server 2005, 2008, 2012, 2014, 2016 (32 bit and 64 bit)
  • Articles/Tutorials: MongoDB related articles
Download Help File Buy
View All Tasks
ScreenshotsUseful LinksSystem Requirements

MongoDB Source Connector – Query data using SQL, Extract from array using JSON Path

SSIS MongoDB Source Connector - Query data using SQL, Filter using JSON Path

SSIS MongoDB Source Connector – Query data using SQL, Filter using JSON Path

MongoDB Source Connector – Use native JSON Query format

SSIS MongoDB Source Connector - Native query using MongoDB operators

SSIS MongoDB Source Connector – Native query using MongoDB operators

MongoDB Source Connector – Aggregation Framework Support (Group By)

SSIS MongoDB Source - Example of MongoDB Group By Query (Aggregation Framework Pipeline)

SSIS MongoDB Source – Example of MongoDB Group By Query (Aggregation Framework Pipeline)

MongoDB Source Connector – Advanced Filter Options

SSIS MongoDB Source Adapter Advanced Filter (JSON Path)

SSIS MongoDB Source Adapter Advanced Filter (JSON Path)

SSIS MongoDB Source Connector – Output as JSON, Extract raw JSON from nested array

SSIS MongoDB Source - Output as JSON, Extract raw JSON from nested Array

SSIS MongoDB Source – Output as JSON, Extract raw JSON from nested Array

MongoDB Source Connector – Select Columns

SSIS MongoDB Source Adapter Select Columns

SSIS MongoDB Source Adapter Select Columns

MongoDB Connection Manager

SSIS MongoDB Connection Manager

SSIS MongoDB Connection Manager

SSIS MongoDB Source – Extract Data

SSIS MongoDB Source - Extract Data

SSIS MongoDB Source – Extract Data

Extract data from Multiple arrays

  • .net framework 3.5 or higher must be installed
  • SSIS Runtime: To execute SSIS package you will need one or more versions of SQL Server Integration Services 2005/2008/2008 R2/2012/2014 or 2016
  • To design SSIS 2012 package SSDT (VS 2010 Shell – SQL Server Data Tools) must be installed.
  • To design SSIS 2014 package SSDT-BI (VS 2013 Shell – SQL Server Data Tools) must be installed.
  • To design SSIS 2016 package SSDT-BI (VS 2015 Shell – SQL Server Data Tools) must be installed.
  • To design SSIS 2005, 2008, 2008 R2 packages BIDS (VS 2005,2008 Shell – Business Intelligence Development Studio) must be installed.
  • Supported Client Operating Systems: Windows 7, Windows 8, Windows 8.1
  • Supported Server Operating Systems: Windows Server 2003/R2, Windows Server 2008/R2, Windows Server 2012/R2
Download View All Tasks Like This