- Install BI Connector On Premises >
- Install BI Connector on Mac OS
Install BI Connector on Mac OS¶
On this page
Note
The MongoDB Connector for BI and associated utilities are compatible only with MongoDB server version 3.2 or greater.
To set up MongoDB Connector for BI with a business intelligence tool such as Tableau, follow the steps on this page.
Prerequisites¶
- OpenSSL installed on your host.
To install OpenSSL via Homebrew, run the following command:
Install the BI Connector¶
Download the MongoDB Connector for BI.¶
Download the BI Connector from the MongoDB Download Center.
Install the MongoDB Connector for BI.¶
Extract the downloaded
.tar
archive.Install the programs within the
bin/
directory into a directory listed in your systemPATH
. If a prior version exists, overwrite the binaries.
Generate your schema definition file. (Optional)¶
Changed in version 2.3.
Though you do not need to create a .drdl schema file to use BI Connector, you can if it meets your use case. To review the use cases, see Map Relational Schemas to MongoDB.
If you wish to create a schema file, use the
mongodrdl
command.
Authentication not enabled:¶
Authentication enabled:¶
Note
The --host
option only accepts a hostname. You cannot
provide a MongoDB connection string.
You can examine the generated schema.drdl
file in a text editor
and remove any fields or tables that are not part of your intended
schema.
For more information, see mongodrdl
.
Start mongosqld
.¶
You can either launch mongosqld
manually from the command line or
configure it as a system service to run on startup. Depending on your
use case and deployment, start mongosqld
using only one of the
following methods:
- Start Manually Using Command Line Options
- Start Manually Using a Configuration File
- Start as a System Service
Start mongosqld
manually:¶
Using Command Line Options¶
For the list of command line options, see Command Line Options.
Using a Configuration File¶
Using your preferred text editor, create a mongosqld.conf
file.
To review the configuration file options, see Configuration
File.
Start mongosqld
as a system service:¶
The BI Connector requires a configuration file with the
systemLog.path
setting specified when running as a
system service. Using your preferred text editor, create a
mongosqld.conf
file. To review the configuration file options,
see Configuration File. For example:
To install and run mongosqld
as a system service, run the
following commands:
Install the Authentication Plugin¶
If using authentication without SSL, install the C Authentication Plugin as described in Install the C Authentication Plugin.
Connect to the BI Connector¶
Launch your business intelligence tool, and connect to the BI Connector using a MySQL driver and the following settings:
Host | The hostname of the server on which you installed the BI Connector. |
---|---|
Port | 3307 by default. |
For more details on connecting to the BI Connector, see Connect BI Tools.