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:
.svg)
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>