Create a System DSN¶
The following steps describe how to create a system Data Source
Name (DSN) for the BI Connector's
process. A DSN is a saved configuration which
describes a database connection to be
used by an ODBC driver.
Once the DSN is created for the BI Connector, you can configure a wide
range of SQL clients and BI tools to use the DSN and import
data from MongoDB.
Before creating a DSN , you should:
Start the Microsoft ODBC Data Sources program.¶
Choose the program version (64-bit or 32-bit) which is appropriate for your system and ODBC driver version.
System DSN tab.¶
Select a MongoDB ODBC driver from the list of available drivers.¶
Select either the MongoDB ODBC 1.1.0 ANSI Driver or the MongoDB ODBC 1.1.0 Unicode Driver, then click OK.
The ANSI ODBC driver offers maximum performance but has a limited character set. The Unicode ODBC driver supports a wider character set but may be slightly less performant as a result.
Fill in the necessary form fields.¶
Click the Details button to expose the lower half of the form.
The following form fields are required:
Data Source Name
A name of your choice.
Port number of your
The name of the database to connect to, e.g.
(Optional) If authentication is enabled, fill in the authentication form fields.¶
The following fields Required when running with
--auth enabled or when connecting to an
BI Connector for Atlas instance.
Username of the MongoDB user who is authenticated to use your target database.
You can specify the following authentication options after your username as URI-style query parameters:
To authenticate as user
The authenticated user's password.
(Optional) If TLS/SSL is enabled, fill in the TLS/SSL form fields.¶
Access the TLS/SSL form fields by clicking Details >>, then the SSL tab. The following parameters are available and may be required, depending on your TLS/SSL configuration:
The location of the client/server key file.
The location of the client/server certificate file.
SSL CA File
The location of the file containing a list of trusted certificate authorities.
The location of the file containing a list of permitted ciphers.
RSA Public Key
The location of the PEM file that contains the RSA public key.
The BI Connector for Atlas uses TLS/SSL but does not require any TLS/SSL settings to be configured in your system DSN.
Test button to test the ODBC connection.¶
If the connection is successful, click OK to add the DSN . If the connection fails, check to make sure your MongoDB user is correctly authenticated for the database named in the connection.