If you want to simulate business processes in Software AG Designer using historical data, create the Staging and Reporting database components. Services you run will extract the historical data from the ProcessAudit database component and aggregate and load the data using the Staging and Reporting database components.

You can create the Reporting and Staging database components in the same schema (Oracle) or database (DB2 or SQL Server). However, the services that aggregate and load the historical data consume large amounts of the CPU. For best performance, install the Reporting and Staging database components on a database server that will not adversely affect the ProcessAudit or ProcessEngine database components.

The ProcessAudit, Staging, and Reporting database components have a 1-to-1-to-1 relationship. This means that you cannot gather data from multiple ProcessAudit database components into a single Reporting database component. Simulation can be performed from only one Reporting database component at a time.