ETL integration architecture

TRIRIGA® uses two ETL environments to create the ETL scripts that populate the fact tables. The two ETL development environments are the Tivoli® Directory Integrator Configuration Editor and the Pentaho Data Integration tool Spoon. The ETL development environments enable 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 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: