-
1. Re: How to connect Tableau on MongoDB?
Tamas Foldi Jan 6, 2017 10:24 AM (in response to Joao Gutheil)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
-
2. Re: How to connect Tableau on MongoDB?
Ken Flerlage Jan 22, 2017 1:21 AM (in response to Joao Gutheil)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.
-
3. Re: How to connect Tableau on MongoDB?
Nishanth Kadiyala Feb 8, 2017 6:41 AM (in response to Joao Gutheil)You can use a MongoDB ODBC driver. The following tutorial should help you get started: New Tableau to MongoDB ODBC connection that respects NoSQ...
-
4. Re: How to connect Tableau on MongoDB?
Prashant Keshri Feb 8, 2017 8:31 AM (in response to Joao Gutheil)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.
-
5. Re: How to connect Tableau on MongoDB?
vijay medipelli Jun 8, 2017 1:55 PM (in response to Ken Flerlage)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
-
6. Re: How to connect Tableau on MongoDB?
Ken Flerlage Jun 29, 2017 1:31 PM (in response to vijay medipelli)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.
-
7. Re: How to connect Tableau on MongoDB?
vijay medipelli Jun 29, 2017 2:01 PM (in response to Ken Flerlage)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
-
8. Re: How to connect Tableau on MongoDB?
saritha xavier Jul 5, 2017 12:34 AM (in response to vijay medipelli)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.
-
9. Re: How to connect Tableau on MongoDB?
vijay medipelli Jul 5, 2017 7:03 AM (in response to saritha xavier)1 of 1 people found this helpfulHello Saritha
Attaching word document which contains setup Mongo db connection in Windows & MAC, let me know if this doesn't help you.
Thanks..
Vijay
-
10. Re: How to connect Tableau on MongoDB?
saritha xavier Jul 6, 2017 3:04 AM (in response to vijay medipelli)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.
-
11. Re: How to connect Tableau on MongoDB?
Dave Worth Dec 17, 2017 1:27 AM (in response to vijay medipelli)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
-
12. Re: How to connect Tableau on MongoDB?
thomas.hoang.0 Oct 21, 2018 9:19 PM (in response to Dave Worth)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