1 of 1 people found this helpful
I am able to connect now and fetch data.
I had to use other ODBC connector in Tableau and used Simba ODBC connector for the DSN connection.
Accessing MongoDB data in Tableau using Simba
Purpose & Requirement: Currently Tableau does not provide MongoDB Data Connector, but it does support ODBC Connectors. Mongo Connector for Simba is one such ODBC Connector. Simba’s ODBC connector allows you to make quick analytic insights and leverage back end data source high performance calculation capabilities for your favorite BI client which in our case is Tableau
Use following steps in order to access mongoDB data in Tableau via Simba.
1. Visit URL www.simba.com/connectors/mongodb-odbc in order to download trial version of Simba for mongoDB. Provide neccessary details there and note that the email Id provided will recieve the trail license key from Simba.
2. Once downloaded run the proper installer based on your System Type ( 64-bit or 32-bit ).
3. Check email Id provided during registration, inbox of which should have recieved mail from Simba and an attached license key with .lic extension.
4. Download the license file from email inbox, and copy it to the 'C:\Program Files\Simba MongoDB ODBC Driver\lib' folder.
5. As Simba is installed using default configuration press Windows key and search for '64-bit ODBC Administrator' ( for 32 bit users search for 32-bit ODBC Administrator ). This should open following screen. Make sure 'mongod' is running ( mongoDB server is up ).
6. Press 'Configure' and provide default mongoDB connection details such as Host, Port and Database.
7. Press 'Schema Definition' button once details for appropriate host, port and database has been provided. Based on the database name provided this window allow to select one or all of the collections for the database. For all click 'General All'. For simplicity 'location' collection is choosen.
8. Click 'Edit Schema' to view data and modify the default data types choosen by Simba
9. Click on 'Upload Metadata'. A success message will pop-up.
10. Above step creates a .sdd file to the location provided in External Schema file path.
11. Now in order for Tableau to understand the configuration of Simba, copy the '.tdc' provided by Simba along with installer to the path 'C:\Users\viraj.amipara\Documents\My Tableau Repository\Datasources'.
12. Open Tableau 8.3.
13. Click 'Connect to Data'.
14. Click 'Other ODBC Sources' and select 'Simba MongoDB DSN'. Press Connect.
15. Press 'Ok' on the next step.
16. The next screen allows you to select database and collection from that database.
17. Select collection of your choice. In case join needs to be performed multiple collections can be selected.
18. Press 'Go to Worksheet'.
19. All options for data visualization of Tableau are now available for use on mongoDB data source.
Hi Sneha, try to help me out.
I am facing the same situation.
Iam having server connection error. Pls do have a look at error2.PNG or second image
I tested the connection it's fine. But got the same error. I will attach you the screenshots for your reference. Please let me know how you overcome this situation. Your help is much appreciated. If possible try to mail me how you connected to me on firstname.lastname@example.org or email@example.com