MySQL Forums
Forum List  »  General

Remote Query
Posted by: Donna Kelly
Date: April 13, 2023 09:10AM

I want to use Azure Data Factory to run a remote query against a big MySQL database sitting inside a VM in another tenant.  Connectivity is good; I can see the other database, and my 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?

Please note this question is not about Azure - it's about correctly forming a query that will execute remotely. If I was in a SQL Server environment, I'd
use something like
SELECT a.* FROM OPENROWSET(
'SQLNCLI','Server=Seattle1;Trusted_Connection=yes;',
'SELECT TOP 10 GroupName, Name FROM AdventureWorks2012.HumanResources.Department') AS a;

However, I don't know how to do that with MySQL.

All help gratefully received!

Options: ReplyQuote


Subject
Written By
Posted
Remote Query
April 13, 2023 09:10AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.