MongoDB Connection Manager
PreviousNext

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

Download SSIS PowerPack

Content

Video Tutorial

Step-By-Step

In this tutorial we are going to Create MongoDB Connection. Here you can create multiple connection too.
  1. Before we get started, MongoDB installed.
  2. Download and Install SSIS PowerPack from here (Skip this if you already did).
  3. Once you finished above steps, Open Visual Studio and Create New SSIS Package Project.
  4. Right click on Connection Managers Panel to Create MongoDB Connection,and Context Menu will appear, Select New Connection from the Context Menu.
    SSIS Create New Connection
  5. Select ZS-MongoDB from the Connection Managers list and Click on Add Button.
    MongoDB Connection
  6. 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.
    MongoDB Connection Manager UI
  7. Click on Test Connection to check configure correct or not.
  8. Click on OK to save MongoDB Connection setting UI.
  9. Once you finished, you will see MongoDB connection in Connection Manager panel.
    MongoDB Connection Manager UI

Properties

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

Setting UI

MongoDB Connection - Setting UI

See Also

References


Copyrights reserved. ZappySys LLC.