Monday 30 October 2017

Connecting AS ABAP 751 Developer Edition with HANA Express 2.0 as Secondary DB

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.

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.

SAP ABAP HANA 2.0, SAP ABAP Tutorials and Materials, SAP ABAP Certifications

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.

1. SAP HANA Express 2.0 running on VMWare Player – Download | Instructions
2. SAP NW AS ABAP 751 SP02 Innovation Pkg Developer Edition on openSUSE running on VMWare Player – Download | Instructions 

SAP ABAP HANA 2.0, SAP ABAP Tutorials and Materials, SAP ABAP Certifications

SAP ABAP HANA 2.0, SAP ABAP Tutorials and Materials, SAP ABAP Certifications

SAP ABAP HANA 2.0, SAP ABAP Tutorials and Materials, SAP ABAP Certifications

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

SAP ABAP HANA 2.0, SAP ABAP Tutorials and Materials, SAP ABAP Certifications

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.

SAP ABAP HANA 2.0, SAP ABAP Tutorials and Materials, SAP ABAP Certifications

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.

SAP ABAP HANA 2.0, SAP ABAP Tutorials and Materials, SAP ABAP Certifications

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.

Username: SYSTEM (HANA DB)
Password: <master password>
Conn. info: hxehost:3<instance number>13

SAP ABAP HANA 2.0, SAP ABAP Tutorials and Materials, SAP ABAP Certifications

Once saved, this connection will show up in DBACOCKPIT and I can then execute a connection test.

SAP ABAP HANA 2.0, SAP ABAP Tutorials and Materials, SAP ABAP Certifications

And that’s it!

I now have successfully connected the AS ABAP 751 Developer Edition with the HANA Express server as a secondary DB.

No comments:

Post a Comment