MongoDB Connection Manager

SSIS MongoDB Connection Manager
MongoDB Connection Manager can be used to connect to MongoDB server to perform data extract/import.

Content

In this tutorial we are going to Create MongoDB Connection. Here you can create multiple connection too.

Before we get started, MongoDB installed.
Download and Install SSIS PowerPack from here (Skip this if you already did).
Once you finished above steps, Open Visual Studio and Create New SSIS Package Project.
Right click on Connection Managers Panel to Create MongoDB Connection,and Context Menu will appear, Select New Connection from the Context Menu.
Select ZS-MongoDB from the Connection Managers list and Click on Add Button.
Now, in Connection Manager you will get by default Host name if you have already installed MondoDB, just give your User Name, Password and Database Name and hit on Test Connection and then click OK.
Click on Test Connection to check configure correct or not.
Click on OK to save MongoDB Connection setting UI.
Once you finished, you will see MongoDB connection in Connection Manager panel.

Property Name	Description
Options
Host
UserName
EnableSsl
CheckCertificateRevocation
AllowInvalidCertificate
EnableCertificate
CursorOptions	Various cursor options. To specify multiple options use vertical bar. If option has value then use comma after option name. (e.g. TAILABLECURSOR\|PARTIAL\|CURSORTIMEOUT,600) Available options are NOCURSORTIMEOUT, AWAITDATA, EXHAUST, PARTIAL, TAILABLECURSOR, SLAVEOK, QUERYTIMEOUT[,seconds]
Database
CertificatePath
Password
CertificatePassword
ConnectionString
RetainSameConnection
ProgressUpdateInterval	Update interval in KB. System will report upload/download progress based on this setting. By default progress is reported every 1000 KB.
Timeout
MaxRetryOnError
RetryInterval
MaxParallelThreads