Prerequisite setup for ETL integration

Within TRIRIGA Application Platform, a business object and a form manage the transforms. The source tables and destination fact table must be defined and the mappings understood to create the transformation.

There is a record for each fact table loaded through a transform. A binary field on the Transform business object pulls the transform XML file into the Content Manager. The form provides a way to upload/download the XML file so the transform XML can be easily maintained. TRIRIGA® comes preconfigured with an ETL Job Item as the implementation of this business object or form.

Within the TRIRIGA Application Platform, a workflow runs on a schedule and calls a Custom workflow task for each fact table that needs to be loaded or updated. The Job Scheduler provides a mechanism that automatically calls the custom workflow task for ETL Job Items.

TRIRIGA ships all business objects, forms, and workflows required to support the as-delivered TRIRIGA Workplace Performance Management and TRIRIGA Real Estate Environmental Sustainability products.