MySQL support for federated datasets


I would love to see federated datasets supported as inputs for MySQL dataflows. Many of my customers want to copy/paste existing SQL into dataflows, and since Magic does not currently allow that, MySQL is their next best option.
My organization uses Domo Everywhere to publish federated datasets and stock content to subscriber instances. However, the federated datasets can't be used as inputs in MySQL dataflows, so we also have to send materialized copies of the same datasets to the instances. This increases confusion for our customers over which dataset to use. Since the federated datasets are included with our standard published content, using them in the same types of dataflows as materialized datasets would be ideal.
**Was this post helpful? Click Agree, Like, or Awesome below.**
**Did this solve your problem? Accept it as a solution!**
Comments
-
@akeating you can materialize a view. work with your CSM + product, there's feature switches that can probably make that happen.
it would be intriguing to know if adrenaline dataflows supports etl with federated datasets. might be a question worth asking.
Jae Wilson
Check out my 🎥 Domo Training YouTube Channel 👨💻
**Say "Thanks" by clicking the ❤️ in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"1 -
Definitely worth asking! Thanks, @jaeW_at_Onyx! 😀
**Was this post helpful? Click Agree, Like, or Awesome below.**
**Did this solve your problem? Accept it as a solution!**0 -
Probably it will not work. And with adrenaline workflow it will replicate data in DOMO. So then no use of using federated solution here. Agree with Akeating. SQL workfloe is also SQL and federated engine also works on SQL. We should have ability to use Federated datasets in SQL workflows.
1
Categories
- 10.5K All Categories
- 3 Connect
- 913 Connectors
- 250 Workbench
- 458 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 476 Datasets
- 183 Visualize
- 249 Beast Mode
- 2.1K Charting
- 11 Variables
- 16 Automate
- 354 APIs & Domo Developer
- 88 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 245 Distribute
- 62 Domo Everywhere
- 242 Scheduled Reports
- 20 Manage
- 41 Governance & Security
- 168 Product Ideas
- 1.2K Ideas Exchange
- 9 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive