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 and HANA DB 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:

An Adaptive Server source database and a Sybase IQ target database
An Oracle source database with both Adaptive Server and Sybase IQ target databases
An Adaptive Server source database and the HANA DB target database