创建ADF链接服务以连接到SQL Server链接服务器 [英] Create ADF Linked Service for connection to SQL Server Linked Server
问题描述
我在SQL Server 2016中创建了一个链接服务器以连接到DB2数据库。
我现在需要从DB2中提取数据,所以在Data Factory V2中我的下一步是配置一个链接服务来连接到将连接到DB2的链接服务器。
是吗有可能做到这一点?如果是这样,我需要在ADF链接服务设置中使用哪种符号?
非常感谢
David
嗨David,
如何拥有一个独立的DB2连接器?要了解更多信息,请参阅
此文档。
在您的情况下,您可以为链接服务器设置双跃点设置。要了解更多信息,请参阅
此博客。配置此设置后,您应该能够在ADF中建立连接(链接服务)以连接到SQL Server数据库并从链接服务器查询表。
希望这有助于
Hi,
I have created a Linked Server in SQL Server 2016 to connect to a DB2 database.
I now need to pull data from DB2 so in Data Factory V2 my next step is to configure a Linked Service to connect to the Linked Server which will connect to DB2.
Is it possible to do this ? And if so what is the notation I need to use in ADF Linked Service setup ?
Thanks very much
David
Hi David,
How about having a standalone DB2 connector ? To read more about it, please refer this doc.
In your case, you can set up a double-hop setting for the Linked Server. To read more about it, please refer this blog. Once you configure this setting, you should be able to make a connection (Linked Service) in ADF to connect to the SQL Server DB and query the tables from the Linked Server.
Hope this helps.
这篇关于创建ADF链接服务以连接到SQL Server链接服务器的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!