Navigation

Connect from Tableau Desktop

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.

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

Prerequisites

Procedure

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 Other Databases (ODBC).

  2. Select the DSN that you just created from the DSN list.

  3. Enter the following fields in the Connection Attributes pane:

    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:

    copy 
    <username>?source=<database-name>

    where the <database-name> is the authentication database for the user.
    Password Enter the password corresponding to the entered User.

    For example:

    Tableau Desktop Other Databases (ODBC) Dialog.

  4. Click Sign In.

1

Start Tableau Desktop.

2

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, select your DSN from the list and click Connect.
  3. Once the connection test completes, click Sign In.

Additional Reference

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

© MongoDB, Inc 2008-present. MongoDB, Mongo, and the leaf logo are registered trademarks of MongoDB, Inc.