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 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)

MongoDB Source 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.

Read more

SSIS MongoDB Destination (Bulk Insert, Delete)

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

Read more

SSIS MongoDB ExecuteSQL Task

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.)

Read more

 

Download View All Tasks