Dremio Jekyll

Power BI on MongoDB

Connect Power BI to MongoDB. Replica Sets. Sharded Clusters. Dremio has you covered.

Download Dremio

Analyzing Data in MongoDB is Hard

Today’s strategic apps for social, mobile, and web applications are built on MongoDB. This fast, agile database allows developers to build and evolve applications quickly. Companies like MongoDB because it is cost effective and reduces their time to value.

But MongoDB manages data in JSON documents and has no support for standard SQL. As a result, Power BI is limited in how it works with MongoDB, and most companies copy their data into a relational database for analytics. And while this makes Power BI work great, moving the data can be a massive engineering project.

MongoDB and Dremio

Dremio Simplifies and Accelerates Analytics for MongoDB

Dremio connects Power BI to your MongoDB clusters, and accelerates your data and queries. SQL queries that are issued to Dremio by Power BI are rewritten in MongoDB’s query language and automatically pushed down to the replicas. Query results are transformed into rows, including complex data structures like arrays and sub-documents. For joins and other operations that aren’t supported by MongoDB, processing is transparently performed in Dremio’s distributed SQL execution engine. Learn more about how Dremio works.

Accelerate Your Data

With Dremio Reflections™, your data is automatically optimized in columnarized, compressed data structures called reflections. Dremio’s reflections can accelerate your analytics by 10-1000x. Learn more about Dremio Reflections™.

Offload Your Analytics With Dremio

MongoDB can provide exceptional performance for write-intensive workloads. But full table scans and other scan-intensive queries can crush performance and disrupt your SLA. Dremio can offload your analytical queries by maintaining an up-to-date cache of your data in a compressed, columnarized representation that is optimized for analytics.

You have full control for how this cache is maintained - via secondaries, full or incremental, and according to a freshness SLA that you configure. Dremio can issue a single read on your data when you choose, and process all your analytics without adding load to your operational deployment.

Not Just MongoDB, All Your Data Sources

Dremio is more than a solution for Elasticsearch - it works for all your data sources. Relational databases, Elasticsearch, Hadoop, S3, and more. Dremio gives you the same rich query access to any source, and accelerates your data to make analysis interactive and fun.

Technical Details for MongoDB

  • Supports MongoDB 3.0 and later.
  • Supports replica sets and sharded clusters.
  • Rewrites SQL in MongoDB Query Language, including Aggregation Pipelines.
  • Documentation for Dremio and Power BI.