MongoDB BI Connector ODBC Driver

Overview

The MongoDB BI Connector ODBC Driver provides connectivity between a SQL client and the MongoDB Connector for BI. The MongoDB BI Connector ODBC Driver enables users to create a Data Source Name (DSN) and connect a variety of BI tools to the BI Connector. It includes the BI Connector authentication plugin, which implements the client side of MongoDB-supported authentication mechanisms.

Note

The MongoDB BI Connector ODBC Driver connects the DSN to the BI Connector.

click to enlarge

Compatibility

The MongoDB BI Connector ODBC Driver is compatible with BI Connector version 2.5 and later. The latest production version of BI Connector is available from the MongoDB Download Center.

Supported Platforms

The MongoDB BI Connector ODBC Driver is available for:

• Windows (32-bit and 64-bit)

  Note

  Before installing the MongoDB BI Connector ODBC Driver for Windows, ensure that the Microsoft Visual C++ Redistributable for Visual Studio 2015 is installed on your system.

• macOS

  Important

  The 1.0.16 edition of ODBC Manager included with the MongoDB BI Connector ODBC Driver is not compatible with macOS Catalina or later versions of macOS. If you are on Catalina or a later version of macOS, download and install the latest version (1.0.19) of ODBC manager.

• Ubuntu 14.04 and 16.04

• RHEL 7

Workaround for Unsupported Platforms

1. Install the MySQL Cleartext Authentication plugin for your platform.

2. Download and install the Oracle MySQL ODBC driver compatible with your platform from the MySQL Connector/OCBC Downloads page.

3. Before connecting, ensure that the Cleartext plugin is enabled.

Using the MongoDB BI Connector ODBC Driver

Configure your system to use the MongoDB BI Connector ODBC Driver by setting up a DSN. A DSN holds configuration information about your BI Connector instance, including server address, port number, and login credentials. See Create a System DSN for instructions on setting up a DSN on your system.