MySQL support for federated datasets

akeating
akeating Contributor
edited January 8 in Federated Ideas

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!**

Tagged:
2
2 votes

Active · Last Updated

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"
  • akeating
    akeating Contributor

    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!**

  • 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.