Connect from Tableau
On this page
This page describes how to connect to Atlas Data Federation with Tableau using the Tableau Named Connector.
Prerequisites
A federated database instance that is mapped to one or more data stores.
NoteIf some or all of your data comes from an Atlas cluster, you must use MongoDB version 5.0 or greater for that cluster to take advantage of Atlas SQL.
- Tableau Desktop or Server.
Procedure
The following procedure guides you through installing the necessary tools, finding your federated database instance connection information, and connecting to your federated database instance with Tableau.
Download the JDBC Driver and Tableau Connector
Download the MongoDB JDBC Driver.
- Download the latest
MongoDB JDBC Driver version. Select the
all.jar
file, which includes necessary driver classes and dependencies. Move the downloaded
.jar
file into the appropriate directory for your operating system:Operating SystemFolder PathWindowsC:\Program Files\Tableau\Drivers
MacOS~/Library/Tableau/Drivers
Download and install the Tableau Named Connector.
- Download the Taco file.
Move the downloaded Taco file into the appropriate directory for your operating system:
Operating SystemFolder PathWindowsC:\Program Files\Tableau\Connectors
MacOS~/Library/Tableau/Connectors
Get Your federated database instance Connection Information
Connect with Tableau
Enter the connection information that you copied from Atlas Data Federation.
Enter the following information:
MongoDB URI | Your federated database instance URI from step 5 of Get Your federated database instance Connection Information. |
---|---|
Database | Your database from step 5 of Get Your federated database instance Connection Information.
The default is``myFederatedVirtualDatabase``. |
Username | The MongoDB user to connect with. |
Password | The MongoDB user's password. |