SAP HANA (high-performance analytic appliance) is an application that uses in-memory database technology that allows the processing of massive amounts of real-time data in a short time. The in-memory computing engine allows HANA to process data stored in RAM as opposed to reading it from a disk.

HANA uses row stores and column stores and is considered a "hybrid" database for online transaction processing (OLTP) and online analytical processing (OLAP) workloads. HANA supports both scale-up and scale-out configurations. Delphix currently only supports scale-up configurations.

Logical Architecture for Delphix with HANA

  • The linking model leverages HANA replication
  • Each HANA database requires a Staging Server
  • The Delphix engine leverages an existing HANA instance that will be used as a staging instance that receives changes from the source asynchronously.
  • The Delphix Engine exports an NFS share where HANA database files will be stored for the staging database.
  • Delphix performs actions on HANA systems using the built in HANA command line tools. JDBC is not used.

Replication of Data 

Replication of data from the source HANA site to a mirrored HANA replica is carried out by native HANA System Replication. The replication is 1:1 and needs configuration on both the HANA source as well as the HANA replica hosts.

Related Topics