Data Merger: MSSQLServerDataMergerParent Process

The MSSQLServerDataMergerParent project contains one process: mssqldatamergerparent.ParentData process. This process demonstrates how the plug-in inserts data in the parent table.

ParentData Process

The following figure shows the ParentData process:

JDBC Connection Resource

In this example, the JDBC Connection resource is configured as follows:

ADB Configuration Resource

In this example, the ADB Configuration resource is configured as follows:

The table schema is defined by using the Schema tab. The different tabs on the right are shown below.

The Configuration tab:

The Schema tab:

The Options tab:

The Child Exception Table Mappings tab: