The types of databases supported for data linkage by Datareplicator include structured-type databases (structured-type databases, hierarchical-type databases, and network-type databases) and relational-type databases. In this manual, structured-type databases are referred to as structured databases and relational-type databases are referred to as relational databases.

The following table shows the types of databases and the relationship between the source and target databases.

Table 1-4 Types of databases supported for data linkage and the relationship between the source and target databases

Source system		Target system
Type	Source database	Type	Target database
Relational	HiRDB XDM/RD E2 TMS-4V/SP# RDB1 E2	Relational	HiRDB
Structured	XDM/SD E2		XDM/RD E2
Hierarchical	ADM
Network	PDM2 E2

#

Although TMS-4V/SP uses hierarchical-type data, it is classified as a relational database because TMS-4V/SP/Data Linkage Support outputs data with a relational structure.

Figure 1-8 shows the concept of data linkage between relational databases, and Figure 1-9 shows the concept of data linkage from a structured database to a relational database.

Figure 1-8 Concept of data linkage between relational databases

#1

The source database is a HiRDB. If the source database is XDM/RD E2, XDM/DS is required instead of a source Datareplicator.

#2

The target database is a HiRDB. If the target database is XDM/RD E2, XDM/DS is required instead of a target Datareplicator.

#3

The import definition can be omitted when a table in the source database is imported into an identical table in the target database (one that has the same table format, table name, column names, and so on).

Figure 1-9 Concept of data linkage from a structured database to a relational database

#

If the import definition is omitted, the target database's authorization-identifier.table-identifier corresponds to the source database's schema.record-type.