Converse agora com nosso suporte
Chat com o suporte

erwin Data Transformation - Pesquisa na Base de conhecimento

Filter Your Results

Category

Versão do produto

Tópico

Filter Search Results

Pesquisar a Base de conhecimento por palavra-chave

(Escolha um produto diferente)



DateRelevanceViews Exibindo 1-25 de 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>

Produtos: erwin Data Transformation
Última atualização em: 07/05/2023
NA rating | 499 visualizações
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.

Produtos: erwin Data Transformation
Última atualização em: 07/05/2023
NA rating | 415 visualizações
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

Produtos: erwin Data Transformation
Última atualização em: 07/05/2023
NA rating | 958 visualizações
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)

Última atualização em: 19/02/2025
Produtos: 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.

Última atualização em: 19/02/2025
Produtos: 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).

Última atualização em: 19/02/2025
Produtos: 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.

Última atualização em: 19/02/2025
Produtos: 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.

Última atualização em: 19/02/2025
Produtos: 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:

Última atualização em: 19/02/2025
Produtos: 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”.

Última atualização em: 19/02/2025
Produtos: 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.

Última atualização em: 19/02/2025
Produtos: 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.

Última atualização em: 19/02/2025
Produtos: 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).

Última atualização em: 19/02/2025
Produtos: 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.

Última atualização em: 19/02/2025
Produtos: 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.

Última atualização em: 19/02/2025
Produtos: 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.

Última atualização em: 19/02/2025
Produtos: 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.

Última atualização em: 19/02/2025
Produtos: 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.

Última atualização em: 19/02/2025
Produtos: erwin Data Transformation
Technical Documentation
User Guide > Running DT on Event

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

Última atualização em: 19/02/2025
Produtos: 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”.

Última atualização em: 19/02/2025
Produtos: erwin Data Transformation
Technical Documentation
Installation Guide > JDK Version

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

Última atualização em: 19/02/2025
Produtos: 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.

Última atualização em: 19/02/2025
Produtos: 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.

Última atualização em: 19/02/2025
Produtos: 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).

Última atualização em: 19/02/2025
Produtos: 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

Última atualização em: 19/02/2025
Produtos: erwin Data Transformation
Technical Documentation
Pesquisar todos os produtos
Conteúdo recomendado
Nenhum resultado para undefined
Ferramentas de autoatendimento
Base de conhecimento
Notificações e alertas
Suporte a produtos
Downloads de software
Documentação técnica
Fóruns de usuário
Tutorial em vídeo
Feed RSS
Fale conosco
Suporte técnico
Visualizar tudo