Connect to Linked Server Database using Azure Data Factory

Question

Hi!

I have a database that is a linked server of another. I can connect and copy data of the main database in ADF. But is it possible to also copy data from the linked server database? If yes, how would I do this?

Answer 1

Hi @Keren Osler,

Thanks for your information.

Please check out this article, it provides you methods in detail to copy data from linked server.

Hope this can help you well.

Best regards,

Lucy Chen

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our Documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

https://docs.microsoft.com/en-us/answers/support/email-notifications

Answer 2

Hi,

Yes you may copy data through linked server, provided the security user being used in linked server has permissions on the required database.

Connect to your SQL server instance, in object explorer Server objects-->Linked servers-->Right click on target linked server and select properties. In server options tab, data access option should be true.

Then you may query like (copied from copilot):

SELECT * INTO TargetDB.dbo.TargetTable
FROM [LinkedServer].SourceDB.dbo.SourceTable

Regards,

Zahid

Answer 3

Hi Keren Osler ,

I understand that you are trying to know if there is any possibility to connect to linked server database using Azure data factory or not.

In order to connect to any SQL database using ADF, we require :

• Server domain
• Database name
• User Name
• Password

In case you find these properties in linked server database, you are good to connect it via ADF linked service.

Hope it helps. Kindly accept the answer by clicking on Accept answer button. Thankyou