none
How to connect existing gateway in Data Factory V2 linked service

    Question

  • 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"

            }

                    }

    }

    Friday, July 27, 2018 11:38 AM

All replies