After you upload the transform
XML into the TRIRIGA® Content
Manager, you can and set up the workflow to run on a schedule. The
workflow iterates through all the transform business object records
and calls the custom workflow task for each record.
Procedure
- The workflow
gets records for the transform business object.
- The
workflow determines the records to be sent to the custom
workflow task.
- The workflow iterates through
calling custom workflow task
for each record. The class name must be com.tririga.platform.workflow.runtime.taskhandler.ETL.RunETL.
- The custom workflow task:
-
Loads the transform XML from the Content Manager into
a temporary file.
- Gathers all the fields
on the business object and creates
a variable to hand to the ETL tool. Special handling is needed for
date/date and time formats.
- Creates the
ETL environment.
- Sets the TRIRIGA connection
to the local application server JNDI.
- Runs
the transform by using the ETL API.
- Returns
false if an error occurs during processing,
otherwise return true to the workflow.