MongoDB World LogoExplore MongoDB World 2019 announcements

MongoDB Connector for Business Intelligence

Connect MongoDB to your favorite BI platforms to answer your organization’s most important questions.

MongoDB’s flexible data model and dynamic schema allow you to store data in rich, multi-dimensional documents to quickly build and evolve your apps. But your Business Intelligence platform expects fixed schemas and tabular data.

The MongoDB BI Connector lets you use MongoDB as a data source for your BI and analytics platforms. Seamlessly create the visualizations and dashboards that will help you extract the insights and hidden value in your multi-structured data.

Draw insights from new streams of data

Analyze data generated by your modern apps - web, mobile, social, and IoT - alongside traditional data stored in your relational databases.

BI on MongoDB data made easy

No more complex ETL processes that move data from MongoDB into other systems for analysis. Save time, money, and effort.

Reduced reliance on custom ETL jobs

Free up valuable developer resources by removing the need for complex ETL processes that move data from MongoDB into other systems for analysis.

Streamlined BI architecture

Use your favorite BI platforms to access your MongoDB cluster directly, allowing you to generate insights quickly and with less effort.

Works with your BI platform of choice

The BI Connector is compatible with many popular BI and analytics platforms. Use MongoDB as a data source for Tableau, Excel, MicroStrategy, Microsoft Power BI, Qlik, and many more.

Better answers

Reduce the likelihood of inconsistent analysis by allowing data consumers to connect directly to live operational data and eliminating the usage of ungoverned data transformations.

Minimize impact

Reduce the performance impact of analytical workloads on other applications that rely on the same database by directing queries from the BI Connector to a secondary within your cluster.

Fully managedAtlas Exclusive

Generate insights from data managed by MongoDB Atlas in a matter of minutes. The BI Connector for Atlas is a turnkey service that automates provisioning, patching, and failover.

How It Works

1. Connect

The MongoDB BI Connector provides your BI platform information about the schema of the MongoDB collection you want to analyze

2. Receive

It receives SQL queries from your BI platform and translates them into appropriate MongoDB queries, which are sent to MongoDB

3. Analyze

The connector then gets back the results, converts them into a tabular format, and sends them to your BI platform for visualization


BI Connector

The BI Connector is downloadable for on-premises deployment. It is available with MongoDB Enterprise Advanced.

BI Connector for AtlasNew

The BI Connector for Atlas is available as a turnkey service for dedicated clusters running in MongoDB Atlas, the cloud database service for MongoDB.