Navigation

Create a System DSN

The following steps describe how to create a system Data Source Name (DSN) for the BI Connector for Atlas. A DSN is a saved configuration which describes a database connection to be used by an ODBC driver. Once the DSN is created, 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:

1

Choose the program version (64-bit or 32-bit) which is appropriate for your system and ODBC driver version.

2
Screenshot of the Windows ODBC Administrator application
3

Select either the MongoDB ODBC 1.1.0 ANSI Driver or the MongoDB ODBC 1.1.0 Unicode Driver, then click OK.

Info With Circle IconCreated with Sketch.Note

ANSI ODBC/Connectors offer better performance but have a limited character set. Unicode ODBC/Connectors support a wider character set but may be less performant.

4

Click the Details button to expose the lower half of the form.

The following form fields are required:

Field NameDescription
Data Source NameA name of your choice.
TCP/IP ServerThe hostname specified in the Atlas connect dialog.
PortThe IANA port number specified in the Atlas connect dialog. The default is 27015.
DatabaseThe name of the database to which you want to connect.
User

Enter either the user specified in the Atlas connect dialog or another database user with access to the database.

The user is specified in the following format:

<username>?source=<database-name>

where the <database-name> is the authentication database for the user. If admin is the authentication database, you can omit ?source=<database-name>.

  • If you are using Username and Password (SCRAM-SHA-1) authentication, the expected authenticating database is admin.
  • If you are using LDAP (PLAIN) authentication, the expected authenticating database is $external:

    Beaker IconExample

    myTestUser?source=$external

PasswordThe password that corresponds to the specified User.
5

If the connection is successful, click OK to add the DSN . If the connection fails, check to make sure your database user is correctly authenticated for the database named in the connection.

Give Feedback