更新时间: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.