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 IBM® Real Estate Environmental Sustainability products.