ETL integration architecture

TRIRIGA® uses an ETL environment to create the ETL scripts that populate the fact tables. The ETL development environment is the Pentaho Data Integration tool, Spoon. The ETL development environment enables the creation of SQL queries that read data from the TRIRIGA business object tables and map and transform the results to the fact table fact and dimension columns.

The following diagram shows the flow of data between the source data, ETL development environment, and the TRIRIGA Workplace Performance Management data model layers:

ETL Process of IBM TRIRIGA Workplace Performance Management

ETL job items are the business objects that reference the ETL scripts that are used to populate the fact tables.

TRIRIGA Workplace Performance Management uses standard TRIRIGA Application Platform tools.

The following diagram shows the application platform tools:

Architecture Uses IBM TRIRIGA Application Platform Tools