MongoDB Connector for BI Components¶

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:

mongodrdl generates database schema information for use with the MongoDB Connector for BI.
mongosqld proxies incoming queries between SQL clients and a MongoDB server.
mongotranslate translates 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 mongosqld and a MySQL client.

← Schema Management Changes in 2.11 mongosqld →