The official MongoDB connector is still in progress: so there is no out of the box solution. I wrote few years ago a Web Data Connector for MongoDB built-in rest api, you can get it from here: MongoDB Web Data Connector for Tableau -Databoss

This is a really good question. One problem you'll find is that Mongo data can be anything from structured to semi structured to completely unstructured. Some level of structure will be needed for Tableau. But assuming you have some structure, there are a few different options. Tableau does not have a built-in connector, but Mongodb does. Unfortunately, these are only available as part of their commercial offering. Other vendors have also created ODBC connectors. All have costs associated but some are affordable. Check out Progress Software, CData, and Simba. I've experimented with all of these and they are pretty good. Some mapping is required but they work.

Of course, one final option would be to build an automated data flow to a relational database such as MySQL or PostgreSQL. But, I'm guessing you'd prefer to go directly at Mongo.

You can use a MongoDB ODBC driver. The following tutorial should help you get started: New Tableau to MongoDB ODBC connection that respects NoSQ...

You can use SIMBA MongoDB ODBC driver for tableau. This allows you to convert the un-structured data confining schema definition pattern and makes the life easier.

Hello Ken

i am able to connect Tableau Desktop version 10.2.2 using MySQL connector to Mongo db by BI Connector which Mongo db provides. But when i publish Visual to Tableau Server 10.2.2 getting an error "[MySQL][ODBC 5.3(w) Driver]Authentication plugin 'mysql_clear_password' cannot be loaded: plugin not enabled" when i get this error locally i setup Environment Variable "LIBMYSQL_ENABLE_CLEARTEXT_PLUGIN=1" which got resolved if i try same in Server it is not working any idea whats going on?

Thanks..

Vijay

Hmmm. You're using Tableau's native connector? If so, then perhaps try using MySQL ODBC drivers. Those would, of course, need to be installed on the Tableau server. The ODBC driver has an explicit option (under the Connection tab) to "Enable Cleartext Authentication". That may correct the problem.

Note: I have not actually published my data source to the server, so I'm not exactly sure if this will work, but worth a try.

Hello Ken

Thanks alot for your reply.

I figured out the issue and was able to fix with below steps:

To set any Environmental variables in Tableau Server, we need to use TABADMIN command so i used below command to set environmental variable in Tableau Server;

• Tabadmin stop
• Tabadmin set LIBMYSQL_ENABLE_CLEARTEXT_PLUGIN 1
• Tabadmin configure
• Tabadmin start

Hope this should help.

Thanks..

Vijay

Hello Vijay,

Can you please help me with sharing the steps in connecting MongoDB and Tableau sing BI Connector. I am trying to do so and not able to install the connector in my MAC.

Thanks In Advance.

Hello Saritha

Attaching word document which contains setup Mongo db connection in Windows & MAC, let me know if this doesn't help you.

Thanks..

Vijay

Hello Vijay,

Thanks a lot for the document. this will be really helpful. but what I exactly looking for is the installation of MongoDB Bi Connector.

I am running tableau 10.2 version and tried to connect to my MongoDB which is set up locally. I followed the instructions provided in the following link to get the BI connector installed, but unfortunately no able to do so, as its is throwing some Openssl issue.

Installation — MongoDB Connector for BI 2.2

Could you please share your knowledge on this? I am stuck with the installation process.

Hi Vijay - I am trying to connect to MongoDB from Mac Desktop.

I don't think the BI Connector works for my version of MongoDB (3.0.8).

I have tried using ODBC with Simba driver, but am getting an error:

[Simba][MongoDBODBC] (110) Error from MongoDB Client: not authorized on sweet_prod to execute command { listCollections: 1 } (Error Code: 13)

Does anything else work or am I out of luck?

Dave

the below worked for me:

When running mongosqld in command line, use:

mongosqld --schema schema.drdl --auth --mongo-username <USERNAME> --mongo-password <PASSWORD> --mongo-authenticationSource <collection_name> --mongo-uri <mongo host:port>

tableau username should still be: user?source=collection_name

without the --mongo-authenticationSource, the table names would appear but trying to show the data wont work