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
As a result, the MongoDB Connector for BI no longer requires
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.
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.
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:
MongoDB BI Connector ODBC Driver
MySQL JDBC Driver
Microsoft Power BI