To minimize the effort for building up a suitable data cube, Interactive PMCube Explorer provides a wizard for data integration. Despite some configuration, it automatically performs the following integration steps:
- Generate the meta-data file from the selected source file
- Generate a database schema for the data cube from the selected meta-data file
- Import the data from data source into a temporary staging area table of the database
- Transform the data of the staging area table into the structure of the data cube
The data integration wizard provides different workflows, each of them covering a different scenario for the integration. On the Welcome page, you must choose the scenario that is appropriate to your needs.
- Create a new data cube from a data source file (Full Integration): In this scenario, the wizard will guide you through the full integration process. Assuming that you have an event log file (e.g., XES), it will create the cube structure in the database from scratch and populate it with the data of your data source.
- Update an existing cube by inserting data from a source file (Update): This scenario assumes that there is already an existing data cube (either filled with data or empty). The wizard will extend the content of cube with the new data from the data source. Please be aware, that the wizard works append-only, i.e. it does not remove "outdated" data.
- Create an empty cube from an existing meta-data file (Empty Cube): In this sceanrio, the wizard creates the empty data cube structure in the database from an existing meta-data file. This file could be either automatically created by one of the scenarios above or manually with the meta-data editor.