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

POST to EA Agile V3

POST to EA Agile V3

In the “Workspace Name” the name of target workspace will be shown (“Default”).

User may proceed with the mapping operation in the mapping table, having the requested parameters described in the following list:

Column Name: shows the columns coming from the data source and from the transformation steps; a sequence number that the system assigns to each data source can be seen as prefix to the column name, so the user can easily recognize the source of the data, in the case of multiple data sources.

Column type and format: choose the type and format of the column of the source (String, numeric, boolean, date). This is important if user wants DT to perform a re-format operation on the target column data type.

Date in UTC format

Date / Datetime

The following ISO-8601 formats are supported:

YYYY-MM-DD (e.g. 2019-01.28)

YYYY-MM-DDThh:mm (e.g. 2019-01-28T01:02)

YYYY-MM-DDThh:mm:ss (e.g. 2019-01-28T01:02:03)

YYYY-MM-DDThh:mm:ssTZD (e.g. 2019-01-28T01:02:03+04:05)

When positing to EA Agile, if a time and offset are not provided, these will default to 00:00Z (i.e. 00:00+00)

Date Ranges

For the supported UTC date formats outlined above, DT supports the following separators:

$UTCDATE/$UTCDATE

$UTCDATE,$UTCDATE

$UTCDATE;$UTCDATE

start:$UTCDATE end:$UTCDATE

start: $UTCDATE end: $UTCDATE

Date in EUR format

Date / Datetime

The following formats are supported:

dd/MM/yyyy (e.g. 28/01/2019)

dd/MM/yyyy HH24:mm (e.g. 28/01/2019 13:01)

dd/MM/yyyy HH24:mm:ss (e.g. 28/01/2019 13:01:02)

dd/MM/yyyy HH:mm AM/PM (e.g. 28/01/2019 01:01 PM)

dd/MM/yyyy HH:mm:ss AM/PM (e.g. 28/01/2019 01:01:02 PM)

dd/MM/yyyy HH:mmAM/PM (e.g. 28/01/2019 01:01PM)

dd/MM/yyyy HH:mm:ssAM/PM (e.g. 28/01/2019 01:01:02PM)

Date Ranges

For the supported EUR date formats outlined above, DT supports the following date range formats:

start:$EURDATE end:$EURDATE

start: $EURDATE end: $EURDATE

$EURDATE;$EURDATE

$EURDATE,$EURDATE

 

Date in USA format

Date / Datetime

The following formats are supported:

MM/dd/yyyy (e.g. 01/28/2019)

MM/dd/yyyy HH24:mm (e.g. 01/28/2019 13:01)

MM/dd/yyyy HH24:mm:ss mm (e.g. 01/28/2019 13:01:02)

Date Ranges

Dates ranges may be formatted as:

start:$USADATE end:$USADATE

start: $USADATE end: $USADATE

$USADATE;$USADATE

$USADATE,$USADATE

Object type: choose the model object type to load the data; it’s possible to select different object types in the same operation

Mapping (prop./assoc.): once you have selected the object type you can map the property or the association between the ones defined in EA Agile V3 for that object type.

Please be sure that the “Name” property of an object type is always mapped, to allow DT to identify the object instance to work with (except for Association Types imports, see later).

 About associations mappings, multiple values can be associated putting the different values in a single cell, newline separator.  Other separators can be replaced with “Data Formatting: Replace Text”:

If an association is of “composition” type, like “Entity is part of Data Model”, the action “set as parent” must be selected from drop down list in order to properly identify objects parent in the platform.

Type: shows the type of the mapped column of the target (String, numeric, boolean, date). To help the user in mapping, in case of list or key values allowed values are shown in the “type” cell tooltip:

 

No New: when importing data from an external source, it’s possible that the master list of objects involved in the operation is the one contained in EA Agile V3 workspace. In such a case, the user would want existing object to be updated (for the only properties used in mapping), but no objects to be created. If so, user may choose to check “No New” option, on the keyset of the master object type, and this will prevent new objects to be created, while existing will be updated within bounds of mapped properties. The same applies when the object list which has not to be extended is the one related to an object type associated with the master, involved in the operation. In such a case, user may choose to check “No New” option, on the record related to the association, and this will prevent new associated objects to be created.

Delete in EA Agile V3

Delete in EA Agile V3

When selecting this operation, user should map only the “Name” of the object type that he wants to manage: as a result of this operation, data coming from the source adapter will be deleted in the specified workspace according to the defined mapping rules.

Send to File Adapter

Send to File Adapter

Choose the File Adapter in the “Choose Adapter” drop-down list (only the “PUT” File Adapter will be available in the list)

Optionally, define a customized name for the ouput file, without the extension (it will be .xml, if no final custom transformation is applied; it will be .csv, if Custom transformation (CC uncompliant):CC2CSV transformation is applied, or .xls, for Custom transformation (CC uncompliant):CC2EXCEL, or .html, for Custom transformation (CC uncompliant):CC2HTML, etc). Moreover, the user can choose between overwriting file if existing, or have a different file for different executions (in this case, the name will be post fixed with a timestamp)

As a result of this choice, data coming from the source adapter will be transformed as defined in “Transformation” step and sent to the File Adapter folder. When completed it will be delivered to the destination.

Send to DB Loader

Send to DB Loader

Select the Table to be uploaded with data, coming from the source and transformations of the workflow, among the ones owned by the user specified at DB Loader Adapter configuration time.

Select the Key column among the ones describing the Table, to be used to allow DT to properly perform an “INSERT” or “UPDATE” SQL command at runtime, for any given field value occurrence in input data.

Then, for each input column name the user may alternatively:

                    1. Map onto a specified column of the previously chosen table, when the input value is natively hosted by that

                    2. Map onto a specified column of the previously chosen table, when this contains the foreign key of another table in the same database, actually containing the input values, providing:

oThe name (“FK table”)

oThe column hosting the input values (“FK match column”)

oThe column hosting the foreign keys for given table (“FK key column”)

The option “No New (only updates)” allows user to set import operation to be limited to updates on selected table

As a result of this choice, data coming from the source adapter will be transformed as defined in “Transformation” step and sent to the DB Loader Adapter for the upload operation previously defined.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating