User Interface Elements of the ADB Configuration Shared Resource

The user interface elements in the ADB Configuration shared resource are described below.

The shared resource consists of two pages:

Connection Page

The ADB Configuration shared resource utilizes the JDBC connection shared resource to retrieve the database table schema information. The JDBC connection shared resource is configured on the Connection page.

ADB Configuration shared resource: Connection Page

The Connection page consists of two sections:

  • General
  • Configuration
Shared Resource > Connection Page > General Fields
Field Module Property? Description
Package No The name of the package where the shared resource is added.
Name No The name to be displayed as the label for the shared resource in the process.
Description No A short description for the shared resource.
Shared Resource > Connection Page > Configuration Fields
Field Module Property? Description
JDBC Connection No Define the JDBC connection by selecting the JDBC shared resource. Oracle and Microsoft SQL Server are the supported vendors. Only TIBCO embedded DataDirect JDBC driver is supported by the plug-in.
Default Schema Yes Specify the default schema name.
Note: If no default schema name is specified, it uses the JDBC connection user name.
Set Client Info(Oracle) Yes When the value of this property is set to on, the plugin calls SET_CLIENT_INFO to set the database session client information.

Default: on.

Number Of Threads Yes Select the number of threads in the thread pool provided by the ADB Configuration Shared Resource.

The number of threads should be from 1 to 99.

Note: This property controls the number of concurrent threads used for Data Merger activity and Data Requester activity.

Default: 8

DB2 Type No Select the type of DB2 from the drop down: UDB, AS400, or OS390.

Default: OS390.

Validate Schema No Click this button to validate the JDBC connection and the schemas configured under the shared resource. For the schema, the tables, columns and column types are validated. If a referred table is provided, the existence of the table is also validated. An error message is displayed if the validation fails.

After all the issues are resolved, after clicking Validate Schema, you receive a "Validation of Schema is successful" message.

Schemas Page

The type of service and the associated tables to generate XSD schema and database triggers are defined on the Schemas page.

ADB Configuration shared resource: Schemas Page

The Schemas section on the left lists the schema type. You can add or remove schemas. You can add the following schema types:

  • DBPoller
  • DBMerger
  • DBRequester
When a new DBPoller, DBMerger, or DBRequester schema is added, a corresponding section is displayed on the right and consists of different tabs corresponding to the activity. The following sections describe the fields on these tabs for each activity: