Tchater maintenant avec le support
Tchattez avec un ingénieur du support

erwin Data Transformation - Recherche dans la base de connaissances

Filter Your Results

Catégorie

Version du produit

Rubrique

Filter Search Results

Recherche dans la base de connaissances par mot clé

(Choisissez un produit différent)



DateRelevanceViews Affichage de 1-25 sur 226
Migrating erwin DT (aka Collector) configurations between machines (4288669)

Migrating erwin DT (aka Collector) configurations between machines <p>ISSUE:</p> ... <p>When moving Collector to a new machine, previous configurations can be migrated for the old environment. This article provides a guide for performing the migration.</p>

Produit(s): erwin Data Transformation
Dernière mise à jour le: 07/05/2023
NA rating | 499 vues
Knowledge Article
What is Casewise Collector? (4288644)

Casewise Collector integrates with these systems and automatically feeds their data into the ... Modeler repository. ... By automating complex data aggregation, Collector uncovers strategic opportunities for improvement: Bringing together data from disparate systems identifies many business issues, heralds potential savings and adds real business value.

Produit(s): erwin Data Transformation
Dernière mise à jour le: 07/05/2023
NA rating | 415 vues
Knowledge Article
JAVA Log4J Vulnerability Alert Mitigation For DT (4332219)

On Friday 10 December 2021 a new critical vulnerability was reported in the Apache Log4J library. ... Further information on this please click: https://support.quest.com/essentials/log4j-vulnerability-update

Produit(s): erwin Data Transformation
Dernière mise à jour le: 07/05/2023
NA rating | 958 vues
Knowledge Article
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)

Dernière mise à jour le: 19/02/2025
Produit(s): erwin Data Transformation
Technical Documentation
User Guide > 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.

Dernière mise à jour le: 19/02/2025
Produit(s): erwin Data Transformation
Technical Documentation
User Guide > Delete in CM Repository

When selecting this operation, the only mandatory mapping is the NAME of the object type that the user wants to manage: as a result of this operation, data coming from the source adapter will be physically deleted in the specified model accord to the defined mapping rules, for the ones that are not diagrammed (while diagrammed ones will be listed in the operation log file).

Dernière mise à jour le: 19/02/2025
Produit(s): erwin Data Transformation
Technical Documentation
User Guide > Web Service POST

As a result of this choice, data coming from the source adapter will be transformed as defined in “Transformation” step and sent to the Web Service, as defined in its configuration.

Dernière mise à jour le: 19/02/2025
Produit(s): erwin Data Transformation
Technical Documentation
User Guide > DB Loader

All the mapping parameters between source and target data structure, needed to upload a table in the externals database, will be provided in the workflow operation configuration (see later). ... For every type, to save the new DB Adapter just created, press the button.

Dernière mise à jour le: 19/02/2025
Produit(s): erwin Data Transformation
Technical Documentation
Installation Guide > Database

The database tab allows the users to choose between a local H2 database or a remote H2 database to be used by erwin DT. ... If installing with a local database, you’ll be allowed to choose between two options:

Dernière mise à jour le: 19/02/2025
Produit(s): erwin Data Transformation
Technical Documentation
User Guide > Running a DB Adapter on Event with Parameters

When configuring and using a trigger file for executing a DB adapter on event, it is possible to add parameters to drive the query resultset through them. ... Let’s suppose that you want to configure a DB Query Adapter, which is named “MY ADAPTER” and extract detail of just the Applications that have been updated / inserted in a table named “MY_TABLE”.

Dernière mise à jour le: 19/02/2025
Produit(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.

Dernière mise à jour le: 19/02/2025
Produit(s): erwin Data Transformation
Technical Documentation
Release Notes > Major Release – v9.3.0.0

This release replaces the older erwin, online Licensing system, with the Quest licensing by file system. ... Making the product operate more similarly to erwin Evolve Suite. ... It will be necessary to request a new license from support, to upgrade to this new version.

Dernière mise à jour le: 19/02/2025
Produit(s): erwin Data Transformation
Technical Documentation
User Guide > Log Viewer

The log window lists all the most important actions performed by DT. ... For each row, you can see the name of the configuration (column name CONFIGURATION – available only if linked to the action), the date (column name DATE – timestamp of the action), the user (column name USER – the user who owns the action), the operation (column name OPERATION – what has been done) and a short description of the action (column name DESCRIPTION).

Dernière mise à jour le: 19/02/2025
Produit(s): erwin Data Transformation
Technical Documentation
User Guide > WS Adapter

Select XSL Parser for source normalization from the list. ... This parser can be chosen in a list containing all “non CC compliant” custom transformations previously defined in “XSLT Library”; in particular, any XSLT parser developed to manage outside XML data has to provide a CSV structure, with “semicolon” as separator, to be effective in this step.

Dernière mise à jour le: 19/02/2025
Produit(s): erwin Data Transformation
Technical Documentation
User Guide > Veracode – IMPORT APPLICATION DATA

To use the adapter for Veracode, to import application data, fill the field “Web Service Home URL” with the Veracode URL you want to connect to. ... Then, provide a valid username/password to connect, or the API credentials (ID/KEY), that can be generated by a valid account.

Dernière mise à jour le: 19/02/2025
Produit(s): erwin Data Transformation
Technical Documentation
Release Notes > Major Release – v9.0

In case you missed it, erwin Collector has been renamed! ... From this version 8 onwards Collector will be known as erwin DT (Data Transformation). ... As the product is decoupled from its Casewise roots, and repositioned into erwin's EDGE platform, we feel this name better reflects the products ETL capability.

Dernière mise à jour le: 19/02/2025
Produit(s): erwin Data Transformation
Technical Documentation
User Guide > Document audience

The User Guide is intended to be read by end users who are concerned with getting the most benefit from the erwin Data Transformation implementation.

Dernière mise à jour le: 19/02/2025
Produit(s): erwin Data Transformation
Technical Documentation
User Guide > 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.

Dernière mise à jour le: 19/02/2025
Produit(s): erwin Data Transformation
Technical Documentation
User Guide > Running DT on Event

<P class=ps16><SPAN class=ts18>Running DT on Event</SPAN></P>

Dernière mise à jour le: 19/02/2025
Produit(s): erwin Data Transformation
Technical Documentation
User Guide > Zendesk – Get Tickets

To use the adapter for Zendesk to get tickets, select the authorization method (Account / Access Token) and enter the relevant credentials. ... Click the button to proceed to the next step, and select the operation “Get Tickets”.

Dernière mise à jour le: 19/02/2025
Produit(s): erwin Data Transformation
Technical Documentation
Installation Guide > JDK Version

Select the JDK version to run erwin DT; 64bit JDK is required.

Dernière mise à jour le: 19/02/2025
Produit(s): erwin Data Transformation
Technical Documentation
User Guide > Users, Roles and Security

DT interacts with CM contents – models, objects and so on – through the same logic and application components that Corporate Modeler and Evolve rely on. ... Normal authentication is the only fully supported option.

Dernière mise à jour le: 19/02/2025
Produit(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.

Dernière mise à jour le: 19/02/2025
Produit(s): erwin Data Transformation
Technical Documentation
User Guide > Adapters Configuration

Adapters are tools used by DT to “GET” data from the external world (databases, web services, folders and files) or to “PUT”, or send data to the destination. ... “GET” adapters can be used as a data source when configuring a workflow; “PUT” adapters can be used as a workflow operation target (see later).

Dernière mise à jour le: 19/02/2025
Produit(s): erwin Data Transformation
Technical Documentation
User Guide > SmartSheet

To use the adapter for SmartSheet, fill the field “Web Service Home URL” with the SmartSheet home page URL you want to connect to. ... Then, provide a valid access token to connect. ... To generate an access token, requested to authenticate the SmartSheet service, follow instructions from https://smartsheet-platform.github.io/api-docs/?shell

Dernière mise à jour le: 19/02/2025
Produit(s): erwin Data Transformation
Technical Documentation
Rechercher tous les produits
Contenu recommandé
Aucun résultat pour undefined
Outils libre-service
Base de connaissances
Notifications et alertes
Support produits
Téléchargements de logiciels
Documentation technique
Forums utilisateurs
Didacticiels vidéo
Flux RSS
Nous contacter
Support Technique
Afficher tout