Advanced Enterprise RPA Process Template

A Database Configurable RPA Process Flow Template

The Advanced Enterprise RPA Process Template enables enterprises to configure settings for their RPA Processes in local or remote databases such as MS Access, SQL Server, MySQL, PostgreSQL or AWS RDS.

Configuring the framework in databases enables enterprises to better organize, secure and port their RPA processes across the enterprise.

This framework is built upon an already existing UiPath component named Enhanced REFrameWork. Consequently, this advanced enhancement retains the capability of the original to organize configurations in a local Excel file.

Note: The ConfigDB database has been published in a separate folder as a .mdb file. This change enables the database to be enhanced with features that do not directly impact the functionalities of the framework.

The key advancement in this template is its ability to consume configuration settings from a local database (such as Microsoft Access) or a remote, full-featured enterprise SQL database such as Microsoft SQL Server, MySQL, AWS RDS, or PostgreSQL. In its current form an Excel file is used to configure settings of a RPA Process built using the current framework. While this is great for small scaled operations, managing individual Excel files becomes logistically difficult especially when there are several tens, if not hundreds of integrations involved. Besides, Excel files are documents and are prone to getting loosely dispersed across an enterprise via emails, messengers and shared drives. This may result in an outdated or wrongly configured file deployed to a production environment by accident. Consolidating configurations into a database makes managing a large number of RPA Processes much easier on an enterprise scale.