Andersson HDB 1.0 Manual do Utilizador descarregar pdf (Página 41)

5.3 Support for HANA DB

Replication Server Data Assurance Option 15.7.1 SP100 supports comparisons where the source or target

database is HANA DB.

Supported version:

● SAP HANA 1.0

Note

DA does not ship the JDBC driver JAR file for the HANA DB. Download the JDBC type4 driver JAR file from

the SAP® Web site for your HANA DB version, and configure DA to use the JDBC driver.

See create connection and Configuring DA to Use the HANA DB JDBC Driver in the Replication Server Data

Assurance Option Users Guide.

5.4 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.

New Features Guide

New Features in Replication Server Data Assurance Option 15.7.1 SP100

P U B L I C

1 2 ... 36 37 38 39 40 41 42 43 44

Sem comentários

Andersson HDB 1.0 Manual do Utilizador Página 41