MongoDB Connection to WB (local)
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!
Comments
-
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;
Jarvis
0
Categories
- 10.5K All Categories
- 8 Connect
- 918 Connectors
- 250 Workbench
- 469 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 477 Datasets
- 193 Visualize
- 252 Beast Mode
- 2.1K Charting
- 11 Variables
- 17 Automate
- 354 APIs & Domo Developer
- 89 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 247 Distribute
- 63 Domo Everywhere
- 243 Scheduled Reports
- 21 Manage
- 42 Governance & Security
- 174 Product Ideas
- 1.2K Ideas Exchange
- 12 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive