DBMerger Schema

When you create a new DBMerger schema, a corresponding section is created on the Schemas page.

Tabs on the Schemas Page

The Schemas page consists of the following tabs:

The Configuration tab contains the following fields:

Shared Resource > Schemas Page > Configuration Tab
Field Module Property? Description
Name No You can update the schema name.

See Entity Naming Conventions.

Description No A short description for the schema.

The Schema tab contains the following UI options:

Shared Resource > Schemas Page > Schema Tab
Icon/Option Description
Add a parent table from the connected Database (through JDBC connection).
Add a child table to a parent table.
Refresh the existing schema or change the columns used.
Allow Key Columns Only If this check box is selected, the Join To relation between the parent and child table is applied only on the columns having a User Key. If the check box is not selected, the Join To relation can be applied on any fields.
Tables and Columns Displays the selected table and its columns.
Join To Set a relation between the parent table and child table.

For setting a relation between the parent table and child table, you must either clear the Allow Key Columns Only or at least one column must be enabled as User Key from the parent.

User Key Select the check box beside the column name to specify that the column must contain a unique set of values. If the user key is defined in a child table and the parent table has a primary key, it has no impact on the generated triggers and the user key is used for mapping the parent-child relationship.

If the parent table does not have a primary key (rare cases), no update or delete triggers are generated. To use a user key as the implicit primary key in the trigger, you must modify and apply the trigger manually.

Update Trigger Fires a trigger when an UPDATE statement changes a value in a column.
Only the following databases are supported in the Update Trigger option:
  • Oracle
  • SQL Server
  • DB2 UDB/AS400/OS390
Note: Update trigger is applicable only for a parent table.
XSD Type Displays the XSD type of the column. This is a read-only column.
DB Type Displays the data type of the database column. This is a read-only column.

The Options tab contains the following fields for the Data Merger activity:

Shared Resource > Schemas Page > Options Tab for Data Merger activity
Field Module Property? Description
Exception Table Name No Name of the exception table to which data is written if the plugin cannot write the data to the data merger destination table. This table holds messages that caused an exception. If the table does not exist, data merger creates one by itself. For more information about exception table, see Exception Table.

The exception table cannot contain any user-created columns where the column name starts with ADB_. These characters are reserved for use by the plugin.

Note: For the parent-child relationship, this is the parent exception table. If you do not set the parent exception table, the child exception table is invalid.
Opaque Exception Table Name No Specifies the name for the opaque exception table. For more information about opaque exception table, see Opaque Exception Table.

You can use the Child Exception Table Mappings tab to create a child exception table.

The Child Exception Table Mappings tab contains the following fields:

Shared Resource > Schemas Page > Child Exception Table Mappings Tab
Icon/Option Description
DBMerger Child Table Name Displays the list of child table names.
Child Exception Table Name Displays the list of child exception table names corresponding to each child table in the DBMerger Child Table Name column.

When you use the DB2 connection, the DB2 tab is available on the Schemas page. The DB2 tab contains the following fields for the Data Merger activity:

Shared Resource > Schemas Page > DB2 Tab for Data Merger activity
Icon/Option Description
OS390 Options
Database Name Name of the database that you want to put your publishing table in.
Table Space Name Name of the table space where the publishing table is located.
LOB Table Space Name The name of the Large Objects (LOB) table space name where auxiliary table of the opaque exception table is located.