更改Azure Data Factory v2中的连接字符串链接服务 [英] Change connection string Linked Service in Azure Data Factory v2

问题描述

我正在使用Azure Data Factory V2集成来自多个本地mySql数据库的数据.是否可以仅定义一个mysql链接服务，然后在运行时修改连接字符串(服务器名称，凭据，集成运行时).我的计划是使用查找活动来读取连接字符串列表，然后使用for-each活动来遍历该列表以使用复制活动从每个数据库中提取数据.

I am using Azure Data Factory V2 to integrate data from multiple on-premise mySql database. Is it possible to define just one mysql linked service and then modify the connection string (server name, credential, integration runtime) during runtime. My plan is to use lookup activity to read list of connection strings and then use for-each activity to iterate over that list to pull data from each database using copy activity.

是否有可能这样做，最好使用Azure数据工厂UI?还是我应该使用.NET SDK来做到这一点?

Is it possible to do such things, preferably using the Azure data Factory UI? or Should I use .NET SDK to do that?

谢谢

推荐答案

我们正在努力为链接服务启用参数支持，以便您可以完成今天描述的方案.敬请期待！今天，您仍然需要在链接服务定义中使用特定的连接字符串.

We are working on enabling parameter support for Linked Service so you can accomplish the scenario described today. Please stay tuned! Today you still need to use specific connection strings in Linked Service definition.

这篇关于更改Azure Data Factory v2中的连接字符串链接服务的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！