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

copy

sudo yum remove mongodb-bi*

Debian and Ubuntu

copy

sudo apt-get remove mongodb-bi*

2

Install OpenSSL.

OS X

Install Homebrew and run the following:

copy

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:

copy

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.

copy

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

copy

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.

←   MongoDB Connector for BI Schema Configuration  →

© MongoDB, Inc 2008-present. MongoDB, Mongo, and the leaf logo are registered trademarks of MongoDB, Inc.