Connect Tableau to remote MongoDB

Connect Tableau to Remote MongoDB. 

In this blog, you will find steps regarding Tableau MongoDB connection. Follow the below steps to create a Tableau Mongo connection and start the exploration of data.

Step-1: Download and install MongoDB on the remote machine.

Download MongoDB from the mongo download center.

wget https://fastdl.mongodb.org/linux/mongodb-linux-x86_64-amazon-4.2.7.tgz

unzip the file.

tar -xzf mongodb-linux-x86_64-amazon-4.2.7.tgz

Follow this link, in the case you want to use ‘yum repo’
.

Step-2: Run MongoDB.

cd mongodb-linux-x86_64-amazon-4.2.7

To run MongoDB, first, start the mongo server.

./mongod --dbpath /data/dir

–dbpath location is required as data is stored in the path provided. If the directory does not exist, then create the directory before starting server.

Step-3: Install Mongo Bi Connector.

Download mongo bi connector where the mongo server runs. In this case, the mongo server runs in the amazon ec2 machine.

Download connector based on your platform from https://www.mongodb.com/download-center/bi-connector

Screenshot 2020 05 25 at 7.11.11 PM
tar -xzf mongodb-bi-linux-x86_64-amzn64-v2.13.4.tgz
cd mongodb-bi-linux-x86_64-amzn64-v2.13.4/bin
./mongosqld --addr 'remote-machine-ip':27017

Step-4: Launch Tableau and connect to MongoDB

This step helps you to connect Tableau to Remote MongoDB. Open Tableau in the local machine and select ‘MongoDB BI Connector’.

Provide your remote server IP and connect.

mongo bi

Conclusion:

In this blog, you learned how to connect Tableau to Remote MongoDB and Please share your thoughts and challenges in the comment section, if you still face any.

Leave a Reply