Chat now with support
Chat with Support

NOTICE! We are upgrading our support telephone services, implementing Genesys, starting the week of May 19, 2025

erwin Data Transformation - Knowledge Base

Filter Your Results

Category

Product Version

Topic

Filter Search Results

Search Knowledge Base by keyword

(Choose different product)



DateRelevanceViews Displaying 51-75 of 226
User Guide > Reset Logs/Files

When needed, it is possible to reset the logs table just by pressing the “Tools” menu item “Reset Logs/Files”. ... This action will clean the database of all the application logs, thus preventing the DB from being overloaded by historical tracking data.

Last Updated On: 2/19/2025
Product(s): erwin Data Transformation
Technical Documentation
User Guide > DB Metadata

If the “Connection Parameters” are valid, clicking the button will result in options being displayed for filtering the results by catalog name, schema, table name, and/or table type, as appropriate to the database type and requested metadata type.

Last Updated On: 2/19/2025
Product(s): erwin Data Transformation
Technical Documentation
User Guide > Add or Modify DB Adapter

To create a new DB Adapter just press the button and start editing the new adapter parameters. ... Alternatively modify an existing adapter, simply selecting from the list – the parameters are always in edit mode.

Last Updated On: 2/19/2025
Product(s): erwin Data Transformation
Technical Documentation
Installation Guide > Changing or Removing File Encryption

To change the encryption, select the current and new key stores, and provide the necessary credentials.

Last Updated On: 2/19/2025
Product(s): erwin Data Transformation
Technical Documentation
User Guide > File Menu

File Menu This menu is used to close the application.

Last Updated On: 2/19/2025
Product(s): erwin Data Transformation
Technical Documentation
User Guide > Tool Overview

DT is aimed at configuring multiple, dynamic data flows, and managing those flows without relying on programming resources, with an easy to use interface to organize them in logically consistent job sequences, to be run on schedule/on demand:

Last Updated On: 2/10/2025
Product(s): erwin Data Transformation
Technical Documentation
User Guide > Generic data provider - CSV

To use the adapter for a generic http data provider, fill the field “Web Service Home URL” with the URL to the data provider service, ex: ... The button steps into the next window that shows the available operation of that Web Service, which is “GET DATA”, allowing user to query web data.

Last Updated On: 2/10/2025
Product(s): erwin Data Transformation
Technical Documentation
Installation Guide > General

The general tab allows the user to select the language, JDK version, account for service creation, and the location of the data folder.

Last Updated On: 2/10/2025
Product(s): erwin Data Transformation
Technical Documentation
User Guide > Data Filtering

The “Fixed Value Manager” Transformation applies if it is required to filter the workflow data by some fixed value specified for a given column. ... The user can insert the format of the column, the filter operator between “Equal”, “Not Equal”, “Greater than”, “Less than”, “Like” or “Not Like”, “Equal sysdate”, “Later than (days ago)”, “Later than (hours ago)”, “Later than (minutes ago)”, “Earlier than (days ago)”, “Earlier than (hours ago)” , “Earlier than (minutes ago)”, “In (semicolon separated)”, “Not in (semicolon separated)” and the value to use as filter.

Last Updated On: 2/10/2025
Product(s): erwin Data Transformation
Technical Documentation
User Guide > POST to EA Agile

In the “Workspace Name” the name of target workspace will be shown. ... User may proceed with the mapping operation in the mapping table, having the requested parameters described in the following list:

Last Updated On: 2/10/2025
Product(s): erwin Data Transformation
Technical Documentation
Release Notes > Major Release – v9.1

New adapters added to support: ... The CMLoader is now able to migrate diagrams between models, under the following conditions: ... 1.Workflow operation involves the object type DIAGRAM ... 3.Source and Target models share the same design, at least for diagrammed objects

Last Updated On: 2/10/2025
Product(s): erwin Data Transformation
Technical Documentation
User Guide > Running an Adapter on Event

In a real life environment, it could be important to acquire external data on a scheduled basis, or in an “on event” mode; in particular, when a DB Adapter is used for reading the information from a database.

Last Updated On: 2/10/2025
Product(s): erwin Data Transformation
Technical Documentation
Release Notes > Service Release – v9.2.5

This release includes updates to supporting libraries for the UI, Services wrappers, Open Office Support, the version of included Java runtimes, and several other security updates. ... Java Spring has been removed, as it is no longer a dependency.

Last Updated On: 2/10/2025
Product(s): erwin Data Transformation
Technical Documentation
User Guide > Administrator Tools

<P class=ps15><SPAN class=ts17>Administrator Tools</SPAN></P>

Last Updated On: 2/10/2025
Product(s): erwin Data Transformation
Technical Documentation
User Guide > Home page

The home page allows the user to select the operation by clicking on the buttons or selecting from the menu at the top of the window. ... Operations are logically divided into 2 groups: ... Setting adapters:

Last Updated On: 2/10/2025
Product(s): erwin Data Transformation
Technical Documentation
Installation Guide > Licensing

During first erwin DT log on, users will be prompted to enter an activation code. ... The activation code will be released by ServiceDesk. ... For further details on licensing, consult the erwin DT User Manual.

Last Updated On: 2/10/2025
Product(s): erwin Data Transformation
Technical Documentation
User Guide > Synch in CM Repository

When selecting this operation, it is mandatory that user choose a keyset that’s unique in the source dataset to avoid undesired results. ... In particular: ... Objects coming from the source dataset will be inserted/updated in the specified model accord to the defined mapping rules

Last Updated On: 2/10/2025
Product(s): erwin Data Transformation
Technical Documentation
User Guide > DB Query

In this field, the user has to write the query to be run by the Database. ... In order to check if the previous DB query is written correctly, press the button. ... This opens a new window that contains the result set obtained from running the adapter.

Last Updated On: 2/10/2025
Product(s): erwin Data Transformation
Technical Documentation
User Guide > Installation Path

The installation path is by default: ... C:\Program Files (x86)\erwin\Data Transformation ... Contents:

Last Updated On: 2/10/2025
Product(s): erwin Data Transformation
Technical Documentation
Installation Guide > Pre-Installation

If you wish to use an H2 DB on a remote server please refer to APPENDIX A - Installing H2 DB on a remote server before installing erwin DT. ... Please ensure antivirus applications are disabled during the installation.

Last Updated On: 2/10/2025
Product(s): erwin Data Transformation
Technical Documentation
Release Notes > What's New in erwin Data Transformation

erwin DT 9.2.6 is the latest release of the erwin DT.

Last Updated On: 2/10/2025
Product(s): erwin Data Transformation
Technical Documentation
Installation Guide > Software Requirements

Microsoft Windows Server 2019 ... Microsoft Windows Server 2022 ... The following system components must be installed on the erwin DT server before starting the installation wizard procedure: ... Microsoft .Net Framework 4.5.1

Last Updated On: 2/10/2025
Product(s): erwin Data Transformation
Technical Documentation
User Guide > Align Federated Models

This example describes the following use case: an enterprise organized its EA information in two federated models, one specifically aimed to support IT and the second for more general business analysis purposes.

Last Updated On: 2/10/2025
Product(s): erwin Data Transformation
Technical Documentation
User Guide > APIMAN – Read APIs and contracts information

To use the adapter for APIMAN, fill the field “Web Service Home URL” with the APIMAN home page URL you want to connect to. ... Then provide valid user/password credentials to connect: ... The button steps into the next window that shows the available operations of that Web Service; choose “EXPORT DATA”, to query data stored in APIMAN.

Last Updated On: 2/10/2025
Product(s): erwin Data Transformation
Technical Documentation
User Guide > Transformation Library Configuration

In the Transformation Library there are some pre-built parsers (based onto XSLT) to apply transformations to the data managed through the workflow (see after): ... Data Derivation (like Sum values in rows/columns, counting values in rows/columns, Match keys and pick values)

Last Updated On: 2/10/2025
Product(s): erwin Data Transformation
Technical Documentation
Search All Products
Recommended Content
Updating results
Self Service Tools
Knowledge Base
Notifications & Alerts
Product Support
Software Downloads
Technical Documentation
User Forums
Video Tutorials
RSS Feed
Contact Us
Technical Support
View All