erwin Data Transformation 9.2.6 - User Guide

Model Configuration Folder

Model Configuration Folder

When setting up a model configuration, DT requires assignment of a folder for the backup. This will be used also as adapter folder for the automatically created CM import-export adapter.

This will contain:

•The backup of the model, when required by scheduling:

                    <model scriptname>_<operation_timestamp>.mdb

•The structure file for export adapter, containing the metamodel: ADAPT_<adapt_id>.xml

•The CM export adapter files, when requested:

                         ADAPT_<adapt_id >_<operation_timestamp>.xml

•Operation folders for the given model (see later)

Workflow Folder

Workflow Folder

When configuring a workflow, DT will automatically create a subfolder in the <datafolder>/workflows, assigned for the specific workflow, named:

workflow_<wf_id>

This will contain:

•the source adapter normalized file

•the multisource folder when using more than a source

•Support file containing trigger and parameter information

•the xslt dynamically created to perform requested transformation

•the intermediate and final result of the transformation chain

Operation Folder

Operation Folder

When configuring a workflow operation, this will be in charge of an adapter (CM Import, DB Loader, Folder).

The workflow manager, at the end of the transformation chain, prepares the files which allow it to perform the requested operation, and puts them into a subfolder of the adapter folder.

In particular, for:

•Load/Synch/Delete CM Repository

The subfolder will be created into target model folder

•Send to DB Loader

The subfolder will be created into adapter folder

•Send to File Adapter

The subfolder will be created in the target folder

Examples of Workflow Configurations

Examples of Workflow Configurations