SAP HANA Data Source

You can compare data between an SAP HANA database and another database (SAP HANA or non-SAP HANA), directly in an SAP HANA database. Remote access to the second database is provided by SAP HANA smart data access, which accesses remote data as if it were local tables in SAP HANA, without copying the data into SAP HANA. To minimize the amount of data transferred, only key fields and row hashes of multiple fields are compared, not single values.

Note Note

To use this data source type, choose the extraction strategy Execute comparison in one system (also see Comparison).

End of the note.

Features

The following graphic provides an overview of cross-database comparison in an SAP HANA database.

This graphic is explained in the accompanying text.

Cross-Database Comparison in One SAP HANA Database

The following information is required to extract the data from the SAP HANA database:

Database Connection: Connection to read the data for the comparison.
Database Schema: Database schema from which the data is read.

More Information

For more information on SAP HANA, see http://help.sap.com/in_memory.