erwin Data Transformation 9.2.3 - User Guide

Connection Parameters

Connection Parameters

In the Connection Parameters pane the user has to provide all the parameters needed to set up the connection with the database. In order to check if a connection can run correctly, press the  button.

Then, depending on what has been selected in the drop-down list named Type (Stored Procedure, DB Query, DB Loader and NoSQL DB Query) the DB Adapter Parameters section shows the following.

Stored Procedure

Stored Procedure

When the field “Type” is set to “Stored Procedure”, then two other fields are highlighted:

•The field “Stored Procedure name” that has to be filled with the stored procedure name

•The field “Parameters” that has to be filled with the list of all the parameters separated by commas and optionally enclosed by quote (e.g. the same way the stored procedure could be called from outside DT, like a DB Client).

To be used as data source adapter in DT, stored procedures must produce a CSV file containing a data set; this means that at least two parameters are required (folder as the first paramater and file name as second), so that DT knows and accesses the resulting dataset.

For example, if an external database contains a stored procedure named “servicesToFile”, which accepts two parameters “folder” and “filename”, then the parameters text area must be filled with the folder path enclosed by quotes.

DB Query

DB Query

When the field “Type” is set to “DB Query”, then the “Query” field is highlighted. In this field, the user has to write the query to be run by the Database.

In order to check if the previous DB query is written correctly, press the  button. This opens a new window that contains the result set obtained from running the adapter.

The result set is paginated in groups of 50 records. Use the side window arrows to go up and down the list.

DB Loader

DB Loader

When the field “Type” is set to “DB Loader”, then the entire DB Adapter Parameters section is disabled. 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.  The adapter will be saved and added to the DB Adapter List at the top of the window. Only if the Test Connection (and query execution, for that type) have valid results, the DB Adapter will be saved.

To cancel the adapter data just entered and to reset the window, press the  button.

To delete an existing adapter, just select it and press the  button. It will be permanently removed from the DB Adapter List.

The  button closes the window.