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.
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.
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.
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
The MongoDB BI Connector provides your BI platform information about the schema of the MongoDB collection you want to analyze
It receives SQL queries from your BI platform and translates them into appropriate MongoDB queries, which are sent to MongoDB
The connector then gets back the results, converts them into a tabular format, and sends them to your BI platform for visualization
The BI Connector is downloadable for on-premises deployment. It is available with MongoDB Enterprise Advanced.