Dynamic/Widespread SQL Ingestion With On-Premises Gateway

Hi Anonymous ,

Here are some of my thoughts and suggestions that I hope will help you.

Regarding dynamic content support: Currently, the Copy Data Activity (CDA) really does not support dynamic content for SQL Server connection types. This means that you need to create, deploy and maintain multiple nearly identical pipelines for each different SQL Server connection, which does create a significant maintenance effort. You can also check out this topic for more information: Solved: Re: Dynamic Connection To Sources - Microsoft Fabric Community

Regarding whether there are plans to add support: Based on current information, there are no definite plans to add dynamic content support for SQL Server connection types. You can also raise your expectations in the Idea, here is the website: Home (microsoft.com)

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.