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

Help Menu

Help Menu

This menu provides information and tools:

Request for Help on a given workflow – see Utilities

DT User Guide (PDF)

License

About, DT version, build and type of license

Adapters Configuration

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). Any time a “GET” adapter is created, a job is also created, in order to be scheduled and produce its dataset (triggering all the workflows which use that dataset as source). A “PUT” adapter cannot be scheduled, as its execution is triggered by the execution of workflows using it as target.

DB Adapter Configuration

DB Adapter Configuration

Going through this configuration window, the user can set up an adapter to be used as data source or operation target in a workflow. It’s possible to:

Execute a query on a specified relational database to use the result set as data source in a workflow

Execute a stored procedure with the proper parameters to use the output file as a data source in a workflow

Configure a DB loader to be used as the operation target in a workflow

Execute a query on a MongoDB database to use the result set as data source in a workflow

The first group of fields in the window is the DB Adapter List, which lists all the DB Adapters available.

The second group is the General Parameters, which include the Name, Description, Type and DB Adapter folder; all these fields are mandatory.

The third group is the Connection Parameters, which includes all the parameters needed to connect to the Data Base and finally the last group is the DB Adapter Parameters, which describes the query or the Stored Procedure and its parameters.

Add or Modify DB Adapter

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.

The name, description, type and folder (used to save intermediate and result files for adapter execution) of the DB adapter are the first fields to enter in the form; then for any type of DB Adapter the user must provide connection parameters and adapter details as described below.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating