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 2022, 2019, 2017, 2016, 2014, 2012 (32/64 bit) and now Azure Data Factory
Support for reading MongoDB View data (Requires SSIS 2014 or higher)
Articles/Tutorials: MongoDB related articles

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

MongoDB Source Connector – Use native JSON Query format

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)

MongoDB Source Connector – Advanced Filter Options

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

MongoDB Source Connector – Select Columns

SSIS MongoDB Source Adapter Select Columns

MongoDB Connection Manager

SSIS MongoDB Connection Manager

SSL / X509 Authentication Support

Using SSL / X509 Client Certificate Connection Method

SSIS MongoDB Source – Extract Data

SSIS MongoDB Source – Extract Data

Extract data from Multiple arrays

Featured Articles

Click here to see all articles for [SSIS MongoDB Source] category

Blog posts/Articles related to MongoDB
What is MongoDB and how can I download, Install and try for FREE?
MongoDB Homepage
Free Cloud Hosted version of MongoDB
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

How to configure MongoDB SSL Connection in SSIS

Introduction MongoDB comes with SSL support which can secure your end to end communication. However setting up MongoDB SSL Connection may require some configuration on both sides (i.e. Server and Client side). In this post our goal is to secure yourÂ MongoDB Integration in SSIS. Now lets look at steps to configure SSL in MongoDB. Configure […]

How to parse MongoDB Date time in SSIS

Introduction In our previousÂ post we explained how to read/load MongoDB data in SSIS. This post covers specifically how to parse MongoDB date time stored inside your MongoDB documents. By default any well known date formats (e.g. ISO date) will be parsed as valid datetime (e.g. DT_DBTIMESTAMP) when you use SSIS MongoDB Source. But if you […]

How to extract multiple arrays from MongoDB using SSIS

Since MongoDB Source supports only one output you cannot select two different hierarchies as your filter criteria. However solution is easy. You can perform following steps to achieve similar result without fetching data twice with multiple sources. Same steps described below can be applied for JSON Source (read more here) Steps – Extract multiple […]

How to write MongoDB Aggregation Queries in SSIS (Group By)

Introduction In this post you will learn how to write flexible MongoDB Aggregation Queries in SSIS (i.e. Group By Query) using SSIS MongoDB Source Component. MongoDB provides powerful Aggregation Pipeline Engine which is conceptually same as writing Group By queries in traditional SQL world but its not exactly same.Â SSIS MongoDB Source returns nested MongoDB JSON […]

Read MongoDB data from array (extract nested sub documents)

Introduction In this post you will learn how to read MongoDB data from Array. We recently introducedÂ new JSON Path expression featureÂ in SSIS MongoDB Source Connector to extract nested information from MongoDB documents. Read documents from Array in MongoDB By default SSIS MongoDB Source Connector doesn’t support extracting data using JSON Path expression. So if […]

How to query MongoDB by date or ISODate

Introduction ZappySys provides high performance drag and drop connectors for MongoDB Integration. In our previous postÂ we discussed how to query/load MongoDB data (Insert, Update, Delete, Upsert).Â In this post you will see how to query MongoDB by date (or ISODate) using SSIS MongoDB Source. To see full detail about possible query syntax see online help. MongoDB […]