MongoDB Connector for BI Components
On this page
Changed in version 2.0: Version 2.0 of the MongoDB Connector for BI introduces a new architecture that replaces
the previous PostgreSQL foreign data wrapper with the new
mongosqld.
As a result, the MongoDB Connector for BI no longer requires mongobiuser and
mongobischema.
If you are using an older release of the MongoDB Connector for BI, you should upgrade to 2.0 by following the steps in Install BI Connector On Premises.
Note
The MongoDB Connector for BI and associated utilities are compatible only with MongoDB server version 3.2 or greater.
The following tools are available for use with the MongoDB Connector for BI:
mongodrdlgenerates database schema information for use with the MongoDB Connector for BI.mongosqldproxies incoming queries between SQL clients and a MongoDB server.mongotranslatetranslates a given SQL query into a MongoDB aggregation pipeline.The MongoDB BI Connector ODBC Driver provides connectivity between SQL clients and the MongoDB Connector for BI.
The MySQL JDBC Driver provides an alternative connection method for some SQL clients and the MongoDB Connector for BI.
The C Authentication Plugin and JDBC Authentication Plugin facilitate secure transmission of authentication credentials between
mongosqldand a MySQL client.
Choosing a Driver
Depending on your BI tool of choice, you connect to the BI Connector with the MongoDB BI Connector ODBC Driver or with the MySQL JDBC Driver. The following table lists some common BI tools and their compatible drivers:
BI Tool | MongoDB BI Connector ODBC Driver | MySQL JDBC Driver |
|---|---|---|
Tableau | ||
MicroStrategy | ||
Microsoft Power BI | ||
Microsoft Excel | ||
MySQL Workbench | ||
DBeaver |