Introduction:
This topic will explain the advantages of SAP Business Application Accelerator which Allows leveraging HANA for current programs without changing them or without disruption or without changing the code. SAP Business Application Accelerator allows redirection of database queries (like select, open cursor) to a secondary database connection. In this case we are going to use HANA as secondary DB.
This blog doesn’t explains you the HANA Specific Application Accelerators like CO-PA or Moving data intensive operations down to HANA, rather a simple use case to see the advantages of using SAP Business Application Accelerator and HANA Database on the current existing programs without changing the code by calculating the runtime of the program.
How it works:
Runtime intensive table selects can be redirected to the HANA database instead being selected from the primary database.
Use Cases:
System prerequisite:
Kernel version 7.21 and the SAP Business Application Accelerator Add On.
Demo - Overview:
Demo - Step-by-Step:
2. SLT: SLT is a process to replicate the data from primary to secondary database. In this case we will identify time intensive – tables / program combinations to be redirected to HANA and not to the primary database for read access.
3. In this demo program: ZR_COEP is used which uses the ZCEOP table. This table will be replicated in HANA DB using SLT.
4. Maintaining the Configuration by preparing the XML with scenario, program and table names after identifying the program and table.
5. Configuration is maintained by using RDA_MAINTAIN program. First XML will be upload using the ‘Upload Scenario’. Once the XML is uploaded, a database connection has to be maintained (second screen shot) and last we will Activate the Scenario. Configuration entries are maintained in RDA_CONTROL, RDA_CONFIG and RDA_CONTEXT table. You can validate your configuration entries here.
6. Profile Parameters rsdb/rda is used to redirect the DBs using RZ11 transaction Code. It acts like a switch between two databases. Please see the prerequisite to avail the profile parameters. Please make sure the scenario which we have uploaded in previous step has to in active status, only then the redirection of DBs works.
7. Analyzing the Runtime by testing the runtime of the program in both DBs by setting profile parameter values as on/off.
Test program is written with a select statement using aggregate functions.
It takes an average of 25 seconds to pick the data from primary database.
Now turn on the profile parameter and execute. Total number of records in HANA DB is more than Primary DB (an additional record was added).
It only took 4 seconds to run the program.
Limitations:
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
35 | |
25 | |
14 | |
7 | |
7 | |
6 | |
6 | |
5 | |
4 | |
4 |