Azure Data Factory Linked Service Azure SQL Database
This page shows how to write Terraform and Azure Resource Manager for Data Factory Linked Service Azure SQL Database and write them securely.
azurerm_data_factory_linked_service_azure_sql_database (Terraform)
The Linked Service Azure SQL Database in Data Factory can be configured in Terraform with the resource name azurerm_data_factory_linked_service_azure_sql_database
. The following sections describe 8 examples of how to use the resource and its parameters.
Example Usage from GitHub
resource "azurerm_data_factory_linked_service_azure_sql_database" "linked_service_azure_sql_database" {
name = var.name
resource_group_name = var.resource_group_name
data_factory_name = var.data_factory_name
description = try(var.description, null)
integration_runtime_name = try(var.integration_runtime_name, null)
resource "azurerm_data_factory_linked_service_azure_sql_database" "adf_ls_sql" {
name = var.data_factory_linked_service_azure_sql_database_name
resource_group_name = var.resource_group_name
data_factory_name = var.data_factory_name
connection_string = var.connection_string
}
}
module "naming" {
source = "../../../naming"
suffix = var.suffix
resource "azurerm_data_factory_linked_service_azure_sql_database" "linked_service_azure_sql_database" {
name = azurecaf_name.dataset.name
resource_group_name = var.resource_group_name
data_factory_name = var.data_factory_name
description = try(var.description, null)
integration_runtime_name = try(var.integration_runtime_name, null)
resource "azurerm_data_factory_linked_service_azure_sql_database" "linked_service_azure_sql_database" {
name = var.name
resource_group_name = var.resource_group_name
data_factory_name = var.data_factory_name
description = try(var.description, null)
integration_runtime_name = try(var.integration_runtime_name, null)
resource "azurerm_data_factory_linked_service_azure_sql_database" "linked_service_azure_sql_database" {
name = var.name
resource_group_name = var.resource_group_name
data_factory_name = var.data_factory_name
description = try(var.description, null)
integration_runtime_name = try(var.integration_runtime_name, null)
resource "azurerm_data_factory_linked_service_azure_sql_database" "df-to-sql" {
name = "example"
resource_group_name = azurerm_resource_group.rg.name
data_factory_name = azurerm_data_factory.df.name
connection_string = "data source=serverhostname;initial catalog=master;user id=testUser;Password=test;integrated security=False;encrypt=True;connection timeout=30"
}
resource "azurerm_data_factory_linked_service_azure_sql_database" "this" {
name = "SQLDatabaseServiceLink"
resource_group_name = var.resource_group_name
data_factory_name = azurerm_data_factory.this.name
connection_string = var.sql_connection_string
key_vault_password {
Parameters
-
additional_properties
optional - map from string to string -
annotations
optional - list of string -
connection_string
required - string -
data_factory_name
required - string -
description
optional - string -
id
optional computed - string -
integration_runtime_name
optional - string -
name
required - string -
parameters
optional - map from string to string -
resource_group_name
required - string -
service_principal_id
optional - string -
service_principal_key
optional - string -
tenant_id
optional - string -
use_managed_identity
optional - bool -
key_vault_password
list block-
linked_service_name
required - string -
secret_name
required - string
-
-
timeouts
single block
Explanation in Terraform Registry
Manages a Linked Service (connection) between Azure SQL Database and Azure Data Factory.
Note: All arguments including the connection_string will be stored in the raw state as plain-text. Read more about sensitive data in state.
Tips: Best Practices for The Other Azure Data Factory Resources
In addition to the azurerm_data_factory, Azure Data Factory has the other resources that should be configured for security reasons. Please check some examples of those resources and precautions.
azurerm_data_factory
Ensure to disable public access
It is better to disable public access for Data Factory, which is enabled as default.
Microsoft.DataFactory/factories/linkedservices (Azure Resource Manager)
The factories/linkedservices in Microsoft.DataFactory can be configured in Azure Resource Manager with the resource name Microsoft.DataFactory/factories/linkedservices
. The following sections describe how to use the resource and its parameters.
Example Usage from GitHub
An example could not be found in GitHub.
Parameters
apiVersion
required - stringname
required - stringThe linked service name.
properties
requiredadditionalProperties
optional - objectUnmatched properties from the message are deserialized this collection
annotations
optional - arrayList of tags that can be used for describing the linked service.
connectVia
optionalparameters
optional - objectAn object mapping parameter names to argument values.
referenceName
required - stringReference integration runtime name.
type
required - stringType of integration runtime.
description
optional - stringLinked service description.
parameters
optional - undefinedDefinition of all parameters for an entity.
type
required - string
Frequently asked questions
What is Azure Data Factory Linked Service Azure SQL Database?
Azure Data Factory Linked Service Azure SQL Database is a resource for Data Factory of Microsoft Azure. Settings can be wrote in Terraform.
Where can I find the example code for the Azure Data Factory Linked Service Azure SQL Database?
For Terraform, the anmoltoppo/Terraform, FabLabGent/InfrastructureFabLabGent and hassepaul/tgtest source code examples are useful. See the Terraform Example section for further details.