Skip to Content

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.

  1. SAP HANA Express 2.0 running on VMWare PlayerDownload | Instructions
  2. 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)

Part 2: Replicating data into HANA using ABAP – ADBC (Native SQL)

Part 3: Unfair speed test – ABAP CDS on ASE vs HANA CDS on HANA (DUH!)

To report this post you need to login first.

3 Comments

You must be Logged on to comment or reply to a post.

  1. Ashutosh Jha

    Hello Alban,

    Exactly the thing I was looking for. Thanks a lot for posting it on SCN.

    Just had one request for suggestion before i jump start on this .

    As mentioned in your blog you have installed both ABAP and HANA Express locally on your laptop – was wondering about the configuration of your laptop.

    I have a laptop that has 16GB RAM, 500GB SSD and i7 processor. I have already installed HANA Express Server + Application on VMWare and it’s working fine. Now if I go ahead and install ABAP trial version on the same system. I fear about the HANA Server – not sure if all the services on HANA Server will start or not.

    Do you think I should install HANA Express Server only instead of HANA Server + Application and ABAP trial on my laptop. Any suggestions before I go ahead trying the combinations?

    Many Thanks,
    Ashutosh

    (0) 
    1. Alban Leong Post author

      Hi Ashutosh,

      I have tried running both instances in the past on a laptop with only 16GB of RAMs and it didn’t turn out so well. I tried allocating 8GB over to HANA Express VM and 4GB over to ABAP VM and performance was just super slow till the point that everything was timing out.

      Right now, I have upgraded to a laptop with 32GB of RAMs and I allocate 16GB over to HANA Express VM and 8GB over to the ABAP Trial VM with 8GB left for Windows. It is MUCH better!

      So, I would recommend that you only try the above if you have 32GB of RAMs on either a desktop / laptop.

      – Alban

       

       

      (0) 

Leave a Reply