Configure Azure Dedicated SQL Pool 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.

  Note: Microsoft has changed the Azure SQL Data Warehouse (Dedicated SQL Pool) product name. As of spring 2024, Microsoft's current product name for this service in the Azure Portal is Dedicated SQL Pool.

1. On the Administration page, click the Targets tab. Then select the target 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	Server name that hosts Azure SQL Database. The format is: server_name.database.windows.net.
   SQL Authentication Username	User name used to connect to Azure Dedicated SQL Pool
   SQL Authentication Password	Password used to connect to Azure Dedicated SQL Pool
   Publishing Timeout	Time allotted for publishing data to the target before the PI Integrator Framework service times out. The default is 30 seconds if the field is left blank.
   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.

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