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.