MongoDB Connection to WB (local)

imelendez

Hello, Experts,

 

I am trying to connect MongoDB living on a host machine on our network with WorkBench. I went through the steps advised by the MongoDB doc site saying I need to install a MongoDB ODBC driver (v1.2). Installed that and got it configured.

 

I have installed MongoDB Compass (client tool) and have successfully connected to the localhost MongoDB using no creds and port 27117. When I went in and tried to map them to Workbench the same way I kept on getting an error like the one below. I have attached a screenshot of how I set up the connection. Am I doing something wrong that the data does not connect and keeps erroring out?

 

ERROR [08S01] [MySQL][ODBC 1.2(w) Driver]Lost connection to MySQL server at 'waiting for initial communication packet', system error: 10060

 

Thanks!

Jarvis

Hi Isaiah

 

There are many things that could be causing this issue. Is the workbench install on the same server? if not is the Mongo database set to allow remote connections? If Remote does the user have remote privileges?

 

Also, you may have more success using the Mongo connector. the documentation for this connector is here;

https://knowledge.domo.com/Connect/Connecting_to_Data_with_Connectors/Configuring_Each_Connector/Database_Connectors/MongoDB_Connector

 

Jarvis