Connect Tableau to remote MongoDB
Table of Contents
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
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.
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.