Represents the passphrase to the key file when using Key authentication.
Represents the SSH user's password when using Password authentication. The username of the SSH user to authenticate with. Represents the path to the key file to use for Key authentication. Key: uses key file to authenticate to SSH server.Password: uses password to authenticate to SSH server.The port number of the SSH server to tunnel through. The host address of the SSH server to tunnel through. The SSH page allows you to configure SSH related settings. Unless there is a strong reason to believe the connection is secure - such as the network communication is only happening in an internal infrastructure, this option should be unchecked for best security. Warning: Enabling the "Ignore Certificate Errors" option is generally NOT recommended, particularly for production instances. This option can be used to ignore those SSL certificate errors when connecting to MongoDB. Additional SSL Settings Ignore Certificate Errors This option is available when you choose File System as the Certificate Location. Provide the password to the certificate file.
Note: The MongoDB client uses a PEM file, however, the driver we use only supports PFX files so you will have to use OpenSSL to convert your PEM file to a PFX file. Note: The component supports Azure Blob Shared Access Signature (SAS) URL in the certificate path. This option is available when you choose File System as Certificate Location.
Click the ellipses button to browse their file system for the certificate. Provide the path to the certificate file to use for authentication. This option is available when you choose Store as Certificate Location. Click the ellipses button to browse and select a certificate for the users store. There are two options available:Īllows you to specify the thumbprint of the client certificate from the Certificate Store. Client Certificate Certificate LocationĪllows you to specify the location of the certificate that will be used. The SSL page allows you to configure TLS/SSL related settings. The MongoDB database to use for Basic authentication. The password used for Basic, Kerberos, or LDAP authentication. The username used for Basic, Kerberos, or LDAP authentication. LDAP: MongoDB uses LDAP proxy authentication (enterprise only).Kerberos: MongoDB uses a Kerberos service for authentication (enterprise only).X509: MongoDB uses TLS/SSL (certificate) authentication.Basic: MongoDB deployment uses a simple username and password for authentication.None: MongoDB deployment does not require authentication.There are five different ways to authenticate:
The Authentication page allows you to specify how to authenticate to your MongoDB deployment. Subtype 4 - Selecting this type will only allow you to read SubType 4 UUIDs and will write UUIDs as SubType 4.Subtype 3 - Selecting this type will allow you to read both SubType 3 and SubType 4 UUIDs but will only write UUIDs as SubType 3.The UUID Subtype option allows you to specify how to handle UUID types. The Host represents the Server containing your MongoDB server. You can add and remove server addresses as needed. The Servers page on the MongoDB Connection Manager allows you to specify server addresses of your MongoDB deployment. The MongoDB Connection Manager contains the following five pages to connect to your MongoDB server.
Using the SSIS MongoDB Connection Manager