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.
The MongoDB Connector for Business Intelligence for Atlas (BI Connector) is only available for
The BI Connector is a powerful tool which provides users
SQL-based access to their MongoDB databases. As a result, the
BI Connector performs operations which may be CPU and memory
intensive. Given the limited hardware resources on
M20 cluster tiers, you may experience performance degradation of
the cluster when enabling the BI Connector. If this occurs,
upgrade to an
M30 or larger cluster or disable the
Start Tableau Desktop.¶
Connect to the BI Connector for Atlas.¶
Select the MongoDB BI Connector as your Data Source for your Tableau book.
- From the left-hand navigation, under To a server, click More ... and select Other Databases (ODBC).
- Select the DSN that you just created from the DSN list.
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 database user for the cluster.
The user is specified in the format:
<database-name>is the authentication database for the user.
Password Enter the password corresponding to the entered User.
- Click Sign In.
For more information on the MongoDB Connector for Business Intelligence, see MongoDB Connector for BI Manual.