DocsDatabase connections
The connections dialog allows you to store different database connection configurations. All connections require a name, and depending on the connection type other information is required.
For important information and restrictions relating to interacting with and modifying the database, see Customizing the database.
Connection types
Blue Prism server
Connection to a dedicated Blue Prism Server is the most secure connection configuration.
See the Blue Prism Server page for details on how to configure and run a server.
Server name
You must supply the hostname of the machine on which your Blue Prism Server is running. The local machine must be able to resolve the supplied hostname.
Connection mode
This allows you to select the connection mode that is used for connections between the client and the Blue Prism server. Note that this setting must match the corresponding value set in the Blue Prism Server configuration.
Port
You must supply the port on which your Blue Prism Server is listening.
Callback port
Specifies a port that the client will listen on for callbacks from the server. This can be left set to 0 to allow an available port to be chosen automatically. Note that if you use this option to force a specific port, only one instance of any Blue Prism application will be able to connect to the server from that machine. This setting is only applicable to Blue Prism Server connection using a .NET Remoting connection mode.
SQL server (SQL authentication)
SQL Authentication uses credentials of an SQL user to access the database.
Contained databases are supported in Blue Prism but must be created manually using the script generated by the /getdbscript option in AutomateC.
Server name
You must supply the hostname of the machine on which your database server is hosted. The local machine must be able to resolve the supplied hostname.
Database name
The name of your Blue Prism database at it appears on the database server. If no such database exists yet then you may choose a database name here. You may then create a database via the Blue Prism user interface as described on the Create database help page.
Database user ID
Supply here the username of the database user that Blue Prism should use when accessing the database.
Database user password
Supply here the password of the user named in the field above. This password will never be revealed by Blue Prism.
Additional SQL connection parameters (non-BP Server only)
Any further semicolon-separated parameters which should be appended to the query string created to access the database. eg.Encrypt=true;TrustServerCertificate=true.
SQL server (Windows authentication)
Windows Authentication uses the currently logged on windows user credentials to access the database. Access must be granted on the database server to allow the Windows user to access the database.
Server name
You must supply the hostname of the machine on which your database server is hosted. The local machine must be able to resolve the supplied hostname.
Database name
The name of your Blue Prism database at it appears on the database server. If no such database exists yet then you may choose a database name here. You may then create a database via the Blue Prism user interface as described on the Create database help page.
Availability group
The two Availability Group options are the same as the corresponding SQL Server options, but connect to a SQL Server Availability group. The Server Name refers to the Availibity Group Listener, and two extra settings are available:
Port
The port the Availability Group Listener is listening on.
Multi-subnet failover
Allows multi-subnet failover to be enabled on the connection. Refer to Microsoft's documentation on this for more information.
Using multiple connections
You may wish to store more than one connection – for example one database for testing and another for live. This dialog allows you to move quickly from one connection to another. New connections are added using the "New Connection" button. The details of the new connection are then filled out on the right hand side.
To edit an existing connection, simply select it from the list on the left and fill out the details on the right. Whichever connection is selected when the "OK" button is pressed will be the active connection used by Blue Prism.
For security purposes, only the password of the current connection is stored, so you will have to retype the password when you switch from one connection to another.
