MongoDB Connector for
Business Intelligence

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 managed (Atlas 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
Ready to get started?

Launch a new app or migrate to MongoDB Atlas with zero downtime