Total Page Preview:   000000006257

Create Azure SQL Database Linked Service in Azure Data Factory V2

In this article how to create azure sql linked service in azure data factory (ADF) V2.

In the JSON script, make the following changes:
  1. Replace <servername> with the name of your Azure SQL Database server.
  2. Replace <databasename> with the database in which you created the table and the stored procedure.
  3. Replace <username> with the user account that has access to the database.
  4. Replace <password> with the password for the user account.
 
{
    "name": "AzureSqlLinkedService",
    "properties": {
        "description": "Source Linked Service create for the connect blob storage.",
        "type": "AzureSqlDatabase",
        "typeProperties": {
            "connectionString": {
                "value": "Server = tcp:<servername>.database.windows.net,1433;Initial Catalog=<databasename>; Persist Security Info=False; User ID=<username>; Password=<password>; MultipleActiveResultSets = False;Encrypt = True; TrustServerCertificate = False; Connection Timeout = 30;",
                "type": "SecureString"
            }
        }
    }
}

 

Thank You

About Author

Brijesh Kumar

Database Developer

I have more then 6 years Experience in Microsoft Technologies - SQL Server Database, ETL Azure Cloud - Azure SQL Database, CosmosDB, Azure Data Factory, PowerBI, Web Job, Azure Function, Azure Storage, Web Apps, Powershall and Database Migration On-Premise to Azure Cloud.
LinkedIn : https://www.linkedin.com



Comments

chandra
01-Nov-2017
Good article
Brijesh Kumar
01-Nov-2017
Thanks chandra!
Lisa Osborn
05-Nov-2019
I have worked my ass off to get where I'm at years and years and years and I'm not going to let no one put me down take me down

                           
                           

                           

                           

Facebook User: