SSIS MongoDB Integration Pack

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 2005, 2008, 2012, 2014, 2016 (32 bit and 64 bit)

 Articles/Tutorials: MongoDB related articles