Parameters for switch between linked services

ADITYA SINGH 0 Reputation points
2024-05-27T17:49:37.5766667+00:00

I have a pipeline in Azure Synapse which has multiple dataflows and I have 2 linked service how can I use the pipeline parameters to switch between linked services without changing the linked services in each data manually.

Azure SQL Database
Azure Data Lake Storage
Azure Data Lake Storage
An Azure service that provides an enterprise-wide hyper-scale repository for big data analytic workloads and is integrated with Azure Blob Storage.
1,409 questions
Azure Storage Accounts
Azure Storage Accounts
Globally unique resources that provide access to data management services and serve as the parent namespace for the services.
2,871 questions
Azure Blob Storage
Azure Blob Storage
An Azure service that stores unstructured data in the cloud as blobs.
2,575 questions
Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,621 questions

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Azar 21,230 Reputation points MVP
    2024-05-27T19:12:48.7566667+00:00

    Hi there ADITYA SINGH

    Thanks for using QandA platform

    you can use dynamic mapping within your dataflows

    Create Pipeline Parameters representing the linked service names needed to switch between

    In each dataflow where you need to switch between linked services, open the dataflow and locate the source or sink that references a linked service.

    Instead of directly specifying the linked service name, use expressions to dynamically reference the pipeline parameters. For example, you can use an expression like @pipeline().parameters.LinkedServiceName to reference the linked service based on the parameter value.

    If this helps kindly accept the answer thanks much.

    0 comments
  2. AnnuKumari-MSFT 31,816 Reputation points Microsoft Employee
    2024-05-28T06:20:33.22+00:00

    Hi ADITYA SINGH ,

    Welcome to Microsoft Q&A platform and thanks for posting your query here.

    As per my understanding you are trying to make use of single linked service in multiple places to reuse by parameterizing it.

    I hope that the data sources for multiple dataflows are same for which you want to make the linked service dynamic. For example: You can't reuse linked service for SQL server for ADLS. However, if you want to connect to different databases or even different Servers in SQL, it's possible by using parameters within the linked service.
    No alt text provided for this image For more details, kindly check this blog post: https://www.linkedin.com/pulse/parameterizing-linked-service-azure-data-factory-nithyanandam

    In case if you have any additional query, then please share in details what are the data sources for all of the dataflows and how you are planning to make it dynamic. Hope it helps. Kindly accept the answer by clicking on Accept answer button. Thankyou

    0 comments