Learn the "why" behind slow queries and how to fix them in our 2-Part Webinar.
Register now >
Docs Menu
Docs Home
/
Tools
/
SQL Interface
Docs Home
/
Tools
/
SQL Interface
Docs Home
/
Tools
/
SQL Interface

Install the MongoDB SQL Interface

The MongoDB SQL Interface lets you query your MongoDB data using standard SQL-based BI tools like Tableau, Power BI, and DBeaver.

To get started, use the following process:

1

Setup the server and schema.

Follow the instructions in Server Setup to configure your database to accept SQL connections. The setup process depends on your deployment type:

  • MongoDB Atlas: Connect to your cluster and let Atlas automatically configure the federated database instance in the background.

  • Enterprise Advanced (EA): Configure your self-managed database and generate a SQL schema for your collections using the MongoDB SQL Schema Builder CLI. To learn more, see the MongoDB SQL Schema Builder README.

2

Setup the driver.

Follow the instructions in Driver Setup to install the correct driver (JDBC or ODBC) on your client machine.

3

Connect your BI tool.

Follow the instructions in Connect Your BI Tool to configure your specific BI tool to connect to your MongoDB database.

A horizontal flow diagram showing three icons connected by right-facing arrows. The flow demonstrates that the MongoDB drivers and connectors act as the bridge between the MongoDB database and the BI tool.
click to enlarge

Back

Migration Guide

Next

Server Setup

On this page