Navigation

Installation

Note

The MongoDB Connector for BI and associated utilities are only available with MongoDB Enterprise 3.2 and greater.

To set up MongoDB Connector for BI with a business intelligence tool such as Tableau, follow the steps on this page.

Supported Platforms

MongoDB Connector for BI supports PPC64LE systems running Red Hat Enterprise Linux 7.1+; s390x systems running Red Hat Enterprise Linux 7.2+; and the following x86_64 operating systems:

Red Hat Enterprise Linux/CentOS 6.2+ 7.0+
Debian 7.1+ “Wheezy” 8.1+ “Jessie”
Ubuntu 14.04 “Trusty”  
SUSE Enterprise Linux 11 12
OS X 10.10  
Windows Windows 7/Windows Server 2008 R2 and later  

Install the MongoDB Connector for BI

1

Uninstall old versions of the MongoDB Connector for BI (optional).

If you have an older version of the MongoDB Connector for BI installed, uninstall it.

Red Hat Enterprise Linux and CentOS
sudo yum remove mongodb-bi*
Debian and Ubuntu
sudo apt-get remove mongodb-bi*
2

Install OpenSSL.

OS X

Install Homebrew and run the following:

brew update && brew install openssl
Linux
Ensure that your system has its OpenSSL package installed.
Windows
The MongoDB Connector for BI for Windows bundles the OpenSSL libraries, so you do not need to take any special action.
3

Install the MongoDB Connector for BI.

Download the MongoDB Connector for BI for your operating system from the MongoDB Download Center.

Extract the tarball you downloaded and install the programs within the bin/ directory into a directory listed in your system PATH.

For example, on Unix-like operating systems, run the following:

sudo install -m755 bin/mongo* /usr/local/bin/
4

Generate your schema definition file.

Provide a MongoDB server hostname, replace dbname with the name of your database, and optionally replace collname with the name of a collection. If you do not specify a collection, mongodrdl will generate a schema from all collections in dbname.

mongodrdl --host example.com -d dbname [-c collname] -o schema.drdl

Note

The --host option only accepts a hostname. You cannot provide a MongoDB connection string.

You can examine the generated schema.drdl file, and remove any fields or tables that are not part of your intended schema.

5

Start mongosqld

mongosqld --schema schema.drdl --mongo-uri <your.mongohost.com>
6

Connect to the MongoDB Connector for BI

Launch your business intelligence tool, and connect to the MongoDB Connector for BI using a MySQL driver and the following settings:

Host The hostname of the server on which you installed the MongoDB Connector for BI in step 1.
Port 3307 by default.

See Connecting to the MongoDB Connector for BI for more details on connecting to the MongoDB Connector for BI.