erwin Data Transformation 9.2 - User Guide

Adapter Folders

Adapter Folders

When configuring an adapter, DT requires to assign a folder.

This will contain:

•A file, created when saving the adapter, which is used to inherit the information about the structure of datasets coming from the adapter, named:

                    ADAPT_<adapt_id>_struct.<adapt_ext>

For instance, ADAPT_79_struct.csv will be produced when saving a DB adapter with internal id equal 79, containing the resultset columns and a sample of data.

•The following adapter files coming from its execution, that will be named as:

                    ADAPT_<adapt_id>_<operation_timestamp>.<adapt_ext>

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