You can use the existing TRIRIGA® ETL
job item as an example, when you define a new transform object. Defining
a new own transform object also requires that you define and maintain
the business objects, forms, and workflows.
Create the source and destination tables (business
objects)
and establish the corresponding mappings.
- Create
the transform business object.
- Identify
variables to be passed into the transform and
add them to the transform business object.
For example,
time period.
- Ensure that there is
a binary field for the transform
XML.
- Create the transform
form and provide a navigation item,
or other method, to show the transform form.
- Create
the workflow that calls the ETL transform custom
workflow task.
- Set up the workflow to
run on a schedule.
- Iterate through all
the transform business object records
that must be run, calling the custom workflow task for each one.