MongoDB Connector for BI¶
On this page
About the MongoDB Connector for BI¶
Note
The MongoDB Connector for BI and associated utilities are only available with MongoDB Enterprise 3.2 and greater.
The MongoDB Connector for Business Intelligence (BI) allows users to visualize their MongoDB Enterprise data using existing relational business intelligence tools such as Tableau.
These tools expect to connect to a data source and find data in tabular form following a fixed schema. This presents a challenge when working with MongoDB’s flexible schema and rich, multi-dimensional, documents.
The MongoDB Connector for BI acts as a layer that passes queries and
data between a mongod
or mongos
instance and your
reporting tool. The MongoDB Connector for BI stores no data, and purely serves to bridge your
MongoDB server with business intelligence tools.
New in Version 2¶
Improved Server-Side Execution¶
The MongoDB Connector for BI delivers significant performance and scalability improvements by moving as much execution as possible to the underlying MongoDB instance. Pushing execution down to the server reduces network latency and reduces bandwidth consumption.
This approach also reduces memory and CPU consumption in the MongoDB Connector for BI itself.
Pass-through Authentication¶
The user authentication process is now passed through the MongoDB Connector for BI to the underlying MongoDB instance. Users now authenticate as a user already created within MongoDB.
Simplified Architecture¶
The MongoDB Connector for BI package is now trimmed down from four separate components to two:
mongodrdl
- This tool connects to a MongoDB instance and generates a Document-Relational Definition Language (DRDL) file, which maps a given collection shape to relational schema.
mongosqld
Once installed and run as a daemon,
mongosqld
responds to SQL queries, requests for DB information, and schema from the requesting BI tool via the MySQL wire protocol.mongosqld
requires at least one Document Relational Definition Language file to start. You will need to have defined your schema withmongodrdl
before startingmongosqld
.
SQL Compatibility¶
MongoDB Connector for BI Version 2.x is compatible with SQL-99 SELECT statements, and uses the MySQL wire protocol.