Azure Data Factory Linked Service Azure SQL Database

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

anmoltoppo/Terraform

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)

FabLabGent/InfrastructureFabLabGent

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

hassepaul/tgtest

  }
}

module "naming" {
  source = "../../../naming"
  suffix = var.suffix

aztfmod/terraform-azurerm-caf

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)

pkhuntia/aztfmod

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)

mennaammar/spoke-landing-zone

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)

Ibrahimmaga/Terraform

 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"
}

SSC-DSAI/terraform-modules

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
  • create optional - string
  • delete optional - string
  • read optional - string
  • update optional - string

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.