SSIS MongoDB Integration Pack

SSIS MongoDB Integration Pack is your complete toolset to automate MongoDB integration scenarios in SSIS. Using simple drag and drop interface you can read data from MongoDB or Bulk insert/update data into MongoDB. You can also execute any valid MongoDB API commands inside SSIS (e.g. Create Table/ Drop Table/Get Count). It includes MongoDB Source Connector, MongoDB Destination Connector and MongoDB ExecuteSQL Task.

Features

Bulk extract/output MongoDB data using SSIS Custom Adapter
Support for SQL Like queries using proprietary Query engine, no need to learn complex MongoDB APIs
Bulk insert/update/upsert data into MongoDB Table
Bulk delete data from MongoDB Table
Support for loading Raw JSON documents from any source or generated by JSON Generator Transform
Intuitive user interface with many examples makes MongoDB learning super easy and fast
Support for executing DDL statements such as Create/Drop table
Support for executing custom MongoDB Shell functions / server side JavaScript
Support for saving RawResult (e.g. JSON response) into SSIS variable
Support for SQL Server 2022, 2019, 2017, 2016, 2014, 2012 (32/64 bit) and now Azure Data Factory
Articles/Tutorials: MongoDB related articles

Download

Buy

View All Tasks

SSIS MongoDB Source (Query/Read/Extract)

SSIS MongoDB Source can be used to extract large amount of data from MongoDB. This component supports SQL like query language to query MongoDB data without worrying about complex API.

Go to top

SSIS MongoDB Destination (Bulk Insert, Delete)

SSIS MongoDB Destination can be used to bulk insert/delete large amount of records to MongoDB storage from any data source using SSIS.

Go to top

SSIS MongoDB ExecuteSQL Task

SSIS MongoDB ExecuteSQL Task can be used to execute ad-hoc commands for MongoDB (e.g. DDL statements such as Create/Drop collection, DML statements such as Insert, Update, Delete or Run JavaScript and shell commands.)

Download View All Tasks