Docs Home → MongoDB Connector for BI Show NoteThe MongoDB Connector for BI and associated utilities are compatible with all currently supported MongoDB server versions. To set up MongoDB Connector for BI with a business intelligence tool such as Tableau, follow the steps on this page.
To verify OpenSSL is installed on your system, run the following command:
If OpenSSL is not installed, use your package manager to install it. If your MongoDB instance uses
authentication, your BI Connector instance must also use authentication. The user that connects to MongoDB via the For more details about MongoDB user permissions in BI Connector, see User Permissions for Cached Sampling.
New in version 2.9. To help you get started, a sample You are now ready to launch the BI Connector. The following guide contains detailed information on BI Connector configuration, schema generation, and launch options:
Docs Home → MongoDB Connector for BI NoteThe MongoDB Connector for BI and associated utilities are compatible with all currently supported MongoDB server versions. The MongoDB Connector for BI can be installed on premises or hosted in MongoDB Atlas. Follow the guide for your platform below to install the BI Connector, or see Enable BI Connector in Atlas. To update your BI Connector, use the installation guides above to install the latest version of BI Connector for your platform, replacing your existing installation. As part of an innovation project, I had to develop an analytics dashboard for a data storage in MongoDb. I found an interesting component to achieve my goal and this is Mongo BI Connector. According to documentation there is no release for Ubuntu 18.04 😢, so we are gonna try to install another version compiled for Ubuntu 16.04. First of all we need to create a folder in which we are going to store Mongo BI Connector binaries, let’s start: root@mongo-master:~/bin# mkdir ~/bin&&cd ~/bin Then we are going to download Mongo BI Connector binaries root@mongo-master:~/bin# wget https://info-mongodb-com.s3.amazonaws.com/mongodb-bi/v2/mongodb-bi-linux-x86_64-ubuntu1604-v2.12.0.tgz And then we are going to unpack this file: root@mongo-master:~/bin# tar -xvzf mongodb-bi-linux-x86_64-ubuntu1604-v2.12.0.tgz We need to install Mongo BI Connector in a folder that must be in root@mongo-master:~/bin# echo $PATH As we can see, root@mongo-master:~/bin# cd mongodb-bi-linux-x86_64-ubuntu1604-v2.12.0/ Let’s test if connector was successfully installed by running
root@mongo-master:~/bin/mongodb-bi-linux-x86_64-ubuntu1604-v2.12.0# mongosqld TIP AND TRICKS 🚀🤔Connection refusedIf you got a message like this: 2019-10-16T15:57:12.728-0600 E NETWORK [initandlisten] unable to load MongoDB information: failed to create admin session for loading server cluster information: unable to execute command: server selection error: server selection timeout Don’t worry, it is because you have a binding IP that is not systemLog: Here we need to specify a path for system logs and our binding IP but, how do we know which IP is mongo using? If you follow default
Mongo Db instructions there must be a file named root@mongo-master:~/bin/mongodb-bi-linux-x86_64-ubuntu1604-v2.12.0# cat /etc/mongod.conf#... CONFIGURATION INFO....# network interfaces And then we are going to create our Mongo BI Connector configuration file (be careful where you are going to create this file): root@mongo-master:~/bin/mongodb-bi-linux-x86_64-ubuntu1604-v2.12.0# mkdir ~/conf&&cd ~/conf And then let’s use #-------- ~/conf/mongosqld.conf ---------systemLog: 🛑 WARNING: Now let’s test our installation by passing mongosqld --config=~/conf/mongosqld.conf To verify if everything is running successfully, let’s check our logs: root@mongo-arbiter:~/conf# cat /logs/mongosqld.log Installing as a service 🐱👤If you want to install Mongo BI Connector as a service just run the following commands (💡 if you do not have a configuration file, just ignore root@mongo-arbiter:~/conf# mongosqld install --config ~/conf/mongosqld.conf And finally to start the service and running at startup let’s execute: root@mongo-arbiter:~/conf# systemctl start mongosql.serviceroot@mongo-arbiter:~/conf# systemctl enable mongosql.service Connecting to a replica set You could use a configuration file like this: systemLog:
How do you install a bi connector?Install the BI Connector. Run the downloaded . msi file.. Follow the wizard instructions to install the files. The binaries install into a bin directory inside the installation directory. If a prior version exists, you might need to configure your system services to launch the new installation.. How do I run a MongoDB BI connector?Quick Start Guide for Windows. Start a local MongoDB mongod process.. Start a local BI Connector mongosqld process.. Install the ODBC driver and create a data source name (DSN). Connect with a BI tool of your choice.. Is the connector for BI available for MongoDB community?Yes the BI Connector is part of the Enterprise version, however as a community user you can use the BI Connector as an evaluation. Details are in the LICENSE file when you install the BI Connector. Alternatively you can use the BI Connector through MongoDB Atlas.
How does tableau connect to MongoDB?Start Tableau and under Connect, select MongoDB BI Connector. For a complete list of data connections, select More under To a Server.. Enter the name of the server.. If MongoDB authentication is enabled, enter your user name with associated database name, and password.. |