Configure the Azure SQL Database target

Complete the procedure below to configure the Azure Dedicated SQL Pool target and test your connection to the Azure Dedicated SQL Pool.

• Create the Azure Dedicated SQL Pool.

• Add the Azure Dedicated SQL Pool as a target. For more information, see Add a publish target.

1. On the Administration page, click the Targets tab. Then select Azure SQL Database in the Publish Targets list.

   Note: If you have already selected your target, skip to the next step.

2. Configure the Azure Dedicated SQL Pool target with the following parameters:

   Parameter	Description
   Hostname	Name of the server that hosts Azure SQL Database. The format is: server_name.database.windows.net.
   SQL Authentication Username	Username used to connect to Azure Dedicated SQL Pool.
   SQL Authentication Password	Password used to connect to Azure Dedicated SQL Pool.
   Publishing Timeout	The time PI Integrator Framework service waits for the publish operation to complete before timing out. The default is 30 seconds.
   Use High Availability	(Optional) Connect to a SQL server that supports high availability and failover clusters. Use High Availability turns the MultiSubnetFailover connection property on in the connection string. For more information on this property, refer to the Microsoft web site.
   Database	Name of database in Azure Dedicated SQL Pool in which tables are located.
   Schema	SQL schema associated with the tables where the data is stored.

3. Click Connect.

4. Select the database from the Database list.

5. Click Save Changes.

6. Give users access to the Azure Dedicated SQL Pool target. For more information, see Grant access to targets.