Azure SQL Setup

You can log data and alarms to Azure SQL as well as obtain data using the Recipe feature by specifying SQL Server as the database Provider. The following steps are helpful in setting up Azure SQL for database connections for Data Logging, Alarm Logging, and Recipe data transfer.

Step 1

Log into Azurehttps://azure.microsoft.com

Select your server.

Azure 01

Step 2

Select Show Firewall Settings.

Azure 02

Step 3

Enter a rule name and the IP address range for your OAS System.

Azure 03

Step 4

Use SQL Authentication in the Data Logging Group, Alarm Logging Group, or Recipe Group that you are using to connect Azure SQL.

Tip: If you log into Azure from the PC that has Open Automation Software on it the IP address is displayed to the right of the Client IP address.