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 or Update BI Connector On Premises.
The MongoDB Connector for BI and associated utilities are compatible with all currently supported MongoDB server versions.
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 ODBC driver provides connectivity between 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.