Navigation

Connect from Tableau Desktop (Windows)

For M10+ clusters that have enabled the BI Connector for Atlas, the Connect dialog provides the details to connect via the BI Connector for Atlas.

Screeenshot of the Atlas BI connection dialog.

The BI Connector for Atlas is only available for M10+ clusters.

Prerequisites

MySQL Enterprise Edition ODBC Driver

This procedure uses the Enterprise edition of the MySQL ODBC driver. MySQL Enterprise uses OpenSSL, which is compatible with BI Connector for Atlas for TLS/SSL connections.

If you have a community edition of the driver, to install the Enterprise edition for the same driver version, you must uninstall the community edition. To uninstall, you can either:

  • Remove the driver by using the .msi for community edition.
  • Remove the driver from the Control Panel > Programs and Features screen.

Tableau Desktop 10.5

This procedure uses Tableau Desktop 10.5.

Note

The default installation of the Tableau Desktop 10.5 includes the installation of various drivers, including the community edition of the MySQL ODBC driver.

During installation, you can customize the installation to not download the drivers. Or, if you have already installed Tableau with default settings, see the ODBC prerequisities section for installing the Enterprise edition.

Connect from Tableau Desktop

1

Start Tableau Desktop.

2

Connect to the BI Connector for Atlas.

Select the MongoDB BI Connector as your Data Source for your Tableau book.

  1. From the left-hand navigation, under To a server, click More … and select MongoDB BI Connector.

  2. Enter the following fields:

    Field Action
    Server Enter the Hostname specified in the Atlas connect dialog.
    Port Enter the Port specified in the Atlas connect dialog.
    Username

    Enter either the user specified in the Atlas connect dialog or a different MongoDB user for the cluster.

    The user is specified in the format:

    <username>?source=<database-name>
    

    where the <database-name> is the authentication database for the user.

    Password Enter the password corresponding to the entered User.
    Require SSL Leave unselected. Although unselected, all communications still occur over SSL as handled by ODBC.

    For example:

    Tableau Desktop MongoDB BI Connector Dialog.
  3. Click Sign In.

3

Click the Test button to test the ODBC connection.

If the connection is successful, select the Database and Table. If the connection fails, check the MongoDB user credentials and the IP whitelist.

Additional Reference

For more information on the MongoDB Connector for Business Intelligence, see MongoDB Connector for BI Manual.