Chat now with support
Chat with Support

erwin Data Transformation - User Guide

erwin DT - User Guide
Getting Started Adapters Configuration Configurations Administrator Tools Running DT on Event Running DT from Cloud Platform Log Viewer Utilities Users, Roles and Security Troubleshooting Information Examples of Workflow Configurations

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:


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:


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:


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

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating