Data Gateways environment setup

Install Data Gateway engine components

Data Gateways requires a number of components to be installed in the environment in which all application servers running a Data Gateways process will be used. If an application server hosts multiple environments, the components must be installed in each environment that will be running the Logstash service.

Version 1.1 of the Data Gateways engine must be installed for use with Blue Prism version 6.6. The components are included in a separate installer, Blue Prism Data Gateways Components, available from the Blue Prism portal, see https://portal.blueprism.com/product/extras.

Enable the Data Gateways process

The Data Gateways process must be enabled and the associated port defined on all application servers that are required to run Data Gateways. The Data Gateways process can only run on one instance on a single device. Where multiple application servers are configured on a single device, the Data Gateways process must be enabled on each one.

Before enabling the Data Gateways process, ensure that all prerequisites have been met.

1. Access the Server Configuration Details screen and enter the port that the application server will listen on for commands to start or stop the Data Gateways process.

   This can be left as the default port (8101) unless there is another process on the application server that is already using that port.

   The application server must be stopped before changing the port number.

   

2. Click Save to apply the settings.
3. Start the Blue Prism Server Service from the Services menu.

To confirm that the service has started successfully, check the event viewer.

Create a Data Gateways SQL login and user

Run the following SQL query against the server instance on which your Blue Prism databases are located. This query creates a login and user that allows Data Gateways to access the server.

Only users with ALTER ANY LOGIN permission on the server or membership to the securityadmin fixed server role can create logins.

Before running the query, select the required Blue Prism database and replace password with a complex password for the Data Gateways login.

CREATE LOGIN [Data Gateways BP Database SQL User] WITH PASSWORD = 'password';

CREATE USER [Data Gateways BP Database SQL User] FOR LOGIN [Data Gateways BP Database SQL User];

GO

sp_addrolemember 'BPA_DataGatewaysEngine', 'Data Gateways BP Database SQL User'

GO