创建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屋！