2

If I have a database that is hosted on cloud, hence publicly accessible, is it possibible to connect to it via Azure Integration-Runtime, or do I have to set up a self-hosted IR?

In the official documentation it's not clear, one article indicating Azure IR not supported for MySQL, while digging through the detailed connector's article, it says the opposite.

Jon Popa Freeletics
  • 21
  • 4

2 Answers2

0

If your server is publicly accessible, then you don’t need install a selfhosted IR. You could use ADF v2 UI to have a quick try. It provides the test connection function.

Seems the first article is out of date. Previously, it needs a MySQL driver to connect MySQL. But currently, ADF has a default driver now.

Fang Liu
  • 2,325
  • 2
  • 13
  • 18
  • +1 Could you confirm the integration of the driver into the connector by using it or any other useful reference? – Jon Popa Freeletics Aug 07 '18 at 13:01
  • In the second doc you mentioned, it stated that “The Integration Runtime provides a built-in MySQL driver starting from version 3.7, therefore you don't need to manually install any driver.” As the azure IR will always be the lastest version, so it should include the built in driver. – Fang Liu Aug 07 '18 at 13:37
  • It's supposed to be that way, I'm looking for someone that already went through all this stuff. I'll try it out, and we'll see. Thanks anyways! – Jon Popa Freeletics Aug 07 '18 at 14:42
0

Yes ,you need to install Self-hosted IR in order to access your Cloud hosted MySQL database. As of today what I've tried, "Azure Integration-Runtime" does have that capability to connect cloud hosted MYSQL database.

Harsimranjeet Singh
  • 514
  • 2
  • 6
  • 19