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.

SAP has released the next generation of its Data Management Platform SAP HANA 2. SAP HANA2 will have Multi-Tenant Database Containers or MDC as the default installation. They have the choice to operate as a single database as well.

HANA Replication works on the System Level, so complete SID will be getting copied. 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 supports scale-up configurations.

As such, HANA 2.0 focuses on delivering continuous innovation through:

  • Increased automation and better business continuity with enhancements in workload management, system replication, dynamic tiering, and active/active read-enabled.

  • Usability enhancements to improve ease of use, by simplifying data movement modeling, tenant management, encryption, and user group management.

  • Enhanced SAP HANA analytics with Google Tensor Flow integration for Machine Learning, and added improvements in Text analysis, Graph, and Spatial.

  • Expanded application development flexibility with new GO language driver, expanded SQL/SQL Script, and SAP HANA express edition support for Smart Data Integration.

Logical Architecture for Delphix with HANA

  • The linking model leverages HANA backup and recovery implementation

  • 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 the file system based backups and logs from the customer and ingests those to replicate the data.

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

Backup / Recovery

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

Related Links