MongoDB Connector for BI

About the MongoDB Connector for BI


The MongoDB Connector for BI and associated utilities are compatible only with MongoDB server version 3.2 or greater.

The MongoDB Connector for Business Intelligence (BI) allows users to create queries with SQL and visualize, graph, and report on their MongoDB Enterprise data using existing relational business intelligence tools such as Tableau, MicroStrategy, and Qlik.

The MongoDB Connector for BI acts as a layer that translates queries and data between a mongod or mongos instance and your reporting tool. The BI Connector stores no data, and purely serves to bridge your MongoDB cluster with business intelligence tools.


System Components

A complete BI system includes the following components:

  • MongoDB database: Data storage.
  • BI Connector: Provides a relational schema and translates SQL queries between your BI tool and MongoDB.
  • ODBC data source name (DSN): Holds authentication and connection configuration data.
  • BI Tool: Data visualization and analysis.

Most BI tools can import data from a DSN. Setting up a DSN which points to your BI Connector instance allows you to use a wide range of BI tools and SQL clients with a single data source configuration.

Your BI tool and your DSN always run on your local desktop, but your database and your BI Connector instance may be local, on premises, or hosted. The following sections describe possible configurations for a BI system.

Hosted Database and BI Connector

MongoDB Atlas provides a fully hosted solution for both MongoDB and BI Connector. Atlas dedicated clusters (size M10+) offer an integrated BI Connector instance as an option. In this scenario, the database and BI Connector applications both run on Atlas, and you set up your DSN with connection information provided by Atlas.

Hosted DB and BI Connector

Hosted Database and On Premises BI Connector

If you have an Atlas deployment smaller than M10 (including the Atlas free tier), or if your MongoDB instance is not hosted on Atlas, you can run BI Connector locally and specify a remote database address with the --mongo-uri option when you start the BI Connector’s mongosqld process.

On Premises DB and Local BI Connector

On Premises Database and BI Connector

Your organization may have installations of both MongoDB and BI Connector elsewhere on your network, in which case you can set up your DSN to point to the BI Connector server address.

On Premises DB and BI Connector