Introduction

Robotic Workforce Manager (RWM) includes an extract, transform, load (ETL) process that loads data from Blue Prism every night. This process can be configured if needed.

This page describes the ETL process and best practices to keep in mind when configuring the ETL process.

Configuration of Daily ETL Process

The RWM Application shows data from the Appian database. However, the data itself comes from the Blue Prism Server. In order to extract key Blue Prism data such as Processes, Resources, Queues, and Work Items in Appian tables, the Blue Prism process - the RWM ETL Scheduler Process is scheduled to run every day.

By default, the process is expected to run at 1 A.M. daily. It should be noted that the time mentioned here is as per the timezone of the Blue Prism Server, which by default uses GMT. Thus, unless specific changes are made, the ETL jobs are expected to run at 1 A.M. GMT.

Configuring Historic Data Load

This process - RWM ETL Scheduler Process is also used to populate the initial or the historic load. The idea behind the historic load is that when the RWM app is deployed, we need to bring in data from the Blue Prism Server. Users can bring up to 12 months of data, but this number can be decided based on their company policy.

To configure the historic load:

• RWM HistoricUpdate Flag should be enabled.
• To give the duration RWM HistoricQuery StartDate and RWM HistoricQuery EndDate should be given.
  • It is advised that customers bring in at least 3 months of data for dashboards to be meaningful.

Configuring the start time for the daily load

Rationale

RWM Application shows the data from the Blue Prism database. To bring the data to Appian, this process is scheduled at 1:00 AM. Since it involves pushing a considerable amount of data to Appian, this process is scheduled to run during off-hours.

The process - RWM ETL Scheduler Process is scheduled to be run at 1:00 AM. If the time when the process should run needs to be changed it can be configured as mentioned below:

1. Go to Control tab > Schedules > RWM ETL Scheduler > RWM ETL Scheduler Process

2. Change the time and apply the changes.

   

Login Agent

The login agent is a Windows service installed on every runtime resource. Its main functionality is to lock when a resource is not in use and unlock it when it should be running a process. Blue Prism has provided an object with the following functionality:

• Login
• Logout
• Is Locked
• Is Locked In

Usually, whenever a process need to be executed, that process would be sandwiched between the login and logout process for Blue Prism.