Forum Discussion
Issues connecting to MySQL database server using virtual network data gateway in Fabric
I managed to connect to connect to the external MySQL server using a Self-hosted Integration Runtime with a static IP address in Azure Data Factory. No luck in doing it in Fabric. I have not been able to raise a support ticket as I for some reason do not had access to do so.
Another option would be to spin up a regular gateway in the same subnet and use that instead. More maintenance for you though.
No luck with an on-premises data gateway either unfortunately, if that is what you mean by a 'regular gateway'. What is strange is that I create a VM with a static reserved IP which I whitelist at the database provider. From the VM, I am able to connect to the MySQL database using MySQL Workbench. But when attempting to create a connection using my on-prem data gateway in Fabric, I receive the error: "Unable to create connection for the following reason: Unable to connect to the data source. Either the data source is inaccessible, a connection timeout occurred, or the data source credentials are invalid. Please verify the data source configuration and contact a data source administrator to troubleshoot this issue"
I have confirmed that the data source credentials are indeed valid. It is very hard at this point to identify the exact issue, but I believe it is related to Fabric using a dynamic outbound IP address. Anyone have anymore input on my connection issues?