Holistic end-to-end process data automation tool

A system comprising:

• at least one processor;
• and
• at least one memory including program code which when executed causes the system to provide operations comprising:
• identifying process data comprising entity-level data and group-level data in connected database systems, wherein the entity-level data comprises individual tasks, and wherein the group-level data comprises sets of tasks to be executed in a predefined sequence;
• synchronizing the group-level data with the entity-level data by mapping respective content and configurations;
• generating a logical tree structure for the entity-level data and the group-level data;
• dividing, via a topmost sub-hierarchy layer of the logical tree structure, the logical tree structure into a first subtree of nodes representing the entity-level data and a second subtree of nodes representing the group-level data;
• generating an instance from the logical tree structure based on one of the first subtree or the second subtree;
• and
• outputting a consolidated report unifying the entity-level data and the group-level data based on the generated instance.

A non-transitory computer-readable storage medium including program code which when executed by at least one processor causes operations comprising:

• identifying process data comprising entity-level data and group-level data in connected database systems, wherein the entity-level data comprises individual tasks, and wherein the group-level data comprises sets of tasks to be executed in a predefined sequence;
• synchronizing the group-level data with the entity-level data by mapping respective content and configurations;
• generating a logical tree structure for the entity-level data and the group-level data;
• dividing, via a topmost sub-hierarchy layer of the logical tree structure, the logical tree structure into a first subtree of nodes representing the entity-level data and a second subtree of nodes representing the group-level data;
• generating an instance from the logical tree structure based on one of the first subtree or the second subtree;
• and
• outputting a consolidated report unifying the entity-level data and the group-level data based on the generated instance.