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
ReadConcern ReadConcern level for query. For more information check this link https://docs.mongodb.com/manual/reference/read-concern/

Available Options (Use numeric value listed in bracket if you have to define expression on this property (for dynamic behavior).

Option Description
Default [0] Default
Local [1] Local
Majority [2] Majority
Linearizable [3] Linearizable
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
ConnectByProxy

Setting UI

MongoDB Connection - Setting UI

See Also

References

Copyrights reserved. ZappySys LLC.