How passing a global parameter to a linked service

Question

Hi, inside a Data Factory I've created database_name as a global parameter

and a linked service with a parameter

Now, how I could pass the database_name global parameter to the linked service? Thanks

Answer 1

To use the global parameter in your linked service, you'll need to modify the linked service's JSON definition where you replace the hardcoded database name with an expression that references your global parameter. You'll use the @ symbol to denote an expression. For example, if your linked service is connecting to an Azure SQL Database, and you want to use the global parameter for the database name, your linked service JSON might look something like this:

   {
     "name": "YourLinkedServiceName",
     "properties": {
       "type": "AzureSqlDatabase",
       "typeProperties": {
         "connectionString": {
           "type": "SecureString",
           "value": "Server=tcp:yourserver.database.windows.net,1433;Database=@{pipeline().globalParameters.database_name};..."
         }
       }
     }
   }

Answer 2

Hello @pmscorca

Adding few more points to Amira's Response with ADF studio screenshots, thought it might be useful!!

First create the Global Param, as you have already done that, just showing incase anyone need!!

In your pipeline, when you use the dataset, you can pass the global parameter value to the dataset parameter and then the dataset will pass the parameter to the Linked Service.

Global Parameter-->Pipeline-->dataset-->Linked Service

Please do let us know if you have further questions in this matter.