mongodb BI connector

[Roshan]

Hi Erman,

I am trying to configure Mongo db BI connector to Tableau server. Grateful if you can advise as per error below

[mongod@RHIS-BITEST-01 ~]$ mongosqld --schema /home/mongod/dbtest.drdl --auth -u "dbtest" -p "dbtest" --addr 10.210.28.85:27029

[initandlisten] connection accepted from 10.105.10.51:56820, but could not initialize: unable to connect to MongoDB: no servers available: server selection failed: context deadline exceeded
2018-10-04T09:00:34.959+0400 E NETWORK    [initandlisten] connection accepted from 10.105.10.51:56880, but could not initialize: unable to connect to MongoDB: no servers available: server selection failed: context deadline exceeded
2018-10-04T09:01:31.748+0400 E NETWORK    [initandlisten] connection accepted from 10.105.10.51:57015, but could not initialize: unable to connect to MongoDB: no servers available: server selection failed: context deadline exceeded
2018-10-04T09:02:54.404+0400 E NETWORK    [initandlisten] connection accepted from 10.105.10.51:57086, but could not initialize: unable to connect to MongoDB: no servers available: server selection failed: context deadline exceeded
2018-10-04T09:03:03.682+0400 E NETWORK    [initandlisten] connection accepted from 10.105.10.51:57092, but could not initialize: unable to connect to MongoDB: no servers available: server selection failed: context deadline exceeded
2018-10-04T09:03:22.869+0400 E NETWORK    [initandlisten] connection accepted from 10.105.10.51:57097, but could not initialize: unable to connect to MongoDB: no servers available: server selection failed: context deadline exceeded
2018-10-04T09:12:23.170+0400 E NETWORK    [initandlisten] connection accepted from 10.105.10.51:57514, but could not initialize: unable to connect to MongoDB: no servers available: server selection failed: context deadline exceeded
2018-10-04T10:09:57.008+0400 E NETWORK    [initandlisten] connection accepted from 10.105.12.244:59744, but could not initialize: unable to connect to MongoDB: no servers available: server selection failed: context deadline exceeded

Kindly advise.

[ErmanArslansOracleBlog]

mongodb is not my expertise. However; I will still try to help you

Did you check the following thread? ->

https://community.tableau.com/thread/252036

In this thread , there is a comment like -> MongoDB Connector for BI doesn't support MonoDB Community Edition. Did you check this?

Also send me the tableau log..

[Roshan]

Hi Erman,

mongosqld was successfully started using:
mongosqld --sampleNamespaces cd2.sampledata --auth -u "cd2" -p "cd2" --addr 10.124.0.89:27021 --mongo-uri mongodb://10.124.0.89:27020

where mongo-uri is the connection for mongodb

Then I installed mysql on the server from
--https://docs.mongodb.com/bi-connector/current/tutorial/create-system-dsn/index.html

and the connection from Tableau to Mongo was working

[ErmanArslansOracleBlog]

Good.
Thanks for sharing Roshan.