Navigation

Connect from Tableau Desktop without Authentication or TLS/SSL

On this page

Prerequisites

Connecting Tableau to the MongoDB Connector for BI requires the following:

  • Tableau version 10.3 or later
  • A running mongod instance
  • A running mongosqld instance

Connecting Tableau to the MongoDB Connector for BI requires the following:

  • Tableau version 10.4 or later
  • A running mongod instance
  • A running mongosqld instance

Procedure

1

Download and install the MongoDB ODBC driver.

Download the MongoDB ODBC Driver for BI Connector and run the Windows installer (.msi).

2

Create a system DSN.

To securely connect Tableau to the BI Connector, a system DSN configured to use the MongoDB ODBC driver is required. To create a system DSN, follow the steps below:

1

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.

2

Select the System DSN tab.

3

Click the Add button.

Screenshot of the Windows ODBC Administrator application
4

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.

Note

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.

5

Fill in the necessary form fields.

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

The following form fields are required:

Field Name Description
Data Source Name A name of your choice.
TCP/IP Server Address of the server where your mongosqld process is running. If you have enabled BI Connector on MongoDB Atlas, you can find the hostname of the server where mongosqld is running in the connection information for your cluster.
Port Port number of your mongosqld process.
Database The name of the database to connect to, e.g. test.
6

Click the Test button to test the ODBC connection.

If the connection is successful, click OK to add the DSN.

3

Start Tableau.

Start the Tableau Desktop application or restart it if it is already running.

4

Connect using Tableau.

  1. In the left-side navigation under To a server, click on More… then click Other Databases (ODBC).
  2. From the Other Databases (ODBC) dialog box, select your DSN from the dropdown and click Connect.
  3. Once the connection test completes, click Sign In.
1

Download and install the MongoDB ODBC driver.

Download the MongoDB ODBC Driver for BI Connector and run the macOS installer (.dmg).

2

Create a system DSN.

To securely connect Tableau to the BI Connector, a system DSN configured to use the MongoDB ODBC driver is required. To create a system DSN, follow the steps below:

1

Launch ODBC Manager.

Note

ODBC Manager is included with the MongoDB ODBC driver.

Important

The 1.0.16 edition of ODBC Manager included with the MongoDB ODBC driver is not compatible with macOS Catalina. If you are on Catalina, download and install the latest version (1.0.19) of ODBC manager.

2

Click System DSN, then click Add.

ODBC Manager DSN configuration
3

Select a MongoDB ODBC driver from the list of available drivers.

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

Note

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.

4

Enter a Data Source Name (DSN).

Optionally enter a Description.

Note

Do not close the setup window. Proceed to the next step.

5

Add the necessary keywords.

  1. Add a keyword value pair by clicking the Add button.
  2. Modify the Keyword by double-clicking on it, entering the desired keyword, then pressing enter.
  3. Modify the Value by double-clicking on it, entering the desired keyword, then pressing enter.

Using the procedure above, add the following keywords:

Keyword Value
SERVER

The hostname or IP address of the MongoDB Connector for BI host.

Important

Use 127.0.0.1 to connect via TCP to localhost. Specifying a value other than an IP address, will attempt to connect via Unix socket.

PORT The IANA port number for the MongoDB Connector for BI. The default is 3307.
DATABASE

The database to use after connecting.

Note

Required when connecting with Microsoft Excel.

For the complete list of ODBC parameters, see Connector/ODBC Connection Parameters.

For example, your user DSN configuration should look similar to the following:

ODBC Manager DSN configuration

Note

Do not close the setup window. Proceed to the next step.

6

Click OK to finish creating the DSN.

3

Start Tableau.

Start the Tableau Desktop application or restart it if it is already running.

4

Connect using Tableau.

  1. In the left-side navigation under To a server, click on More… then click Other Databases (ODBC).
  2. From the Other Databases (ODBC) dialog box, select your DSN from the dropdown and click Connect.
  3. Once the connection test completes, click Sign In.