Menu
Simba Technologies
Simba Technologies

Simba MongoDB ODBC Driver with SQL Connector 2.2.3
Installation and Configuration Guide

Simba > Drivers > MongoDB > ODBC Installation Guide > Windows > Configuration > Configuring Authentication

Configuring Authentication

Some MongoDB databases require authentication. You can configure the Simba MongoDB ODBC Driver to provide your credentials and authenticate the connection to the database using one of the following methods:

Using SCRAM-SHA-1

You can configure the driver to use the SCRAM-SHA-1 protocol to authenticate the connection. SCRAM-SHA-1 is the default authentication protocol used by MongoDB.

To configure SCRAM-SHA-1 authentication:

  1. To access authentication options, open the ODBC Data Source Administrator where you created the DSN, select the DSN, and then click Configure.
  2. In the Mechanism drop-down list, select MongoDB User Name and Password.
  3. To use a database other than the admin database to check your credentials, type the name of the database in the Authentication Source field.
  4. In the Username field, type an appropriate user name for accessing the MongoDB database.
  5. In the Password field, type the password corresponding to the user name you typed above.
  6. Encrypt your credentials by selecting one of the following:
    • If the credentials are used only by the current Windows user, select Current User Only.
    • Or, if the credentials are used by all users on the current Windows machine, select All Users Of This Machine.
  7. To save your settings and close the dialog box, click OK.

Using Kerberos

You can configure the driver to use the Kerberos protocol to authenticate the connection.

Kerberos must be installed and configured before you can use this authentication mechanism. For information about how to install and configure Kerberos, see the MIT Kerberos Documentation: http://web.mit.edu/kerberos/krb5-latest/doc/.

To configure Kerberos authentication:

  1. To access authentication options, open the ODBC Data Source Administrator where you created the DSN, select the DSN, and then click Configure.
  2. In the Mechanism drop-down list, select Kerberos.
  3. In the Service Name field, type the service name of the MongoDB server.
  4. To save your settings and close the dialog box, click OK.

Using LDAP

You can configure the driver to use the LDAP protocol to authenticate the connection.

To configure LDAP authentication:

  1. To access authentication options, open the ODBC Data Source Administrator where you created the DSN, select the DSN, and then click Configure.
  2. In the Mechanism drop-down list, select LDAP.
  3. In the Username field, type an appropriate user name for accessing the MongoDB database.
  4. In the Password field, type the password corresponding to the user name you typed above.
  5. Encrypt your credentials by selecting one of the following:
    • If the credentials are used only by the current Windows user, select Current User Only.
    • Or, if the credentials are used by all users on the current Windows machine, select All Users Of This Machine.
  6. To save your settings and close the dialog box, click OK.