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.4K Product Ideas
- 1.4K Ideas Exchange
- 1.4K Connect
- 1.1K Connectors
- 282 Workbench
- 3 Cloud Amplifier
- 4 Federated
- 2.8K Transform
- 86 SQL DataFlows
- 548 Datasets
- 2.2K Magic ETL
- 3.2K Visualize
- 2.3K Charting
- 544 Beast Mode
- App Studio
- 26 Variables
- 566 Automate
- 134 Apps
- 411 APIs & Domo Developer
- 21 Workflows
- DomoAI
- 28 Predict
- 12 Jupyter Workspaces
- 16 R & Python Tiles
- 345 Distribute
- 87 Domo Everywhere
- 257 Scheduled Reports
- 1 Software Integrations
- 85 Manage
- 84 Governance & Security
- 8 Product Release Questions
- Community Forums
- 41 Getting Started
- 27 Community Member Introductions
- 81 Community Announcements
- 4.8K Archive