What is the difference between creating a MySQL dataset from Workbench vs the MySQL data connectors?
I would prefer to use the MySQL data connectors but I'd like to understand if there are limitations of going this route. For example I'm trying to connect to a MySQL database internal to our network and I can't seem to connect to the database using MySQL connectors. My guess is that this is because the connection request is coming from an external Domo url. But confirmation of this and any other known limitations would be appreciated.
Comments
-
MySQL external connectors:
If your MySQL database is located behind your firewall you'll need to whitelist inbound traffic to that server over certain ports. I'd suggest you Buzz Domo Support within your instance to get the list of IP Addresses to white list. Once you've configured the firewall settings you should be able to use the external MySQL connectors to your data.
There are several advantages to the workbench alternative including:
- No need to adjust firewall settings
- Secure network communication using a proxy server (if desired)
- Manage scheduled jobs
- Add columns based on calculations
- Transform columns using regular expressions
- and much more.
You can visit the Help section within your Domo instance to learn more about the workbench in order to make the decision between Domo connectors and using the workbench.
Hope this helps.
*edits for spelling
2 -
@kith_howes, did Rich's reply help you out?
0
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 293 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 96 SQL DataFlows
- 607 Datasets
- 2.1K Magic ETL
- 3.8K Visualize
- 2.4K Charting
- 705 Beast Mode
- 49 App Studio
- 39 Variables
- 667 Automate
- 170 Apps
- 446 APIs & Domo Developer
- 44 Workflows
- 7 DomoAI
- 33 Predict
- 13 Jupyter Workspaces
- 20 R & Python Tiles
- 391 Distribute
- 111 Domo Everywhere
- 274 Scheduled Reports
- 6 Software Integrations
- 115 Manage
- 112 Governance & Security
- Domo Community Gallery
- 31 Product Releases
- 9 Domo University
- Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 103 Community Announcements
- 4.8K Archive