This is the first part of a 3-part blog – covering my experience of connecting a SAP ABAP 751 Developer Edition server to HANA Express and then, replicating data over to HANA through ABAP and finally, running a quick performance test between the two system using ABAP CDS vs HANA CDS.
Thomas Jung has shared a similar post back in 2012 – discussing on the topic of connecting a HANA database as a secondary DB in ABAP and also shared the following image below – and this is the inspiration to the start of a personal initiative to set up something similar locally.
This blog post will simply be a documentation of how I was able to connect a HANA Express 2.0 system to a AS ABAP 751 SP02 Developer Edition following the steps that Thomas has shared and use this set up as a practice system between ABAP and HANA.
To start, I have the following systems installed locally on my laptop and both are running concurrently and I have updated the hosts file for all three system (Windows Laptop, HANA Express server and ABAP server) with the ip address of each systems.
- SAP HANA Express 2.0 running on VMWare Player – Download | Instructions
- SAP NW AS ABAP 751 SP02 Innovation Pkg Developer Edition on openSUSE running on VMWare Player – Download | Instructions
As stated in Thomas’s blog, I will need to download the SAP HANA Client from SAP Software Center and install it onto the ABAP server.
*Search for HANA CLIENT in the Software Center and then make sure to select the right OS version and download the latest version – see example screenshot below.
After downloading the HANA Client, extract the SAR file and then connect the folder that contains the extracted SAR files to VMWare Player.
Once connected, below are the steps to install the HANA Client on the ABAP server.
Make note of the installation path of the HANA Client – /usr/sap/hdbclient
Next step is to set a reference to the HANA Client in LD_LIBRARY_PATH in the file .dbenv.csh. in /home/npladm.
Add a new line as highlighted below.
Restart the SAP server incl. DB if you have it running while making these changes.
Configuration in SAP – Transaction DBCO
Head into SAP and run transaction DBCO to maintain a new entry to the HANA Express DB as secondary DB. (You can also perform this step directly in DBACOCKPIT as well. Look under Database Connections -> Add)
Username: SYSTEM (HANA DB)
Password: <master password>
Conn. info: hxehost:3<instance number>13
Once saved, this connection will show up in DBACOCKPIT and I can then execute a connection test.
And that’s it!
I now have successfully connected the AS ABAP 751 Developer Edition with the HANA Express server as a secondary DB.
In part 2, I’ll share a program that I wrote (taking inspirations and tips from Graham Robinson in a blog that he shared back in 2013 called Loading data into HANA using RFC) that will help me replicate data from any SAP tables into this HANA Express instance.
Part 1: Connecting AS ABAP 751 Developer Edition with HANA Express 2.0 as Secondary DB (This blog)