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.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 296 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 614 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 729 Beast Mode
- 53 App Studio
- 40 Variables
- 677 Automate
- 173 Apps
- 451 APIs & Domo Developer
- 45 Workflows
- 8 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 121 Manage
- 118 Governance & Security
- Domo Community Gallery
- 32 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive