Connect from local SQL database inot Azure Data Factory

Question

Hi.
How can I connect a local SQL database into a Azure Data Factory? In my project, It is necessary to have the updated data in Azure storage, once a day.

Does Copy Moduel in Data Factory work in this case? Or is it just an offline action (one copy without dynamic connection)?

I mean the following link:
https://learn.microsoft.com/en-us/azure/data-factory/tutorial-hybrid-copy-portal

Answer 1

You will have to install self hosted integration runtime in your local machine.

Create a new linked service, use the above IR created, provide your local SQL server and DB name and that should connect it

https://www.mssqltips.com/sqlservertip/5812/connect-to-onpremises-data-in-azure-data-factory-with-the-selfhosted-integration-runtime--part-1/

---

Please don't forget to Accept Answer and Up-vote if the response helped -- Vaibhav

Answer 2

Hi @Ørjan Lønning ,

>I mean the following link: https://learn.microsoft.com/en-us/azure/data-factory/tutorial-hybrid-copy-portal

The document applies to your situation.
You can add a new trigger for the pipeline, and choose the type of trigger, the start date, and the recurrence frequency.