Mongosis provides a means to read data from MongoDB within SSIS via a custom data source and connection manager components. Available collection fields are automatically detected and added as output fields ready to be piped in to any of the standard SSIS destination components.
Download the Mongosis Installer
Run the installer.
You're ready to go!
Microsoft Visual Studio 2010 (SQL Server Data Tools)
Start or open your Integration Services project:
Data Flow tab, drag a MongoDB Source from the toolbox to the work area:
In the solution explorer for your project, right click the Connection Managers folder.
New Connection Manager and choose MongoDB.
In the Connection Managers tab, select the new MongoDB connection manager.
In the properties tab, enter the
Passwordfor your Mongo database. Note that the
SlaveOk property can be set to true in order to connect to a slave node within a replica set. Note that the
Ssl property can be set to true in order to connect to a database running with SSL encryption.
Double click the icon on your MongoDB Source in the work area to open up the Advanced Editor.
Connection Managers tab, select the MongoDBConnectionManager as the connection manager.
Component Properties tab, under
Custom Properties, select the
CollectionName corresponding to the Mongo collection you wish to get data from. (Note this requires that the Connection Manager details set earlier are correct)
If this has been configured correctly, you should be able to see the available fields for the collection on the
Column Mappings tab.