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)
  • Aggregation framework (Group by) support
  • Multiple authentication methods support (including SSL and Client X509 Certificate)
  • Support for Advanced query operations using MongoDB Native Query language
  • Extract data from nested array using JSONPath (e.g. $.Orders[*].OrderItems[*])
  • Output raw JSON documents rather than columns (with indent option)
  • Advanced options to skip attributes with certain names or depth
  • Option to include parent attributes when inner documents extracted using JSONPath
  • Compatible with MongoDB 2.x, 3.x and 4.x (and higher)
  • Support for SQL Server 2017, 2016, 2014, 2012, 2008 (32/64 bit) and now Azure Data Factory
  • Articles/Tutorials: MongoDB related articles
Download Help File Buy
View All Tasks

Featured Articles

How to call MongoDB JavaScript using SSIS
How to read MongoDB data from an array (extract nested subdocuments)
How to write MongoDB Aggregation Queries in SSIS (Group By)
How to loading SQL data into MongoDB (Insert, Upsert, Delete, Update)
How to update MongoDB Array Items using SSIS

ScreenshotsUseful LinksSystem Requirements

MongoDB Source Connector – Query data using SQL, Extract from an 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

SSL / X509 Authentication Support

Using SSL / X509 Client Certificate Connection Method

Using SSL / X509 Client Certificate Connection Method

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