Mongosis



Custom components for integrating MongoDB and Microsoft SQL Server Integration Services (SSIS)


Download Mongosis View on Github »



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.

Installation

  1. Download the Mongosis Installer

  2. Run the installer.

  3. You're ready to go!

Requirements

  • Microsoft Visual Studio 2010 (SQL Server Data Tools)

  • The MongoDB C# Driver

    • The latest version of Mongosis requires version 1.7.0 of the MongoDB C# driver
    • Run gacutil.exe with '/iF' option to load the MongoDB C# driver DLLs in to the Global Assembly Cache
    • gacutil.exe can be found here: C:\Program Files (x86)\Microsoft SDKs\Windows\v7.0A\bin\NETFX 4.0 Tools\gacutil.exe

Getting Started

  1. Start or open your Integration Services project:

    Open SSIS

  2. On the Data Flow tab, drag a MongoDB Source from the toolbox to the work area:

    Add Mongo Data Source

  3. In the solution explorer for your project, right click the Connection Managers folder.

    Right click Connection Managers

  4. Select New Connection Manager and choose MongoDB.

    MongoDB Connection Manager

  5. In the Connection Managers tab, select the new MongoDB connection manager.

    Select the new manager

  6. In the properties tab, enter the DatabaseName, ServerName, UserName and 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.

    Enter credentials

  7. Double click the icon on your MongoDB Source in the work area to open up the Advanced Editor.

    Open Advanced Editor

  8. On the Connection Managers tab, select the MongoDBConnectionManager as the connection manager.

    Select connection manager

  9. On the 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)

    Select the collection

  10. If this has been configured correctly, you should be able to see the available fields for the collection on the Column Mappings tab.

    See available fields