none
ADF V2 Deployment via ARM Template

    Question

  • I'm new to ARM templates and JSON and I'm following this guide 

    https://docs.microsoft.com/en-us/azure/data-factory/continuous-integration-deployment

    What format is required for the linked service connection strings?  Please refer to the picture below.

    Also, what am I purchasing?

    Tuesday, June 19, 2018 9:34 PM

All replies

  • Hi,

    # What format is required for the linked service connection strings? 

    Please referrence doc.

    https://docs.microsoft.com/en-us/azure/data-factory/connector-azure-sql-database#using-sql-authentication

    https://docs.microsoft.com/en-us/azure/data-factory/connector-azure-sql-data-warehouse#sql-authentication

    https://docs.microsoft.com/en-us/azure/data-factory/connector-amazon-simple-storage-service#linked-service-properties

    For SQL DW, connectionString should be in form of "Server=tcp:<servername>.database.windows.net,1433;Database=<databasename>;User ID=<username>@<servername>;Password=<password>;Trusted_Connection=False;Encrypt=True;Connection Timeout=30", which is as same as in Azure Sql

    # what am I purchasing?

    With ARM template, you can deploy and automatic test in different environment (production, deployment), with a configuration file recording all connectionStrings and parameters.

    Tuesday, June 19, 2018 11:47 PM