MongoDB Connector for BI Components

On this page

Choosing a Driver

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 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 mongosqld and 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

← Sampling Type Conflicts mongosqld →