SSIS MongoDB ExecuteSQL Task

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

Features

  • Intuitive user interface with many examples makes MongoDB learning super easy and fast
  • Call DDL statements such as Create/Drop table
  • Execute DML statements such as Select/Insert/Update/Delete
  • Support for calling Database, Collection, Server MongoDB commands using JavaScript
  • Saving RawResult (e.g. JSON response) into SSIS variable
  • Extract SingleValue from response such as count or size from getStats function response.
  • Save in FullResultset as ADO.net dataset (e.g. select * from mycollection) can be stored as ADO.net recordset (can be used with ForEachLoop container task for looping).

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

Insert document into MongoDB

MongoDB execute command - insert JSON document into MongoDB

 

Get table list as ADO.net recordset variable (Used with ForEachLoop)

MongoDB get table list as ADO.net recordset variable (Used with ForEachLoop)

 

Call server side MongoDB JavaScript functions

MongoDB call server side JavaScript

 

Click here to learn more about System Requirements
Download View All Tasks Like This