erwin Data Transformation 9.2.4 - User Guide

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.