Defining transform business objects, forms, and workflows

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.

Before you begin

Create the source and destination tables (business objects) and establish the corresponding mappings.

Procedure

  1. Create the transform business object.
    1. Identify variables to be passed into the transform and add them to the transform business object.
      For example, time period.
    2. Ensure that there is a binary field for the transform XML.
  2. Create the transform form and provide a navigation item, or other method, to show the transform form.
  3. Create the workflow that calls the ETL transform custom workflow task.
    1. Set up the workflow to run on a schedule.
    2. Iterate through all the transform business object records that must be run, calling the custom workflow task for each one.