Skip to main content

Configuring a Linked Service

Connections can be enabled to be used as Linked Services in Azure Data Factory (ADF).

Enable a Connection as a Linked Service

In the Connection Tab of the Connection Editor, provide the Integration Stage, Connection Type, and System Type for the connection.

If the resulting configuration provided is compatible with a Linked Service, then a Cloud setting will appear in the action bar.

After toggling the Cloud setting, a tab for Linked Services will appear at the bottom of the form and any available linked services will appear in the Linked Service Types dropdown. Select a Linked Service Type to configure it.

Configuring the Linked Service

Linked Services are used in Azure Data Factory (ADF) to define a data source. The Linked Service form allows for input of all required data points needed to allow BimlFlex to generate a corresponding Linked Service.

danger

To configure a Linked Service, select a Connection and enable the Cloud selector at the top.

ADF Linked Service Tab

There are two main components, the base Linked Service details and then the Connection details. These details will remain unchanged regardless of how the connection details are configured.

Description

FieldDescription
Linked Service TypeThe type of Linked Service being used
Connect Via Integration Runtime*(If required) The name of the Integration Runtime to use to connect
tip

*: This setting is generally only used for an On-Premises data source.

Example

FieldExample
Linked Service TypeAzure Synapse Analytics (SQL DW)
Connect Via Integration Runtime*AutoResolveIntegrationRuntime
tip

*: Use AutoResolveIntegrationRuntime if no specific Integration Runtime is needed.


The linked services that are currently supported are listed below. Select a linked service type for information on filling out the Linked Service form.

Linked Service Connection Details

The Connection String can be entered via plain text or stored in an AKV Secret.

Azure Key Vault

Showing configuration for storing a connection string in an Azure Key Vault Secret.

Connection String

Showing configuration for plain text connection string.


Description
FieldDescription
AKV Linked ServiceName of the Linked Service pointing to the AKV
Secret NameName of the secret
Secret Version(Optional) Version of the secret to use. Leave blank for latest.
Example
FieldExample
AKV Linked Servicebfx-kv
Secret NameBFX-DW-ConnectionString
Secret Version{Blank}
Description
FieldDescription
Fully Qualified Domain NameFully qualified server name
Database NameName of the database
Example
FieldExample
Fully Qualified Domain Namebfx-sql-server.database.windows.net
Database NameBFX_DW

Authentication Details

Depending on the Authentication Method, options to specify an AKV Secret for either a User's Password or Service can also be provided.

SQL Authentication

FieldExample
Authentication MethodSQL Authentication

SQL Authentication

FieldExample
Authentication MethodSQL Authentication

Managed Identity

FieldExample
Authentication MethodManaged Identity

Service Principal

FieldExample
Authentication MethodService Principal

Authentication Details: N/A

danger

Authentication handled with the value in the connection string Secret.

Authentication Details: N/A

danger

Authentication handled with the Managed Identity.

Azure Key Vault

Showing configuration for storing a password in an Azure Key Vault Secret.

Password

Showing configuration for plain text password.

warning

This method is not recommended. The Password is being stored in plain text.

Azure Key Vault

Showing configuration for storing a Service Principal Key in an Azure Key Vault Secret.

Service Principal Key

Showing configuration for plain text Service Principal Key.

warning

This method is not recommended. The Service Principal Key is being stored in plain text.


Description: N/A

No description.

Description: N/A

No description.

Description
FieldDescription
AKV Linked ServiceName of the Linked Service pointing to the AKV
Secret NameName of the secret
Secret Version(Optional) Version of the secret to use. Leave blank for latest.
Example
FieldExample
AKV Linked Servicebfx-kv
Secret NameBFX-DW-Password
Secret Version{Blank}
Description
FieldDescription
PasswordThe value for the password
Additional Connection String PropertiesAny additional properties entered here will be included in the Connection String
Example
FieldExample
PasswordP@$$Word!
Additional Connection String Propertieskey=value;secondKey=secondValue
Description
FieldDescription
AKV Linked ServiceName of the Linked Service pointing to the AKV
Secret NameName of the secret
Secret Version(Optional) Version of the secret to use. Leave blank for latest.
Example
FieldExample
AKV Linked Servicebfx-kv
Secret NameBFX-DW-ServicePrincipalKey
Secret Version{Blank}
Description
FieldDescription
Service Principal KeyThe value for the Service Principal Key.
Additional Connection String PropertiesAny additional properties entered here will be included in the Connection String
Example
FieldExample
Service Principal Key{Service Principal Key}
Additional Connection String Propertieskey=value;secondKey=secondValue