Azure Data Factory Linked Service SQL Server

azurerm_data_factory_linked_service_sql_server (Terraform)

The Linked Service SQL Server in Data Factory can be configured in Terraform with the resource name azurerm_data_factory_linked_service_sql_server. The following sections describe 9 examples of how to use the resource and its parameters.

Example Usage from GitHub

anmoltoppo/Terraform

resource "azurerm_data_factory_linked_service_sql_server" "linked_service_sql_server" {
  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)

pkhuntia/aztfmod

resource "azurerm_data_factory_linked_service_sql_server" "linked_service_sql_server" {
  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)

kevinhead/azurerm

resource "azurerm_data_factory_linked_service_sql_server" "this" {
  additional_properties    = var.additional_properties
  annotations              = var.annotations
  connection_string        = var.connection_string
  data_factory_name        = var.data_factory_name
  description              = var.description

niveklabs/azurerm

resource "azurerm_data_factory_linked_service_sql_server" "this" {
  additional_properties    = var.additional_properties
  annotations              = var.annotations
  connection_string        = var.connection_string
  data_factory_name        = var.data_factory_name
  description              = var.description

aztfmod/terraform-azurerm-caf

resource "azurerm_data_factory_linked_service_sql_server" "linked_service_sql_server" {
  name                     = azurecaf_name.dataset.name
  resource_group_name      = var.resource_group_name
  data_factory_name        = var.data_factory_name
  description              = try(var.settings.description, null)
  integration_runtime_name = try(var.settings.integration_runtime_name, null)

microsoft/cobalt

resource "azurerm_data_factory_linked_service_sql_server" "main" {
  name                     = var.data_factory_linked_sql_name
  resource_group_name      = data.azurerm_resource_group.main.name
  data_factory_name        = azurerm_data_factory.main.name
  connection_string        = var.data_factory_linked_sql_connection_string
  integration_runtime_name = azurerm_data_factory_integration_runtime_managed.main.name

peronealex/datafactory

resource "azurerm_data_factory_linked_service_sql_server" "example" {
  name                = var.name
  resource_group_name = var.resource_group_name
  data_factory_name   = var.name
  connection_string   = "Server=tcp:alessiodatalake.database.windows.net,1433;Initial Catalog=alessiodatalake;Persist Security Info=False;User ID=alessiodatalake;Password={your_password};MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;"
}

mennaammar/spoke-landing-zone

resource "azurerm_data_factory_linked_service_sql_server" "linked_service_sql_server" {
  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)

mod0gsm1th/Terraform-DataFactory

resource "azurerm_data_factory_linked_service_sql_server" "MDSDAFACLSSIS" {
  name                = "mdsdflinkedssis"
  resource_group_name = azurerm_resource_group.MDSDATAFAC.name
  data_factory_name   = azurerm_data_factory.MDSDAFAC.name
  connection_string   = "Integrated Security=False;Data Source=test;Initial Catalog=test;User ID=test;Password=test"
}

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
• 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 a SQL Server and Azure Data Factory.

Note: All arguments including the client secret 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.