Relative Content

Tag Archive for azureazure-data-factoryoracle-adfazure-data-lake

Azure Copy Activity issue

My project has Maria DB as on-prem source system, it is connected with ADF via Self hosted integration runtime. I want to copy only the required fields from 100 tables of MariaDB to Data Lake but I want to make sure that the query is executed on Maria DB and not on Azure side due to strict data policies of my organization. Is there any way to achieve this? I read that if we execute the SQL query in copy activity, it is staged in Azure via SHIR which means it goes through organization network and firewall which I dont want.