CONNECTORS

MongoDB BI Connector for Enterprise Advanced

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.

Enterprise Advanced is the best way to run MongoDB yourself. When working with SQL-based tools, the 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 hidden in your multi-structured data.

Atlas SQL Interface, Connectors, and Drivers

Through the Atlas SQL Interface, directly interact with MongoDB’s JSON-like document data to quickly visualize, graph, and report on live Atlas data using custom SQL and native features, right from your preferred tool’s interface. Perfect for Atlas customers who need to analyze their data.
Atlas SQL Interface illustration.
general_features_data_analytics

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.

general_features_realtime

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.

TRUSTED BY
Tableau logo image
Power BI logo image

Benefits

general_features_automation

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.

atlas_integration

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.

misc_achievement

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.

general_features_global_clusters

Secondary node support

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.

How it works

Connect

Step 1

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

Receive

Step 2

Extend your MongoDB data by including it within your analytic ecosystem, allowing you to gain access to your rich MongoDB data from within your BI platform.

Analyze

Step 3

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.
example