Docs Menu

What is the MongoDB Connector for BI

Note

The MongoDB Connector for BI and associated utilities are compatible with all currently supported MongoDB server versions.

Traditional business intelligence tools work with flat, tabular data. These tools aren't sophisticated enough to understand three-dimensional data stored in MongoDB databases.

The MongoDB Connector for Business Intelligence (BI) allows you to create queries with SQL to visualize, graph, and report on your three-dimensional MongoDB data using relational business intelligence tools such as Tableau and Power BI.

Note

As an alternative to using third-party data visualization tools and the BI Connector, you can use MongoDB Charts to create data visualizations directly from your MongoDB collections.

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.

Diagram showing that other BI tools communicate with the DSN, which communicates with MongoDB's BI Connector, which in turn communicates with the MongoDB database.

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.
JDBC and ODBC drivers
Provides a standard method to connect to the BI Connector and MongoDB databases from a BI Tool. Depending on what your BI Tool supports, you can use JDBC and ODBC drivers to connect to the BI Connector.
BI Tool
Retrieve, visualize, and report on data from a database.

Your BI Tool and Driver typically run on your local machine. Your database and your BI Connector instance can run on your local machine, in a data center, or hosted in the cloud.

The following sections describe possible configurations for a BI system.

Note

If you don't want to install and manage the BI Connector, you can use MongoDB Atlas, our fully-managed database-as-a-service. Databases hosted on MongoDB Atlas natively support the MongoDB Connector for BI and make it easy to start analyzing your data with your preferred BI tools. To get started, create an MongoDB Atlas cluster.

In this scenario, the database and BI Connector applications both run on MongoDB Atlas, and you set up your DSN with connection information that MongoDB Atlas provides.

Hosted DB and BI Connector

If you have an MongoDB Atlas deployment smaller than M10 (including the MongoDB Atlas free tier), or if your MongoDB instance is not hosted on MongoDB 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

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

For testing and all-in-one-box local experimentation, you can run MongoDB and BI Connector on your desktop. This is the simplest configuration, perfect for quickly looking over the possibilities for data visualization with BI Connector.

Learn more about setting up a local BI Connector test installation in the Quick Start Guide.

Give Feedback
© 2021 MongoDB, Inc.

About

  • Careers
  • Legal Notices
  • Privacy Notices
  • Security Information
  • Trust Center
© 2021 MongoDB, Inc.