SAP HANA as Secondary Database
Small Introduction to SAP HANA – As and when time passes, everyday transactions are increasing, maintaining volume of data became too much load in applications and systems, Finally conventional RDBMS becoming obsolete! Here, Big data concepts knocked the door, eventually SAP started adopting IMDB (In-memory Data base) techniques and introduced HANA (High-Performance ANalytic Appliance) for all these kind of problems.
Initially, HANA developed and targeted for OLAP systems. Now, Accessing HANA schema and Information models (Attribute, Analytic and Calculation views) to OLTP (i.e. SAP ECC/ERP) system has became viable and cost-efficient option. We are going to deal this now (HANA as Secondary Database).
AS ABAP is running on a traditional RDBMS can access SAP HANA by means of a secondary database connection.
With SAP business suite on HANA, HANA is used as the Primary database for transactional (OLTP) systems by facilitating a integration of ABAP developments with HANA and leverage the strengths of SAP HANA within the application logic.
In order to leverage the performance advantage of the SAP HANA database for existing ERP customers without changing existing ERP applications!
Typically, following situations/scenarios need to be considered SAP HANA as secondary database.
- Improving the few important reports performance
- Access the aggregated (Where HANA is stronger with the help of Calculation engine) data from HANA Information Models
- Real time data analysis in OLTP system (HANA as a Side-car approach)
- Creation of Custom Accelerators
- SLT (SAP Landscape Transformations) Replication between primary and secondary Database
- Create a logical connection name, DB user, password and connection using DBACOCKPIT in ECC system
- Replicate appropriate tables to HANA DB
Below are the two approaches would like to adopt as per the situation.
- Native SQL ADBC Approach
- Business Application Accelerator (RDA Approach)
Native SQL ADBC Approach: ADBC stands for ABAP Data Base Connection. It is a Class-based API (Application Program Interface) for the Native SQL Interface that allows object orientated and dynamic access to the Native SQL interface. ADBC API Framework makes an object orientated and dynamic access possible.
Business Application Accelerator (RDA Approach): RDA stands for Redirected Database Access. The SAP Business Application Accelerator powered by HANA provides a possibility to run applications in a way that data from performance critical tables is read from a SAP HANA database (Secondary) containing replicated data.
We will continue and elaborate the steps and process involved in these two approaches..