This menu provides information and tools:
Request for Help on a given workflow – see Utilities
DT User Guide (PDF)
About, DT version, build and type of license
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
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
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.