Can I create a metadata driven copy data tool pipeline in ADF with same source and different connections.

Derik Roby 16

My requirement is to copy data from 3 different SQL server connections. Is it possible tp do it in a go or should I create 3 separate metadata driven copy pipelines ?

User's image

1 answer

Nandan Hegde 32,336 Reputation points MVP

2023-11-16T12:09:23.4666667+00:00

Hey,

You can parameterize the linked services for the same type.

So you can use the same meta data driven pipeline by passing the server details to the linked service at runtime.

https://www.techbrothersit.com/2022/02/parameterize-linked-services-in-azure.html#:~:text=In%20the%20source%20tab%2C%20click,then%20provide%20the%20table%20name.
Please sign in to rate this answer.
Derik Roby 16 Reputation points

2023-11-16T13:52:00.75+00:00

Thanks for the reply. But, even if I used the parameterized linked list. I still need to pass the parameter value of the connection string for my sql server. Then only I will be able to choose the tables and proceed further to create the metadata-driven copy pipeline. I am looking for an option if I could add tables from different sql server hosts (more than 1), in a single metadata-driven copy pipeline.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

Can I create a metadata driven copy data tool pipeline in ADF with same source and different connections.

1 answer

Your answer