且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

创建ADF链接服务以连接到SQL Server链接服务器

更新时间:2022-10-17 23:23:40

嗨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.