Forum Discussion

DonnaKelly's avatar
DonnaKelly
Copper Contributor
Apr 13, 2023

MySQL remote query

I want to use Azure Data Factory to run a remote query against a big MySQL database sitting inside a VM in another tenant.  Access is via a Self-Hosted Integration Runtime, and connectivity to the other tenancy's subnet is via VNet Peering.  Connectivity is good; I can see the other database, and ADF Connection succeeds.

But how do I get my SELECT statement to execute on the other machine?  I don't want to bring back gigabytes of tables and select from them locally.  I want my SELECT WHERE clause to execute on the MySQL database remotely and just get the very small dataset piped back to the Data Factory.

Any ideas?

 

No RepliesBe the first to reply

Resources