Creating linked services

Linked services define the connection information needed for a Synapse pipeline to connect to an external data source. These linked services are not specific to any pipeline, but you can use the same linked service for multiple pipelines at the same time if they share the same data source.

In this example, we are going to create a linked service for Azure SQL Database (which is our data source), with Synapse as our target.

Before we proceed with the steps to create the linked service for the source and target, make sure you have met all the technical requirements outlined at the start of this chapter. Then, proceed as follows:

1. Launch Synapse Studio by clicking on the Synapse Studio link on the Synapse workspace.
2. Click on Linked services under the Manage tab, and click on + New to create a new linked service, as illustrated in the following screenshot:
   

   Figure 4.8 – Creating linked services in Azure Synapse

3. Select Azure Data Lake Storage...