1. Packages
  2. Azure Classic
  3. API Docs
  4. datafactory
  5. LinkedServiceSqlManagedInstance

We recommend using Azure Native.

Viewing docs for Azure v6.33.0
published on Monday, Feb 23, 2026 by Pulumi
azure logo

We recommend using Azure Native.

Viewing docs for Azure v6.33.0
published on Monday, Feb 23, 2026 by Pulumi

    Manages a Linked Service (connection) between Azure SQL Managed Instance 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.

    Example Usage

    import * as pulumi from "@pulumi/pulumi";
    import * as azure from "@pulumi/azure";
    
    const example = new azure.core.ResourceGroup("example", {
        name: "example-resources",
        location: "West Europe",
    });
    const exampleFactory = new azure.datafactory.Factory("example", {
        name: "example",
        location: example.location,
        resourceGroupName: example.name,
    });
    const exampleLinkedServiceSqlManagedInstance = new azure.datafactory.LinkedServiceSqlManagedInstance("example", {
        name: "example",
        dataFactoryId: exampleFactory.id,
        connectionString: "Server=myserver.database.windows.net;Database=mydatabase;User ID=myuser;Password=mypassword;",
    });
    
    import pulumi
    import pulumi_azure as azure
    
    example = azure.core.ResourceGroup("example",
        name="example-resources",
        location="West Europe")
    example_factory = azure.datafactory.Factory("example",
        name="example",
        location=example.location,
        resource_group_name=example.name)
    example_linked_service_sql_managed_instance = azure.datafactory.LinkedServiceSqlManagedInstance("example",
        name="example",
        data_factory_id=example_factory.id,
        connection_string="Server=myserver.database.windows.net;Database=mydatabase;User ID=myuser;Password=mypassword;")
    
    package main
    
    import (
    	"github.com/pulumi/pulumi-azure/sdk/v6/go/azure/core"
    	"github.com/pulumi/pulumi-azure/sdk/v6/go/azure/datafactory"
    	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
    )
    
    func main() {
    	pulumi.Run(func(ctx *pulumi.Context) error {
    		example, err := core.NewResourceGroup(ctx, "example", &core.ResourceGroupArgs{
    			Name:     pulumi.String("example-resources"),
    			Location: pulumi.String("West Europe"),
    		})
    		if err != nil {
    			return err
    		}
    		exampleFactory, err := datafactory.NewFactory(ctx, "example", &datafactory.FactoryArgs{
    			Name:              pulumi.String("example"),
    			Location:          example.Location,
    			ResourceGroupName: example.Name,
    		})
    		if err != nil {
    			return err
    		}
    		_, err = datafactory.NewLinkedServiceSqlManagedInstance(ctx, "example", &datafactory.LinkedServiceSqlManagedInstanceArgs{
    			Name:             pulumi.String("example"),
    			DataFactoryId:    exampleFactory.ID(),
    			ConnectionString: pulumi.String("Server=myserver.database.windows.net;Database=mydatabase;User ID=myuser;Password=mypassword;"),
    		})
    		if err != nil {
    			return err
    		}
    		return nil
    	})
    }
    
    using System.Collections.Generic;
    using System.Linq;
    using Pulumi;
    using Azure = Pulumi.Azure;
    
    return await Deployment.RunAsync(() => 
    {
        var example = new Azure.Core.ResourceGroup("example", new()
        {
            Name = "example-resources",
            Location = "West Europe",
        });
    
        var exampleFactory = new Azure.DataFactory.Factory("example", new()
        {
            Name = "example",
            Location = example.Location,
            ResourceGroupName = example.Name,
        });
    
        var exampleLinkedServiceSqlManagedInstance = new Azure.DataFactory.LinkedServiceSqlManagedInstance("example", new()
        {
            Name = "example",
            DataFactoryId = exampleFactory.Id,
            ConnectionString = "Server=myserver.database.windows.net;Database=mydatabase;User ID=myuser;Password=mypassword;",
        });
    
    });
    
    package generated_program;
    
    import com.pulumi.Context;
    import com.pulumi.Pulumi;
    import com.pulumi.core.Output;
    import com.pulumi.azure.core.ResourceGroup;
    import com.pulumi.azure.core.ResourceGroupArgs;
    import com.pulumi.azure.datafactory.Factory;
    import com.pulumi.azure.datafactory.FactoryArgs;
    import com.pulumi.azure.datafactory.LinkedServiceSqlManagedInstance;
    import com.pulumi.azure.datafactory.LinkedServiceSqlManagedInstanceArgs;
    import java.util.List;
    import java.util.ArrayList;
    import java.util.Map;
    import java.io.File;
    import java.nio.file.Files;
    import java.nio.file.Paths;
    
    public class App {
        public static void main(String[] args) {
            Pulumi.run(App::stack);
        }
    
        public static void stack(Context ctx) {
            var example = new ResourceGroup("example", ResourceGroupArgs.builder()
                .name("example-resources")
                .location("West Europe")
                .build());
    
            var exampleFactory = new Factory("exampleFactory", FactoryArgs.builder()
                .name("example")
                .location(example.location())
                .resourceGroupName(example.name())
                .build());
    
            var exampleLinkedServiceSqlManagedInstance = new LinkedServiceSqlManagedInstance("exampleLinkedServiceSqlManagedInstance", LinkedServiceSqlManagedInstanceArgs.builder()
                .name("example")
                .dataFactoryId(exampleFactory.id())
                .connectionString("Server=myserver.database.windows.net;Database=mydatabase;User ID=myuser;Password=mypassword;")
                .build());
    
        }
    }
    
    resources:
      example:
        type: azure:core:ResourceGroup
        properties:
          name: example-resources
          location: West Europe
      exampleFactory:
        type: azure:datafactory:Factory
        name: example
        properties:
          name: example
          location: ${example.location}
          resourceGroupName: ${example.name}
      exampleLinkedServiceSqlManagedInstance:
        type: azure:datafactory:LinkedServiceSqlManagedInstance
        name: example
        properties:
          name: example
          dataFactoryId: ${exampleFactory.id}
          connectionString: Server=myserver.database.windows.net;Database=mydatabase;User ID=myuser;Password=mypassword;
    

    API Providers

    This resource uses the following Azure API Providers:

    • Microsoft.DataFactory - 2018-06-01

    Create LinkedServiceSqlManagedInstance Resource

    Resources are created with functions called constructors. To learn more about declaring and configuring resources, see Resources.

    Constructor syntax

    new LinkedServiceSqlManagedInstance(name: string, args: LinkedServiceSqlManagedInstanceArgs, opts?: CustomResourceOptions);
    @overload
    def LinkedServiceSqlManagedInstance(resource_name: str,
                                        args: LinkedServiceSqlManagedInstanceArgs,
                                        opts: Optional[ResourceOptions] = None)
    
    @overload
    def LinkedServiceSqlManagedInstance(resource_name: str,
                                        opts: Optional[ResourceOptions] = None,
                                        data_factory_id: Optional[str] = None,
                                        annotations: Optional[Sequence[str]] = None,
                                        connection_string: Optional[str] = None,
                                        description: Optional[str] = None,
                                        integration_runtime_name: Optional[str] = None,
                                        key_vault_connection_string: Optional[LinkedServiceSqlManagedInstanceKeyVaultConnectionStringArgs] = None,
                                        key_vault_password: Optional[LinkedServiceSqlManagedInstanceKeyVaultPasswordArgs] = None,
                                        name: Optional[str] = None,
                                        parameters: Optional[Mapping[str, str]] = None,
                                        service_principal_id: Optional[str] = None,
                                        service_principal_key: Optional[str] = None,
                                        tenant: Optional[str] = None)
    func NewLinkedServiceSqlManagedInstance(ctx *Context, name string, args LinkedServiceSqlManagedInstanceArgs, opts ...ResourceOption) (*LinkedServiceSqlManagedInstance, error)
    public LinkedServiceSqlManagedInstance(string name, LinkedServiceSqlManagedInstanceArgs args, CustomResourceOptions? opts = null)
    public LinkedServiceSqlManagedInstance(String name, LinkedServiceSqlManagedInstanceArgs args)
    public LinkedServiceSqlManagedInstance(String name, LinkedServiceSqlManagedInstanceArgs args, CustomResourceOptions options)
    
    type: azure:datafactory:LinkedServiceSqlManagedInstance
    properties: # The arguments to resource properties.
    options: # Bag of options to control resource's behavior.
    
    

    Parameters

    name string
    The unique name of the resource.
    args LinkedServiceSqlManagedInstanceArgs
    The arguments to resource properties.
    opts CustomResourceOptions
    Bag of options to control resource's behavior.
    resource_name str
    The unique name of the resource.
    args LinkedServiceSqlManagedInstanceArgs
    The arguments to resource properties.
    opts ResourceOptions
    Bag of options to control resource's behavior.
    ctx Context
    Context object for the current deployment.
    name string
    The unique name of the resource.
    args LinkedServiceSqlManagedInstanceArgs
    The arguments to resource properties.
    opts ResourceOption
    Bag of options to control resource's behavior.
    name string
    The unique name of the resource.
    args LinkedServiceSqlManagedInstanceArgs
    The arguments to resource properties.
    opts CustomResourceOptions
    Bag of options to control resource's behavior.
    name String
    The unique name of the resource.
    args LinkedServiceSqlManagedInstanceArgs
    The arguments to resource properties.
    options CustomResourceOptions
    Bag of options to control resource's behavior.

    Constructor example

    The following reference example uses placeholder values for all input properties.

    var linkedServiceSqlManagedInstanceResource = new Azure.DataFactory.LinkedServiceSqlManagedInstance("linkedServiceSqlManagedInstanceResource", new()
    {
        DataFactoryId = "string",
        Annotations = new[]
        {
            "string",
        },
        ConnectionString = "string",
        Description = "string",
        IntegrationRuntimeName = "string",
        KeyVaultConnectionString = new Azure.DataFactory.Inputs.LinkedServiceSqlManagedInstanceKeyVaultConnectionStringArgs
        {
            LinkedServiceName = "string",
            SecretName = "string",
        },
        KeyVaultPassword = new Azure.DataFactory.Inputs.LinkedServiceSqlManagedInstanceKeyVaultPasswordArgs
        {
            LinkedServiceName = "string",
            SecretName = "string",
        },
        Name = "string",
        Parameters = 
        {
            { "string", "string" },
        },
        ServicePrincipalId = "string",
        ServicePrincipalKey = "string",
        Tenant = "string",
    });
    
    example, err := datafactory.NewLinkedServiceSqlManagedInstance(ctx, "linkedServiceSqlManagedInstanceResource", &datafactory.LinkedServiceSqlManagedInstanceArgs{
    	DataFactoryId: pulumi.String("string"),
    	Annotations: pulumi.StringArray{
    		pulumi.String("string"),
    	},
    	ConnectionString:       pulumi.String("string"),
    	Description:            pulumi.String("string"),
    	IntegrationRuntimeName: pulumi.String("string"),
    	KeyVaultConnectionString: &datafactory.LinkedServiceSqlManagedInstanceKeyVaultConnectionStringArgs{
    		LinkedServiceName: pulumi.String("string"),
    		SecretName:        pulumi.String("string"),
    	},
    	KeyVaultPassword: &datafactory.LinkedServiceSqlManagedInstanceKeyVaultPasswordArgs{
    		LinkedServiceName: pulumi.String("string"),
    		SecretName:        pulumi.String("string"),
    	},
    	Name: pulumi.String("string"),
    	Parameters: pulumi.StringMap{
    		"string": pulumi.String("string"),
    	},
    	ServicePrincipalId:  pulumi.String("string"),
    	ServicePrincipalKey: pulumi.String("string"),
    	Tenant:              pulumi.String("string"),
    })
    
    var linkedServiceSqlManagedInstanceResource = new LinkedServiceSqlManagedInstance("linkedServiceSqlManagedInstanceResource", LinkedServiceSqlManagedInstanceArgs.builder()
        .dataFactoryId("string")
        .annotations("string")
        .connectionString("string")
        .description("string")
        .integrationRuntimeName("string")
        .keyVaultConnectionString(LinkedServiceSqlManagedInstanceKeyVaultConnectionStringArgs.builder()
            .linkedServiceName("string")
            .secretName("string")
            .build())
        .keyVaultPassword(LinkedServiceSqlManagedInstanceKeyVaultPasswordArgs.builder()
            .linkedServiceName("string")
            .secretName("string")
            .build())
        .name("string")
        .parameters(Map.of("string", "string"))
        .servicePrincipalId("string")
        .servicePrincipalKey("string")
        .tenant("string")
        .build());
    
    linked_service_sql_managed_instance_resource = azure.datafactory.LinkedServiceSqlManagedInstance("linkedServiceSqlManagedInstanceResource",
        data_factory_id="string",
        annotations=["string"],
        connection_string="string",
        description="string",
        integration_runtime_name="string",
        key_vault_connection_string={
            "linked_service_name": "string",
            "secret_name": "string",
        },
        key_vault_password={
            "linked_service_name": "string",
            "secret_name": "string",
        },
        name="string",
        parameters={
            "string": "string",
        },
        service_principal_id="string",
        service_principal_key="string",
        tenant="string")
    
    const linkedServiceSqlManagedInstanceResource = new azure.datafactory.LinkedServiceSqlManagedInstance("linkedServiceSqlManagedInstanceResource", {
        dataFactoryId: "string",
        annotations: ["string"],
        connectionString: "string",
        description: "string",
        integrationRuntimeName: "string",
        keyVaultConnectionString: {
            linkedServiceName: "string",
            secretName: "string",
        },
        keyVaultPassword: {
            linkedServiceName: "string",
            secretName: "string",
        },
        name: "string",
        parameters: {
            string: "string",
        },
        servicePrincipalId: "string",
        servicePrincipalKey: "string",
        tenant: "string",
    });
    
    type: azure:datafactory:LinkedServiceSqlManagedInstance
    properties:
        annotations:
            - string
        connectionString: string
        dataFactoryId: string
        description: string
        integrationRuntimeName: string
        keyVaultConnectionString:
            linkedServiceName: string
            secretName: string
        keyVaultPassword:
            linkedServiceName: string
            secretName: string
        name: string
        parameters:
            string: string
        servicePrincipalId: string
        servicePrincipalKey: string
        tenant: string
    

    LinkedServiceSqlManagedInstance Resource Properties

    To learn more about resource properties and how to use them, see Inputs and Outputs in the Architecture and Concepts docs.

    Inputs

    In Python, inputs that are objects can be passed either as argument classes or as dictionary literals.

    The LinkedServiceSqlManagedInstance resource accepts the following input properties:

    DataFactoryId string
    The Data Factory ID in which to associate the Linked Service with. Changing this forces a new resource to be created.
    Annotations List<string>
    List of tags that can be used for describing the Data Factory Linked Service SQL Managed Instance.
    ConnectionString string

    The connection string in which to authenticate with the SQL Managed Instance. Exactly one of either connection_string or key_vault_connection_string is required.

    Note: When using service principal authentication, the connection string must not contain authentication values like User Id.

    Description string
    The description for the Data Factory Linked Service SQL Managed Instance.
    IntegrationRuntimeName string
    The integration runtime reference to associate with the Data Factory Linked Service SQL Managed Instance.
    KeyVaultConnectionString LinkedServiceSqlManagedInstanceKeyVaultConnectionString
    A key_vault_connection_string block as defined below. Use this argument to store SQL Managed Instance connection string in an existing Key Vault. It needs an existing Key Vault Data Factory Linked Service. Exactly one of either connection_string or key_vault_connection_string is required.
    KeyVaultPassword LinkedServiceSqlManagedInstanceKeyVaultPassword
    A key_vault_password block as defined below. Use this argument to store SQL Managed Instance password in an existing Key Vault. It needs an existing Key Vault Data Factory Linked Service.
    Name string
    Specifies the name of the Data Factory Linked Service SQL Managed Instance. Changing this forces a new resource to be created. Must be unique within a data factory. See the Microsoft documentation for all restrictions.
    Parameters Dictionary<string, string>
    A map of parameters to associate with the Data Factory Linked Service SQL Managed Instance.
    ServicePrincipalId string
    The service principal id in which to authenticate against the Azure SQL Managed Instance.
    ServicePrincipalKey string
    The service principal key in which to authenticate against the Azure SQL Managed Instance.
    Tenant string
    The tenant id or name in which to authenticate against the Azure SQL Managed Instance.
    DataFactoryId string
    The Data Factory ID in which to associate the Linked Service with. Changing this forces a new resource to be created.
    Annotations []string
    List of tags that can be used for describing the Data Factory Linked Service SQL Managed Instance.
    ConnectionString string

    The connection string in which to authenticate with the SQL Managed Instance. Exactly one of either connection_string or key_vault_connection_string is required.

    Note: When using service principal authentication, the connection string must not contain authentication values like User Id.

    Description string
    The description for the Data Factory Linked Service SQL Managed Instance.
    IntegrationRuntimeName string
    The integration runtime reference to associate with the Data Factory Linked Service SQL Managed Instance.
    KeyVaultConnectionString LinkedServiceSqlManagedInstanceKeyVaultConnectionStringArgs
    A key_vault_connection_string block as defined below. Use this argument to store SQL Managed Instance connection string in an existing Key Vault. It needs an existing Key Vault Data Factory Linked Service. Exactly one of either connection_string or key_vault_connection_string is required.
    KeyVaultPassword LinkedServiceSqlManagedInstanceKeyVaultPasswordArgs
    A key_vault_password block as defined below. Use this argument to store SQL Managed Instance password in an existing Key Vault. It needs an existing Key Vault Data Factory Linked Service.
    Name string
    Specifies the name of the Data Factory Linked Service SQL Managed Instance. Changing this forces a new resource to be created. Must be unique within a data factory. See the Microsoft documentation for all restrictions.
    Parameters map[string]string
    A map of parameters to associate with the Data Factory Linked Service SQL Managed Instance.
    ServicePrincipalId string
    The service principal id in which to authenticate against the Azure SQL Managed Instance.
    ServicePrincipalKey string
    The service principal key in which to authenticate against the Azure SQL Managed Instance.
    Tenant string
    The tenant id or name in which to authenticate against the Azure SQL Managed Instance.
    dataFactoryId String
    The Data Factory ID in which to associate the Linked Service with. Changing this forces a new resource to be created.
    annotations List<String>
    List of tags that can be used for describing the Data Factory Linked Service SQL Managed Instance.
    connectionString String

    The connection string in which to authenticate with the SQL Managed Instance. Exactly one of either connection_string or key_vault_connection_string is required.

    Note: When using service principal authentication, the connection string must not contain authentication values like User Id.

    description String
    The description for the Data Factory Linked Service SQL Managed Instance.
    integrationRuntimeName String
    The integration runtime reference to associate with the Data Factory Linked Service SQL Managed Instance.
    keyVaultConnectionString LinkedServiceSqlManagedInstanceKeyVaultConnectionString
    A key_vault_connection_string block as defined below. Use this argument to store SQL Managed Instance connection string in an existing Key Vault. It needs an existing Key Vault Data Factory Linked Service. Exactly one of either connection_string or key_vault_connection_string is required.
    keyVaultPassword LinkedServiceSqlManagedInstanceKeyVaultPassword
    A key_vault_password block as defined below. Use this argument to store SQL Managed Instance password in an existing Key Vault. It needs an existing Key Vault Data Factory Linked Service.
    name String
    Specifies the name of the Data Factory Linked Service SQL Managed Instance. Changing this forces a new resource to be created. Must be unique within a data factory. See the Microsoft documentation for all restrictions.
    parameters Map<String,String>
    A map of parameters to associate with the Data Factory Linked Service SQL Managed Instance.
    servicePrincipalId String
    The service principal id in which to authenticate against the Azure SQL Managed Instance.
    servicePrincipalKey String
    The service principal key in which to authenticate against the Azure SQL Managed Instance.
    tenant String
    The tenant id or name in which to authenticate against the Azure SQL Managed Instance.
    dataFactoryId string
    The Data Factory ID in which to associate the Linked Service with. Changing this forces a new resource to be created.
    annotations string[]
    List of tags that can be used for describing the Data Factory Linked Service SQL Managed Instance.
    connectionString string

    The connection string in which to authenticate with the SQL Managed Instance. Exactly one of either connection_string or key_vault_connection_string is required.

    Note: When using service principal authentication, the connection string must not contain authentication values like User Id.

    description string
    The description for the Data Factory Linked Service SQL Managed Instance.
    integrationRuntimeName string
    The integration runtime reference to associate with the Data Factory Linked Service SQL Managed Instance.
    keyVaultConnectionString LinkedServiceSqlManagedInstanceKeyVaultConnectionString
    A key_vault_connection_string block as defined below. Use this argument to store SQL Managed Instance connection string in an existing Key Vault. It needs an existing Key Vault Data Factory Linked Service. Exactly one of either connection_string or key_vault_connection_string is required.
    keyVaultPassword LinkedServiceSqlManagedInstanceKeyVaultPassword
    A key_vault_password block as defined below. Use this argument to store SQL Managed Instance password in an existing Key Vault. It needs an existing Key Vault Data Factory Linked Service.
    name string
    Specifies the name of the Data Factory Linked Service SQL Managed Instance. Changing this forces a new resource to be created. Must be unique within a data factory. See the Microsoft documentation for all restrictions.
    parameters {[key: string]: string}
    A map of parameters to associate with the Data Factory Linked Service SQL Managed Instance.
    servicePrincipalId string
    The service principal id in which to authenticate against the Azure SQL Managed Instance.
    servicePrincipalKey string
    The service principal key in which to authenticate against the Azure SQL Managed Instance.
    tenant string
    The tenant id or name in which to authenticate against the Azure SQL Managed Instance.
    data_factory_id str
    The Data Factory ID in which to associate the Linked Service with. Changing this forces a new resource to be created.
    annotations Sequence[str]
    List of tags that can be used for describing the Data Factory Linked Service SQL Managed Instance.
    connection_string str

    The connection string in which to authenticate with the SQL Managed Instance. Exactly one of either connection_string or key_vault_connection_string is required.

    Note: When using service principal authentication, the connection string must not contain authentication values like User Id.

    description str
    The description for the Data Factory Linked Service SQL Managed Instance.
    integration_runtime_name str
    The integration runtime reference to associate with the Data Factory Linked Service SQL Managed Instance.
    key_vault_connection_string LinkedServiceSqlManagedInstanceKeyVaultConnectionStringArgs
    A key_vault_connection_string block as defined below. Use this argument to store SQL Managed Instance connection string in an existing Key Vault. It needs an existing Key Vault Data Factory Linked Service. Exactly one of either connection_string or key_vault_connection_string is required.
    key_vault_password LinkedServiceSqlManagedInstanceKeyVaultPasswordArgs
    A key_vault_password block as defined below. Use this argument to store SQL Managed Instance password in an existing Key Vault. It needs an existing Key Vault Data Factory Linked Service.
    name str
    Specifies the name of the Data Factory Linked Service SQL Managed Instance. Changing this forces a new resource to be created. Must be unique within a data factory. See the Microsoft documentation for all restrictions.
    parameters Mapping[str, str]
    A map of parameters to associate with the Data Factory Linked Service SQL Managed Instance.
    service_principal_id str
    The service principal id in which to authenticate against the Azure SQL Managed Instance.
    service_principal_key str
    The service principal key in which to authenticate against the Azure SQL Managed Instance.
    tenant str
    The tenant id or name in which to authenticate against the Azure SQL Managed Instance.
    dataFactoryId String
    The Data Factory ID in which to associate the Linked Service with. Changing this forces a new resource to be created.
    annotations List<String>
    List of tags that can be used for describing the Data Factory Linked Service SQL Managed Instance.
    connectionString String

    The connection string in which to authenticate with the SQL Managed Instance. Exactly one of either connection_string or key_vault_connection_string is required.

    Note: When using service principal authentication, the connection string must not contain authentication values like User Id.

    description String
    The description for the Data Factory Linked Service SQL Managed Instance.
    integrationRuntimeName String
    The integration runtime reference to associate with the Data Factory Linked Service SQL Managed Instance.
    keyVaultConnectionString Property Map
    A key_vault_connection_string block as defined below. Use this argument to store SQL Managed Instance connection string in an existing Key Vault. It needs an existing Key Vault Data Factory Linked Service. Exactly one of either connection_string or key_vault_connection_string is required.
    keyVaultPassword Property Map
    A key_vault_password block as defined below. Use this argument to store SQL Managed Instance password in an existing Key Vault. It needs an existing Key Vault Data Factory Linked Service.
    name String
    Specifies the name of the Data Factory Linked Service SQL Managed Instance. Changing this forces a new resource to be created. Must be unique within a data factory. See the Microsoft documentation for all restrictions.
    parameters Map<String>
    A map of parameters to associate with the Data Factory Linked Service SQL Managed Instance.
    servicePrincipalId String
    The service principal id in which to authenticate against the Azure SQL Managed Instance.
    servicePrincipalKey String
    The service principal key in which to authenticate against the Azure SQL Managed Instance.
    tenant String
    The tenant id or name in which to authenticate against the Azure SQL Managed Instance.

    Outputs

    All input properties are implicitly available as output properties. Additionally, the LinkedServiceSqlManagedInstance resource produces the following output properties:

    Id string
    The provider-assigned unique ID for this managed resource.
    Id string
    The provider-assigned unique ID for this managed resource.
    id String
    The provider-assigned unique ID for this managed resource.
    id string
    The provider-assigned unique ID for this managed resource.
    id str
    The provider-assigned unique ID for this managed resource.
    id String
    The provider-assigned unique ID for this managed resource.

    Look up Existing LinkedServiceSqlManagedInstance Resource

    Get an existing LinkedServiceSqlManagedInstance resource’s state with the given name, ID, and optional extra properties used to qualify the lookup.

    public static get(name: string, id: Input<ID>, state?: LinkedServiceSqlManagedInstanceState, opts?: CustomResourceOptions): LinkedServiceSqlManagedInstance
    @staticmethod
    def get(resource_name: str,
            id: str,
            opts: Optional[ResourceOptions] = None,
            annotations: Optional[Sequence[str]] = None,
            connection_string: Optional[str] = None,
            data_factory_id: Optional[str] = None,
            description: Optional[str] = None,
            integration_runtime_name: Optional[str] = None,
            key_vault_connection_string: Optional[LinkedServiceSqlManagedInstanceKeyVaultConnectionStringArgs] = None,
            key_vault_password: Optional[LinkedServiceSqlManagedInstanceKeyVaultPasswordArgs] = None,
            name: Optional[str] = None,
            parameters: Optional[Mapping[str, str]] = None,
            service_principal_id: Optional[str] = None,
            service_principal_key: Optional[str] = None,
            tenant: Optional[str] = None) -> LinkedServiceSqlManagedInstance
    func GetLinkedServiceSqlManagedInstance(ctx *Context, name string, id IDInput, state *LinkedServiceSqlManagedInstanceState, opts ...ResourceOption) (*LinkedServiceSqlManagedInstance, error)
    public static LinkedServiceSqlManagedInstance Get(string name, Input<string> id, LinkedServiceSqlManagedInstanceState? state, CustomResourceOptions? opts = null)
    public static LinkedServiceSqlManagedInstance get(String name, Output<String> id, LinkedServiceSqlManagedInstanceState state, CustomResourceOptions options)
    resources:  _:    type: azure:datafactory:LinkedServiceSqlManagedInstance    get:      id: ${id}
    name
    The unique name of the resulting resource.
    id
    The unique provider ID of the resource to lookup.
    state
    Any extra arguments used during the lookup.
    opts
    A bag of options that control this resource's behavior.
    resource_name
    The unique name of the resulting resource.
    id
    The unique provider ID of the resource to lookup.
    name
    The unique name of the resulting resource.
    id
    The unique provider ID of the resource to lookup.
    state
    Any extra arguments used during the lookup.
    opts
    A bag of options that control this resource's behavior.
    name
    The unique name of the resulting resource.
    id
    The unique provider ID of the resource to lookup.
    state
    Any extra arguments used during the lookup.
    opts
    A bag of options that control this resource's behavior.
    name
    The unique name of the resulting resource.
    id
    The unique provider ID of the resource to lookup.
    state
    Any extra arguments used during the lookup.
    opts
    A bag of options that control this resource's behavior.
    The following state arguments are supported:
    Annotations List<string>
    List of tags that can be used for describing the Data Factory Linked Service SQL Managed Instance.
    ConnectionString string

    The connection string in which to authenticate with the SQL Managed Instance. Exactly one of either connection_string or key_vault_connection_string is required.

    Note: When using service principal authentication, the connection string must not contain authentication values like User Id.

    DataFactoryId string
    The Data Factory ID in which to associate the Linked Service with. Changing this forces a new resource to be created.
    Description string
    The description for the Data Factory Linked Service SQL Managed Instance.
    IntegrationRuntimeName string
    The integration runtime reference to associate with the Data Factory Linked Service SQL Managed Instance.
    KeyVaultConnectionString LinkedServiceSqlManagedInstanceKeyVaultConnectionString
    A key_vault_connection_string block as defined below. Use this argument to store SQL Managed Instance connection string in an existing Key Vault. It needs an existing Key Vault Data Factory Linked Service. Exactly one of either connection_string or key_vault_connection_string is required.
    KeyVaultPassword LinkedServiceSqlManagedInstanceKeyVaultPassword
    A key_vault_password block as defined below. Use this argument to store SQL Managed Instance password in an existing Key Vault. It needs an existing Key Vault Data Factory Linked Service.
    Name string
    Specifies the name of the Data Factory Linked Service SQL Managed Instance. Changing this forces a new resource to be created. Must be unique within a data factory. See the Microsoft documentation for all restrictions.
    Parameters Dictionary<string, string>
    A map of parameters to associate with the Data Factory Linked Service SQL Managed Instance.
    ServicePrincipalId string
    The service principal id in which to authenticate against the Azure SQL Managed Instance.
    ServicePrincipalKey string
    The service principal key in which to authenticate against the Azure SQL Managed Instance.
    Tenant string
    The tenant id or name in which to authenticate against the Azure SQL Managed Instance.
    Annotations []string
    List of tags that can be used for describing the Data Factory Linked Service SQL Managed Instance.
    ConnectionString string

    The connection string in which to authenticate with the SQL Managed Instance. Exactly one of either connection_string or key_vault_connection_string is required.

    Note: When using service principal authentication, the connection string must not contain authentication values like User Id.

    DataFactoryId string
    The Data Factory ID in which to associate the Linked Service with. Changing this forces a new resource to be created.
    Description string
    The description for the Data Factory Linked Service SQL Managed Instance.
    IntegrationRuntimeName string
    The integration runtime reference to associate with the Data Factory Linked Service SQL Managed Instance.
    KeyVaultConnectionString LinkedServiceSqlManagedInstanceKeyVaultConnectionStringArgs
    A key_vault_connection_string block as defined below. Use this argument to store SQL Managed Instance connection string in an existing Key Vault. It needs an existing Key Vault Data Factory Linked Service. Exactly one of either connection_string or key_vault_connection_string is required.
    KeyVaultPassword LinkedServiceSqlManagedInstanceKeyVaultPasswordArgs
    A key_vault_password block as defined below. Use this argument to store SQL Managed Instance password in an existing Key Vault. It needs an existing Key Vault Data Factory Linked Service.
    Name string
    Specifies the name of the Data Factory Linked Service SQL Managed Instance. Changing this forces a new resource to be created. Must be unique within a data factory. See the Microsoft documentation for all restrictions.
    Parameters map[string]string
    A map of parameters to associate with the Data Factory Linked Service SQL Managed Instance.
    ServicePrincipalId string
    The service principal id in which to authenticate against the Azure SQL Managed Instance.
    ServicePrincipalKey string
    The service principal key in which to authenticate against the Azure SQL Managed Instance.
    Tenant string
    The tenant id or name in which to authenticate against the Azure SQL Managed Instance.
    annotations List<String>
    List of tags that can be used for describing the Data Factory Linked Service SQL Managed Instance.
    connectionString String

    The connection string in which to authenticate with the SQL Managed Instance. Exactly one of either connection_string or key_vault_connection_string is required.

    Note: When using service principal authentication, the connection string must not contain authentication values like User Id.

    dataFactoryId String
    The Data Factory ID in which to associate the Linked Service with. Changing this forces a new resource to be created.
    description String
    The description for the Data Factory Linked Service SQL Managed Instance.
    integrationRuntimeName String
    The integration runtime reference to associate with the Data Factory Linked Service SQL Managed Instance.
    keyVaultConnectionString LinkedServiceSqlManagedInstanceKeyVaultConnectionString
    A key_vault_connection_string block as defined below. Use this argument to store SQL Managed Instance connection string in an existing Key Vault. It needs an existing Key Vault Data Factory Linked Service. Exactly one of either connection_string or key_vault_connection_string is required.
    keyVaultPassword LinkedServiceSqlManagedInstanceKeyVaultPassword
    A key_vault_password block as defined below. Use this argument to store SQL Managed Instance password in an existing Key Vault. It needs an existing Key Vault Data Factory Linked Service.
    name String
    Specifies the name of the Data Factory Linked Service SQL Managed Instance. Changing this forces a new resource to be created. Must be unique within a data factory. See the Microsoft documentation for all restrictions.
    parameters Map<String,String>
    A map of parameters to associate with the Data Factory Linked Service SQL Managed Instance.
    servicePrincipalId String
    The service principal id in which to authenticate against the Azure SQL Managed Instance.
    servicePrincipalKey String
    The service principal key in which to authenticate against the Azure SQL Managed Instance.
    tenant String
    The tenant id or name in which to authenticate against the Azure SQL Managed Instance.
    annotations string[]
    List of tags that can be used for describing the Data Factory Linked Service SQL Managed Instance.
    connectionString string

    The connection string in which to authenticate with the SQL Managed Instance. Exactly one of either connection_string or key_vault_connection_string is required.

    Note: When using service principal authentication, the connection string must not contain authentication values like User Id.

    dataFactoryId string
    The Data Factory ID in which to associate the Linked Service with. Changing this forces a new resource to be created.
    description string
    The description for the Data Factory Linked Service SQL Managed Instance.
    integrationRuntimeName string
    The integration runtime reference to associate with the Data Factory Linked Service SQL Managed Instance.
    keyVaultConnectionString LinkedServiceSqlManagedInstanceKeyVaultConnectionString
    A key_vault_connection_string block as defined below. Use this argument to store SQL Managed Instance connection string in an existing Key Vault. It needs an existing Key Vault Data Factory Linked Service. Exactly one of either connection_string or key_vault_connection_string is required.
    keyVaultPassword LinkedServiceSqlManagedInstanceKeyVaultPassword
    A key_vault_password block as defined below. Use this argument to store SQL Managed Instance password in an existing Key Vault. It needs an existing Key Vault Data Factory Linked Service.
    name string
    Specifies the name of the Data Factory Linked Service SQL Managed Instance. Changing this forces a new resource to be created. Must be unique within a data factory. See the Microsoft documentation for all restrictions.
    parameters {[key: string]: string}
    A map of parameters to associate with the Data Factory Linked Service SQL Managed Instance.
    servicePrincipalId string
    The service principal id in which to authenticate against the Azure SQL Managed Instance.
    servicePrincipalKey string
    The service principal key in which to authenticate against the Azure SQL Managed Instance.
    tenant string
    The tenant id or name in which to authenticate against the Azure SQL Managed Instance.
    annotations Sequence[str]
    List of tags that can be used for describing the Data Factory Linked Service SQL Managed Instance.
    connection_string str

    The connection string in which to authenticate with the SQL Managed Instance. Exactly one of either connection_string or key_vault_connection_string is required.

    Note: When using service principal authentication, the connection string must not contain authentication values like User Id.

    data_factory_id str
    The Data Factory ID in which to associate the Linked Service with. Changing this forces a new resource to be created.
    description str
    The description for the Data Factory Linked Service SQL Managed Instance.
    integration_runtime_name str
    The integration runtime reference to associate with the Data Factory Linked Service SQL Managed Instance.
    key_vault_connection_string LinkedServiceSqlManagedInstanceKeyVaultConnectionStringArgs
    A key_vault_connection_string block as defined below. Use this argument to store SQL Managed Instance connection string in an existing Key Vault. It needs an existing Key Vault Data Factory Linked Service. Exactly one of either connection_string or key_vault_connection_string is required.
    key_vault_password LinkedServiceSqlManagedInstanceKeyVaultPasswordArgs
    A key_vault_password block as defined below. Use this argument to store SQL Managed Instance password in an existing Key Vault. It needs an existing Key Vault Data Factory Linked Service.
    name str
    Specifies the name of the Data Factory Linked Service SQL Managed Instance. Changing this forces a new resource to be created. Must be unique within a data factory. See the Microsoft documentation for all restrictions.
    parameters Mapping[str, str]
    A map of parameters to associate with the Data Factory Linked Service SQL Managed Instance.
    service_principal_id str
    The service principal id in which to authenticate against the Azure SQL Managed Instance.
    service_principal_key str
    The service principal key in which to authenticate against the Azure SQL Managed Instance.
    tenant str
    The tenant id or name in which to authenticate against the Azure SQL Managed Instance.
    annotations List<String>
    List of tags that can be used for describing the Data Factory Linked Service SQL Managed Instance.
    connectionString String

    The connection string in which to authenticate with the SQL Managed Instance. Exactly one of either connection_string or key_vault_connection_string is required.

    Note: When using service principal authentication, the connection string must not contain authentication values like User Id.

    dataFactoryId String
    The Data Factory ID in which to associate the Linked Service with. Changing this forces a new resource to be created.
    description String
    The description for the Data Factory Linked Service SQL Managed Instance.
    integrationRuntimeName String
    The integration runtime reference to associate with the Data Factory Linked Service SQL Managed Instance.
    keyVaultConnectionString Property Map
    A key_vault_connection_string block as defined below. Use this argument to store SQL Managed Instance connection string in an existing Key Vault. It needs an existing Key Vault Data Factory Linked Service. Exactly one of either connection_string or key_vault_connection_string is required.
    keyVaultPassword Property Map
    A key_vault_password block as defined below. Use this argument to store SQL Managed Instance password in an existing Key Vault. It needs an existing Key Vault Data Factory Linked Service.
    name String
    Specifies the name of the Data Factory Linked Service SQL Managed Instance. Changing this forces a new resource to be created. Must be unique within a data factory. See the Microsoft documentation for all restrictions.
    parameters Map<String>
    A map of parameters to associate with the Data Factory Linked Service SQL Managed Instance.
    servicePrincipalId String
    The service principal id in which to authenticate against the Azure SQL Managed Instance.
    servicePrincipalKey String
    The service principal key in which to authenticate against the Azure SQL Managed Instance.
    tenant String
    The tenant id or name in which to authenticate against the Azure SQL Managed Instance.

    Supporting Types

    LinkedServiceSqlManagedInstanceKeyVaultConnectionString, LinkedServiceSqlManagedInstanceKeyVaultConnectionStringArgs

    LinkedServiceName string
    Specifies the name of an existing Key Vault Data Factory Linked Service.
    SecretName string
    Specifies the secret name in Azure Key Vault that stores SQL Managed Instance connection string.
    LinkedServiceName string
    Specifies the name of an existing Key Vault Data Factory Linked Service.
    SecretName string
    Specifies the secret name in Azure Key Vault that stores SQL Managed Instance connection string.
    linkedServiceName String
    Specifies the name of an existing Key Vault Data Factory Linked Service.
    secretName String
    Specifies the secret name in Azure Key Vault that stores SQL Managed Instance connection string.
    linkedServiceName string
    Specifies the name of an existing Key Vault Data Factory Linked Service.
    secretName string
    Specifies the secret name in Azure Key Vault that stores SQL Managed Instance connection string.
    linked_service_name str
    Specifies the name of an existing Key Vault Data Factory Linked Service.
    secret_name str
    Specifies the secret name in Azure Key Vault that stores SQL Managed Instance connection string.
    linkedServiceName String
    Specifies the name of an existing Key Vault Data Factory Linked Service.
    secretName String
    Specifies the secret name in Azure Key Vault that stores SQL Managed Instance connection string.

    LinkedServiceSqlManagedInstanceKeyVaultPassword, LinkedServiceSqlManagedInstanceKeyVaultPasswordArgs

    LinkedServiceName string
    Specifies the name of an existing Key Vault Data Factory Linked Service.
    SecretName string
    Specifies the secret name in Azure Key Vault that stores SQL Managed Instance password.
    LinkedServiceName string
    Specifies the name of an existing Key Vault Data Factory Linked Service.
    SecretName string
    Specifies the secret name in Azure Key Vault that stores SQL Managed Instance password.
    linkedServiceName String
    Specifies the name of an existing Key Vault Data Factory Linked Service.
    secretName String
    Specifies the secret name in Azure Key Vault that stores SQL Managed Instance password.
    linkedServiceName string
    Specifies the name of an existing Key Vault Data Factory Linked Service.
    secretName string
    Specifies the secret name in Azure Key Vault that stores SQL Managed Instance password.
    linked_service_name str
    Specifies the name of an existing Key Vault Data Factory Linked Service.
    secret_name str
    Specifies the secret name in Azure Key Vault that stores SQL Managed Instance password.
    linkedServiceName String
    Specifies the name of an existing Key Vault Data Factory Linked Service.
    secretName String
    Specifies the secret name in Azure Key Vault that stores SQL Managed Instance password.

    Import

    Data Factory Linked Service SQL Managed Instances can be imported using the resource id, e.g.

    $ pulumi import azure:datafactory/linkedServiceSqlManagedInstance:LinkedServiceSqlManagedInstance example /subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/example-resources/providers/Microsoft.DataFactory/factories/example/linkedServices/example
    

    To learn more about importing existing cloud resources, see Importing resources.

    Package Details

    Repository
    Azure Classic pulumi/pulumi-azure
    License
    Apache-2.0
    Notes
    This Pulumi package is based on the azurerm Terraform Provider.
    azure logo

    We recommend using Azure Native.

    Viewing docs for Azure v6.33.0
    published on Monday, Feb 23, 2026 by Pulumi
      Try Pulumi Cloud free. Your team will thank you.