Configure Azure SQL
Decipher IDP supports the use of Azure SQL databases, however some additional configuration is required to support this functionality.
Intended audience
These instructions are intended for database administrators with experience in database management and Azure environments. The installation process requires familiarity with installing and configuring databases.
Prerequisites
-
DecipherServerDb_Script and DecipherServerDbReporting_Script configuration scripts downloaded from the Blue Prism Portal.
Configuration
The following configuration must be in place before installing Decipher IDP.
To use Azure SQL with
-
Create a master Azure database.
-
Open Microsoft SQL Server Management Studio and connect to the server that is hosting your Azure connection.
-
To create the Decipher Server database:
-
In the navigation tree, expand the master database, right-click Databases, and select New database from the context menu.
-
Enter a Database name, and click OK. The default database name is DecipherServerDb.
-
-
Select the new database , create a new query, and run the script named DecipherServerDb_Script.
-
Create another new query, and insert the text below. Before running, change the UpdateDate value to the current date, and ensure the Version column is populated with the relevant value. This should be the version number of the Decipher Server.msi, with the first number increased by 7. For example, if using Decipher Server 2.11.10280, the version value should be 9.11.10280.
CopyINSERT INTO VersionControl (Version, UpdateDate)
VALUES ('9.11.10280', '2022-01-10'); -
If this Decipher IDP installation will use a separate reporting database, repeat steps 2 to 5, but change the following details:
-
Database name – The default database name is DecipherServerDbReporting.
-
Script – Run the script named DecipherServerDbReporting_Script.
-
Create a Blue Prim connection
You need to create a Blue Prism connection to your Azure SQL database.
- If you don't already have Blue Prism installed, install and launch Blue Prism.
- On the Sign in to Blue Prism screen, click Configure connection. The Connection Configuration dialog displays.
- Click New Connection.
-
On the Connection Configuration screen complete the following details:
-
Click Create Database.
-
Click OK.
Connection Name |
Enter an easily recognizable name for the connection. |
Connection Type |
Select SQL Server (Windows Authentication). |
Database Server |
Enter the name of the Azure SQL server. |
Database Name |
Enter a name for the new database, e.g. BluePrism. BluePrism is the default database name when installing the Decipher licensing service. If you create a database using a different name, you will need to enter this name when you install the Decipher licensing service. |
User ID |
Enter the relevant user ID for the Azure server. |
Password |
Enter the relevant password for the Azure server. |
Additional SQL Connection Parameters |
This is not required. |
Azure SQL is now ready for use with Decipher IDP and you can proceed with the Decipher IDP installation. When specifying SQL connections during the installation of the Decipher IDP components, ensure you reference the master Azure database as configured above. For details, see Install Decipher IDP components.