I would like to pull data out of my on premise MySQL database and use in Dynamics 365 and other PowerApps. Even though I have access to the MySQL, my company probably has firewalls, and other things that make having Flow get to it very hard. I may be able to use a gateway on a VM maybe to do this? But my tests don't seem to be working, "test connection failed" is all I get.
But maybe there's a better way?
What is the best way to get data out of (and potentially some day into) MySQL on premise to use in flows, dynamics, etc.
Thanks,
Terry
I agree, troubleshooting network firewalls is not easy task.
Here are the gateway trouble shooting help:
https://docs.microsoft.com/en-us/data-integration/gateway/service-gateway-tshoot
Please see if any of them is helpful.
Regards
Krishna
If my reply helps, please mark it as Accepted Solution. So that, other users can find it helpful instead of re-posting same question.