German ERP-Software Company

Integrate Rexx HR with central Data Warehouse

Challenge

Solution

Result

What was Automated?

Automated Data Peocessing with Rexx Interfaces

Cloudomation was installed on-premise in the data center and retrieves data via multiple JSON interfaces of the Rexx personnel software. Due to interface limitations, the data query is performed in multiple parts. Faulty accesses and incomplete data are reported via email. The data processing includes typing, column separation, and renaming before being loaded into the central database. Another process further processes the data. The result is monitored by Cloudomation. Errors at any stage trigger email notifications.

All the Details About the Automation
  1. A Cloudomation on-premise instance was set up within company’s data center.
  2. Data is requested from several JSON APIs from the Rexx HR software.
    1. Different data categories are accessed via different API endpoints.
    2. Due to limitations of REXX HR APIs, only a specific amount of data can be accessed via one API. Therefore, data sets are split up and accessed in parts from different APIs.
  3. E-mail notifications are sent in case of persistent failure to access any API.
  4. For each of the data categories, all the individual data parts are validated:
    1. Check if the same number of records exists for each part.
    2. Check if data is complete.
  5. E-mail notifications are sent if data checks fail.
  6. Data is prepared for further processing:
    1. String fields contain amounts and currency information as string are split up into numeric fields for amount, and a separate currency column.
    2. Data types are set.
    3. Data sets are merged.
    4. Column names are changed to fit requirements of the DWH.
  7. E-mail  notifications are sent if data pre-processing fails.
  8. Data is loaded into DWH.
  9. Stored procedure for reporting is triggered in the DWH.
  10. Result of stored procedure is monitored. E-mail notifications are sent if the stored procedure returns an error.

How did we Develop the Automation?

A Cloudomation automation expert and a Cloudomation project manager coordinated with internal and external stakeholders to conduct detailed requirements engineering. In close consultation with company’s business stakeholders, Cloudomation project management coordinated with client’s internal functions to gather all necessary information and accesses. The automated process was developed in close collaboration with external developers responsible for the DWH and the reporting process. 

What are the Next Steps?

Meet Your New Platform Engineering Tool

Streamline operations, optimize collaboration, and deliver faster. Let’s discuss how our platform can help you overcome challenges and hit your goals.