SAP HANA Express and ABAP Developer Edition: new BFFs :-)
You may remember the possibility to attach a HANA Database (for example the HANA Express Edition) in a more or less legal way to the ABAP Developer Edition by simply copying one or more database drivers from the HANA Linux system to the ABAP Linux system (just google it, if you want furher information).
Last week I was preparing a small workshop for my collegues (“What is SAP HANA”) where I wanted to demonstrate, among other things, this “sidecar” architecture model. Because the last time a set up this kind of scenario is a couple of yeras ago, I couldn’t remember anymore which driver file I had to copy to the ABAP system. But what I could remember was, that a dump would appear with the needed/missing filename in it when I’m trying to call the HANA database from within an ABAP programm.
Because my laptop is not _that_ powerfull to run a HANA Database _and_ an ABAP system, I’ve created a HANA instance on AWS (see https://developers.sap.com/tutorials/hxe-xsa-aws-setup.html ) and only my ABAP System stays on my laptop.
Creating dumps or at least error messages is one of my simpler exercises, so I’ve created the database connection with ST04 and tried to create the dump with this little program:
TRY. DATA(sql) = NEW cl_sql_statement( con_ref = cl_sql_connection=>get_connection( 'MYHANA' ) ). DATA airportcodes TYPE STANDARD TABLE OF char03. DATA(statement) = |SELECT "airportCode" FROM "TRAVEL"."Airports";|. DATA(result) = sql->execute_query( statement ). result->set_param_table( REF #( airportcodes ) ). result->next_package( ). cl_demo_output=>display( airportcodes ). CATCH cx_sql_exception INTO DATA(lcx). cl_demo_output=>display( lcx->get_text( ) ). CATCH cx_parameter_invalid INTO DATA(lcx_parameter). " cl_demo_output=>display( lcx_parameter->get_text( ) ). ENDTRY.
But quelle surprise: no dump nor an error message but instead values from my HANA Express database!!!!!
What happend? Should it be that the new ABAP Developer Edition 7.52 can connect to the SAP HANA Express Edition 2.0 SP03 without further tweeking? I’ve tried with calling stored procedures, views, bigger selects -> everything worked fine 🙂
Here’s my ST04 setup, if you want to try the same on your own:
Call transaction ST04, logon and press “add”
Enter a system name and a proper description
Enter a database connection name (this will be the name you’ll use later in your ABAP program), select “SAP HANA database” as platform, enter SYSTEM as DB user, the password, IP address of your AWS instance (this may change every time you start the instance!) and port 39015.
After you entered all your data, you can press “test connection”. If you’re as lucky like me, a success message should appear
continue, continue, finish (or so) and the overview should look like this
Happy sidecar programming….
Nice sidecaring, Uwe! I'm super curious now, what are you planning to do with it?
currently I'm searching for use cases. I'm working for a municipal energy supplier (IS-U), there must be use cases ("big data", machine learning, Graph database) ?
Next step will be to connect one of our real SAP systems to our HANA instance.
Thank you Uwe for this great description. The great thing is that this also works with the HANA MDC that is provided in the SAP Cloud Platform Trial. You just get SAP Cloud Connector and create a On-Premise to Cloud connection:
Hi Greg - the HANA MDC in SCP trial comes only with HANA 1.0 SP01 version right ?
Correct for the Neo Environment. In the Cloud Foundry Trial you also have access to HANA 2.0 HDI Containers.
Thanks Greg. I didn't notice the Cloud Foundry trial. Let me explore that a bit. Having said that, perhaps it is a good opportunity to explore Uwe's Graph model via CF trial 🙂
Hello Gregor Wolf - I was looking for setting up the HDI containers for HANA 2.0 and came across the below blog. Is it the same one that you were referring to in terms of "how to setup 2.0 HDI containers in Cloud Foundry trial" ?
Yes, but check out also the linked tutorial and try also the way using the CAPM.
Thanks Greg. I was able to add the HDI Container using CF Trial through WebIDE full stack (Database Explorer). Next step is to try out Uwe's Graph modelling 🙂 Thanks to both of you your help and guidance.