How to Connect MongoDB to Tableau Cloud

Getting your rich, flexible business data out of MongoDB and into a powerful visualization tool like Tableau Cloud can feel like a game-changer. Suddenly, all that NoSQL data becomes accessible for building the dashboards and reports your team needs. This guide provides a clear roadmap for connecting MongoDB to Tableau Cloud covering the essential steps and how to handle common roadblocks along the way.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Why Connect MongoDB to Tableau in the First Place?

MongoDB is fantastic for storing diverse, evolving data, especially for applications dealing with user profiles, product catalogs, or event tracking. It's built for developer speed and flexibility. Tableau, on the other hand, is built for business intelligence and visual analysis. It thrives on structured data that it can slice, dice, and turn into insightful charts.

Connecting them gives you the best of both worlds:

• Visualize Application Data: Directly analyze user behavior, content engagement, or operational logs stored in your application's database without needing to move it.
• Unlock Business Insights: Empower non-technical team members - from marketing to operations - to create their own reports and explore data without needing to know MongoDB-specific query languages.
• Unified Reporting: Combine your MongoDB data with other data sources in Tableau (like Google Analytics or Salesforce) to get a complete picture of your business.

The goal is to bridge the gap between your operational database and your analytical needs so you can make smarter decisions based on real-time application data.

Prerequisites: What You’ll Need Before Connecting

Before you jump in, let’s gather the necessary tools and credentials to make the process as smooth as possible. Having these ready will save you a lot of time switching between tabs and searching for information.

• Tableau Cloud Account: You’ll need valid user credentials with permissions to create new data source connections and publish workbooks.
• MongoDB Atlas Account: This guide focuses on MongoDB's cloud offering, Atlas. You'll need access to your Atlas project with an M10 or higher cluster. The free tier (M0) and smaller clusters (M2/M5) do not support the BI Connector.
• Administrative Permissions: You should have at least Project Data Access Admin rights in your MongoDB Atlas project to configure the BI Connector and IP access lists.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Understanding the MongoDB BI Connector

This is the most important component of the entire process. You can’t connect Tableau directly to a standard MongoDB instance because they speak different languages. Tableau expects to communicate using SQL (Structured Query Language), while MongoDB stores data in a document-oriented format called BSON.

What is the BI Connector and Why Do You Need It?

The MongoDB BI Connector acts as a translator. It sits between your MongoDB database and Tableau, receiving SQL queries from Tableau and converting them into a language that MongoDB understands. It then takes MongoDB’s document-based results and "relationalizes" them, presenting the data back to Tableau as if it were coming from a traditional SQL table.

Without this connector, you would need to set up a complex ETL (Extract, Transform, Load) pipeline to move and restructure your data into a SQL database before Tableau could even access it. The BI Connector does this transformation work for you on the fly, enabling a near real-time connection to your live application data.

Enabling the BI Connector in MongoDB Atlas

Activating the BI Connector is the first major step inside your MongoDB environment. Fortunately, Atlas makes this relatively straightforward.

1. Log into your MongoDB Atlas account and navigate to the project containing your cluster.
2. From the Database view, find your desired cluster and click on its name.
3. Click the "BI Connector" tab near the top of the screen.
4. If it's your first time, you’ll see an intro screen. Follow the prompts and click the "Enable BI Connector" button.
5. Atlas will begin provisioning the service. This can take a few minutes. Once complete, you will be presented with the connection details needed for Tableau. This includes a special connection string (hostname) and port number. Keep this page open, you'll need this information shortly.

Connecting Tableau Cloud to MongoDB Atlas: A Step-by-Step Guide

With the BI Connector enabled, you’re ready to establish the connection from within Tableau Cloud. Follow these steps carefully, paying close attention to the IP configuration, which is a common stumbling block.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Step 1: Get Your Connection String from Atlas

Back on the BI Connector page in Atlas, look for the connection details section. It will provide a "hostname," which is a unique URL for your BI Connector. You'll also see the port number, which is typically 27015. Additionally, you'll need the database username and password that Tableau will use to authenticate. It's a best practice to create a dedicated database user for analytics with read-only permissions on the necessary collections.

Step 2: Add Tableau Cloud's IP Addresses to Your Atlas IP Access List

For security, MongoDB Atlas blocks all incoming connections by default unless the source IP address is on an "IP Access List." Since Tableau Cloud is a multi-tenant service, it doesn't have a single, static IP address. Instead, Tableau provides a list of IP ranges that its services use.

This is the most critical and often missed step.

1. First, find Tableau's current list of IPs. They maintain this on their official documentation page. A quick search for "Tableau Cloud IPs" will lead you to the right page for your specific Cloud pod region.
2. In MongoDB Atlas, navigate to Network Access under the "Security" section in the left-hand menu.
3. Click "Add IP Address."
4. A modal will appear. For each IP address or range provided by Tableau, you'll need to create an entry here. Paste the IP address/range into the "Access List Entry" field and add a descriptive comment like "Tableau Cloud Access" so you know what it’s for later.
5. Click Confirm after adding all the necessary IP ranges. It may take a few minutes for the firewall changes to fully propagate.

If you skip this step, Tableau will not be able to reach your database, and your connection attempt will time out or be refused.

Step 3: Make the Connection from Tableau Cloud

Now, it's time to open up Tableau Cloud and put all the pieces together.

1. Log into your Tableau Cloud site.
2. On the Home or Explore page, click New > Workbook.
3. This will open the "Connect to Data" screen. In the list of connectors, search for and select "MongoDB BI Connector."
4. A configuration dialog box will appear. Fill in the fields using the information from Atlas:
5. Check the "Require SSL" box. Atlas BI connections require a secure connection, so this is mandatory.
6. Click "Sign In."

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Step 4: Select Your Data and Start Building

If the connection is successful, you'll be taken to the Data Source screen within Tableau. On the left pane, you’ll see a list of available databases. Once you select a database, the BI Connector will present your MongoDB collections as if they were tables.

Drag the collection you want to analyze onto the canvas. Tableau will query a sample of the data and show you the fields it has detected. You can now move to a worksheet and start dragging and dropping fields to build your first visualizations!

Troubleshooting and Best Practices

Even with a clear guide, you might run into bumps. Here are some common problems and tips for a better experience.

Common Connection Issues:

• Connection Timed Out: 99% of the time, this is an IP Access List issue. Double-check that all the correct Tableau Cloud IP ranges are correctly added in Atlas and have had time to become active.
• Authentication Failed: Verify your username and password. Remember to use the database user credentials, not your MongoDB Atlas account login.
• An 'Unexpected Error' Occurred: Ensure the BI Connector is still running and healthy within the Atlas UI. Rarely, it can be provisioned but in a non-functional state. Toggling it off and on might help.
• Poor Performance: Extremely complex, deeply nested JSON documents can be slow for the BI Connector to translate. For slow dashboards, consider creating a Tableau Extract.

Best Practices:

• Use Extracts for Performance: For dashboards that are viewed frequently but don't require millisecond-level data accuracy, a Tableau Extract is your best friend. Extracts pull the data into Tableau's high-performance in-memory engine, making dashboard interactions incredibly fast. You can schedule these extracts to refresh regularly (e.g., hourly or daily).
• Flatten Data When Possible: If you control the data structure in MongoDB, try to avoid excessively deep nesting or inconsistent schemas within a collection you intend to analyze. A flatter, more predictable structure will translate better and perform faster.
• Use the MongoDB Aggregation Framework: For extremely large datasets, you can perform pre-aggregation directly within MongoDB using its powerful Aggregation Framework. Create a new collection that contains summarized data and point Tableau to that collection instead. This can drastically reduce the amount of data transferred and improve query performance.

Final Thoughts

Successfully connecting MongoDB to Tableau opens up a powerful new avenue for data analysis, transforming your live application data into a strategic business asset. The process hinges on correctly configuring the BI Connector and, most importantly, setting up the IP Access List to grant Tableau Cloud secure access to your database.

While setting up these connections is powerful, you might notice that the work of building meaningful dashboards is still a slow, manual process that requires a lot of specialized knowledge in a tool like Tableau. For teams that want to move faster, we built Graphed. After connecting your data sources in a few clicks, you can simply describe the dashboard you want in plain English - like "create a report showing user signups and sales from Shopify over the last 90 days" - and our AI builds it for you in seconds, no configuration or BI tool training necessary.