How to connect mongodb with tableau?

Question

Connecting Mongo DB to Tableau?

Answer 1

First you need to open the Tableau Desktop then click on more under ‘connect to server’ then choose Mongo DB BI Connector, all these option you can see on left side of your tableau interface. So now the connection window will appear, in that window you need to enter the necessary credentials. If you are trying to connect to a Mongo DB instance where authentication is disabled then you need to enter the username as well as password.

You can use authentication parameter to activate the pass through authentication in mongosqld. For example you can take the below example:

$ ./mongosqld --schemaDirectory /home/vagrant/schema - --addr=10.11.12.13:3307 --auth --sslPEMKeyFile=/mongosqld-server.pem

Once you are done with mongoslqd pass through authentication then go to connecting window which opened earlier for credential login. Users are associated to home database in mongo DB under users management. This is the database where users were declared first when the users were created. The mongo DB BI connector requires you to specify the database in which the user is created by passing the unique value/key as a part of username. Once you are done with all these credentials in the connecting window then click on Sign in then tableau will take care of all other things.

You can check the ‘Require SSL’ checkbox if you want Tableau authenticate mongosqld certificate.. In this case it uses self-signed certificate and is called as ca.crt, this option you can select from ‘Browse’ button. To activate the browse button, click on “No custom configuration file specified, as shown below. After that Mongo DB databases will be there in tableau for use in visualizations.

To learn more about the database connection in tableau you can check learn tableau or make the right move by enrolling now in Tableau Online Course to learn it.