Problem Statement
One of our clients was using the legacy desktop-based accounting system. They wanted to connect their system with one of the newly developed web platforms which have advanced dashboards.
Since the legacy system was quite old and did not have any APIs for integration as well as there was no documentation for database structure, therefore pulling or pushing data from it to a new web platform was not feasible with conventional integration methods. The only option was manual data export and import which was not effective and error-prone.
Our Solution
Since Robotic Process Automation (RPA) tools can automate any manual process, therefore we developed RPA BOTs to automate manual tasks of importing/exporting data between the legacy system and web platform. We have used the UIPath RPA tool to achieve this. With these RPA BOTs, we were able to integrate the legacy system with the web platform. Our developed BOTs were mimicking the entire manual process of data import as well as data export.
Some of the major activities done by our BOTs:
Opening legacy applications and adding accounting data in the legacy application forms
Downloading the reports in excel format from the defined start and end dates from the Legacy system and then importing them to the Web platform
Outcome
40% Reduction in manual task
Hassle free transformation from old to new system
