There are seven data linkage patterns for Datareplicator. You select the appropriate pattern for your data linkage needs; you can also combine multiple patterns.

The following table lists and describes the data linkage patterns.

Table 4-2 Data linkage patterns

Data linkage pattern	Description
Data linkage to a table with the same format	Imports a source table into an identical target table.
	Imports a source table by changing only the table name and/or column names.
Data linkage to a table with a different format	Sorts a source table's columns at the source, and then extracts and imports them.
	Sorts a source table's columns at the target, and then imports them.
	Selects some of the source table's columns at the source, and then extracts and imports them.
	Selects some of the source table's columns at the target, and then imports them.
	Adds fixed-value columns to a source table at the target, and then imports the table.
Data linkage from one table to n tables	Divides a source table into multiple tables and extracts them at the source, and then imports them into a single target.
	Divides a source table into multiple tables and extracts them at the source, and then imports them into multiple targets.
	Divides a source table into multiple tables at the target, and then imports them.
Data linkage from n tables to one table	Combines multiple source tables at the target, and then imports them into a single table.
Data linkage for import of selected rows	Selects rows to be transmitted, and then imports them.
Data linkage using a UOC routine	Uses a UOC routine to edit update information at the target, and then imports it.
Acquisition of a record of update information over time	Acquires information such as the import dates and times as well as the update information in chronological order.

This section explains the source system's extraction definition for each data linkage pattern. The explanations provided here are based on the Datareplicator definitions in the source system.

If the source database is a mainframe database (XDM/SD E2, XDM/RD E2, ADM, PDM2 E2, or TMS-4V/SP), you must use XDM/DS to specify the extraction definition. For details about how to use XDM/DS for the extraction definition, see the VOS3 XDM/DS manual. If the source database is a mainframe database that uses SAM files (PDM2 E2 or RDB1 E2), some definition specifications might not be required, depending on the product; for details, see the applicable product's manual.

Organization of this section

4.2.1 Data linkage to a table with the same format

4.2.2 Data linkage to a table with a different format

4.2.3 Data linkage from one table to n tables

4.2.4 Data linkage from n tables to one table

4.2.5 Data linkage by selecting rows to be sent

4.2.6 Data linkage using a UOC routine

4.2.7 Acquisition of a record of update information over time