Heterogeneous Comparison

A heterogeneous comparison environment means two or more of the databases in use are of different vendors.

To use heterogeneous comparison:

Configure DA to use the JDBC drivers for Oracle, Microsoft SQL Server, IBM DB2 UDB, and SAP HANA database instances, if your heterogeneous comparison include these databases.
Create connections for each database supported.
Set the hash_type comparison option to agent_hash.

You can compare data between any source and target database combinations. For example:

A homogeneous comparison IBM DB2 UDB to IBM DB2 UDB
An SAP Adaptive Server source database and an IBM DB2 UDB target database in a heterogeneous comparison
An Oracle source database with multiple target databases, for example, both SAP Adaptive Server and SAP IQ
An SAP Adaptive Server source database and an SAP HANA target database