Heterogeneous Comparison

Replication Server Data Assurance Option 15.7.1 SP100 compares row data between two or more databases in a heterogeneous comparison environment.

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

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 multiple target databases, for example, both Adaptive Server and Sybase IQ.
An Adaptive Server source database and an HANA target database

DA accurately compares equivalent values stored in distinct datatypes. For example, the value 1 stored in a Sybase IQ NUMERIC column is equivalent to the value 1 stored in an Oracle NUMBER column, and to 1.0 stored in an ASE FLOAT column.

To use heterogeneous comparison:

Configure DA to use the JDBC drivers for Oracle and HANA DB instances, if your heterogeneous comparison includes these databases.
Create connections for each new database.
Set the hash_type comparison option to agent_hash.

See create connection and Heterogeneous Comparison Deployment in the Replication Server Data Assurance Option Users Guide.