Chat now with support
Chat with Support

erwin Data Transformation 9.2.6 - User Guide

erwin Data Transformation v9.2.6_User Guide
erwin Data Transformation v9.2.6_User Guide
About this guide Document audience Document conventions 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

Installation Path

Installation Path

The installation path is by default:

C:\Program Files (x86)\erwin\Data Transformation

Contents:

Configuration files:

o<inst_path>\config\erwinDataTransformation.properties

o<inst_path>\config\quartz.properties

o<inst_path>\config\workflows\config\jdbc\CollectorDS.properties

containing the DT database connection string

Binaries

External libraries

CM4Collector.exe

performs import/export CM models operations

Data Path

Data Path

The data path is by default:

C:\ProgramData\erwin\Data Transformation

Subfolders:

data

DT database files

libraries

XSLT parsers used for library/custom transformations

log

Client.log, event.log, server.log, listener.log

workflows

Workflows operation data, workflow testing triggers

The data path can be different from the default; configure the tool providing the desired path:

Setup / Windows Services

Setup / Windows Services

DT installs four Windows Services, which have to be launched by a Windows user belonging to the Administrator group:

erwinDataTransformationH2DB:

Runs the application database

erwinDataTransformationListenerManager

Detects newly created files into DT folders (see later)

erwinDataTransformationEventManager

Manage the event queue, as workflows to be run for adapter files detected by Listener manager

erwinDataTransformationServerManager

Performs scheduled jobs (adapters or sequences execution)

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>

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating