Set up the Azure SQL Database or Azure Dedicated SQL Pool target

Complete the procedure to set up the Azure SQL Database or Azure Dedicated SQL Pool target.

1. Install the database in Azure and complete the following tasks:

   1. Set a firewall rule within Azure to grant permission to the server (where PI Integrator for Business Analytics is installed) to send requests to these targets.

   By default, Azure firewalls prevent outside applications from accessing the Azure SQL Database and Azure Dedicated SQL Pool database servers. Therefore, you must explicitly grant access to the server.

   Tip: Navigate to the Microsoft Azure portal on the machine where PI Integrator for Business Analytics is installed. The client ID field identifying the clients who are being given access to the database servers will be automatically populated with the machine’s IP address.

   1. Grant the SQL user that you enter in the PI Integrator for Business Analytics publish target configuration who will be connecting to Azure SQL Database or Azure Dedicated SQL Pool the following minimum permissions in either Azure SQL Database or Azure Dedicated SQL Pool: CONNECT, SELECT, CREATE TABLE, ALTER, INSERT, DELETE.

2. Add the publish target to PI Integrator for Business Analytics. See Add a publish target.

3. Configure the publish target. Click on the appropriate topic below for your target:

   • Configure the Azure SQL Database target

   • Configure Azure Dedicated SQL Pool target

4. Grant users access to the publish target. See Grant access to targets.