如何连接Data Factory V2链接服务中的现有网关 [英] How to connect existing gateway in Data Factory V2 linked service

问题描述

在我们的组织中，每个品牌的Data Factory V1中都有多个管道，并且我们有一个名为"SQLServerGateway"的通用网关(自我-托管)用于所有这些管道的本地SQL Server 按计划运行良好.  

现在，我们正在尝试在Data Factory V2中创建单个测试管道，该管道在Data Factory V1中也做同样的工作.因此，我们正在Data Factory V2中创建链接服务，并且尝试链接 V2中链接服务中的现有网关"SQLServerGateway".但是，在为本地SQL Server创建新的链接服务时，我们无法在下拉菜单中获取该网关(SQLServerGateway).

由于现有的网关名称未在下拉列表中填充，我们在高级注释中编码了以下部分.  但是在测试连接时我们仍然会收到一些错误.

因此，我们想知道如何连接Data Factory V2链接服务中的现有网关.

代码:

{

   名称":"SQLConn_RgTest"，

   属性":{

       类型":"SqlServer"，

       "typeProperties":{

           "connectionString":{ ]

               类型":"SecureString"，           &b               nbsp; bsp   

               值":数据源= XXXX；初始目录= XXXX；集成安全性= False；用户ID = XXXX；密码= XXXX；"

          }

       }

       "connectVia":{

           "referenceName":"SQLServerGateway"，

           " type":"SelfHostedIntegrationRuntime"

       }

               }

}

解决方案

您不能将一个自托管的IR与2个数据工厂链接.

您需要在数据工厂v2上创建集成运行时，并在另一台计算机上为adf v2安装IR.然后，您可以在链接的服务选择列表中找到自托管的IR.

您可以在 We have multiple pipelines in Data Factory V1 for each brand for our organization and We have common gateway named "SQLServerGateway" (Self-Hosted) for on-premises SQL Server for all these pipelines which are running well on scheduled basis.  

Now, we are trying to create single test pipeline in Data Factory V2 which is doing same job in Data Factory V1. Hence we are creating Linked Services in Data Factory V2 and we are trying to link existing gateway "SQLServerGateway" in linked services in V2. But we are not able to fetch that gateway (SQLServerGateway) in dropdown while creating new linked service for on-premises SQL Server.  

Due to existing  gateway  name not populating in dropdown, we coded the below part in advanced note.  But we still receive some error while testing the connection.

Hence we would like to know how to connect existing gateway in Data Factory V2 linked service.

Code:

{

    "name": "SQLConn_RgTest", 

    "properties": {

        "type": "SqlServer",

        "typeProperties": {

            "connectionString": {                                        

                "type": "SecureString",                                               

                "value": "Data Source=XXXX;Initial Catalog=XXXX;Integrated Security=False;user id=XXXX;password=XXXX;"

            }

        },

        "connectVia": {

            "referenceName": "SQLServerGateway",

            "type": "SelfHostedIntegrationRuntime"

        }

                }

}

解决方案

Hi,

You cannot link one self-hosted IR with 2 data factories.

You need to create an integration runtime on data factory v2 and install IR for adf v2 on another machine. Then you can find the self-hosted IR in linked service select list.

You may find more information in Considerations for using self-hosted IR

这篇关于如何连接Data Factory V2链接服务中的现有网关的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！