HANA

Normally BW objects are transported to HANA using a transportation system, but what can be done when transport fails? When you have authorization to repat the import - it is still ok. You can go to Sap Transport Management system (transaction: STMS) and reimport. Thinks get much more complicated when you do not have the necessary rights. Let me share with you my notes about this process. Authorization To manually deploy ABAP objects to SAP Hana databse you need a following authorization: ...

If you want to login into HANA DB on ABAP1909 platform - in the example to create a calculation view, change something please use bellow details: For the tentant database SYSTEMDB (i.e to make some administrative changes): user SYSTEM with the password Ldtf5432 For the single-container database HDB (i.e to make some development): user SAPA4H with the password Ldtf5432 In both cases, the instance number is 02. Example in Eclipse: ...

How to run the HANA SQL function where an output table is required? Example function (from this tutorial): CREATE TYPE "TT_RESTAURANTS" AS TABLE ("node_id" INTEGER, "distance" INTEGER, "hops" BIGINT); CREATE OR REPLACE PROCEDURE "NEAREST_RESTAURANT"(IN startV INT, OUT res "TT_RESTAURANTS") LANGUAGE GRAPH READS SQL DATA AS BEGIN GRAPH g = Graph("SKIING"); VERTEX v_s = Vertex(:g, :startV); MULTISET<Vertex> rests = v IN Vertices(:g) WHERE :v."restaurant" == N'TRUE'; ALTER g ADD TEMPORARY VERTEX ATTRIBUTE (INT "distance" = 0); ALTER g ADD TEMPORARY VERTEX ATTRIBUTE (BIGINT "hops" = 0L); FOREACH rest in :rests { VERTEX v_rest = Vertex(:g, :rest."node_id"); WeightedPath<INT> p = Shortest_Path(:g, :v_s, :v_rest, (Edge conn) => INTEGER { return :conn."length"; } ); rest."hops" = Length(:p); rest."distance" = Weight(:p); } res = SELECT :v."node_id", :v."distance", :v."hops" FOREACH v IN :rests; END; ...

In this blog post, I will show you how you can fast start with developing custom HANA adapters in JAVA. S-User is required to download data provisioning agent: https://launchpad.support.sap.com/#/softwarecenter/template/products/%20_APP=00200682500000001943&_EVENT=DISPHIER&HEADER=Y&FUNCTIONBAR=N&EVENT=TREE&NE=NAVIGATE&ENR=73555000100200005999&V=MAINT&TA=ACTUAL&PAGE=SEARCH/HANA%20DP%20AGENT%202.0 I downloaded the Linux version, but windows should work too (I’m on Mac OS). I will proceed in SAP Hana Studio because Eclipse is missing some packages. If you don’t have SAP Hana Studio, please check: https://launchpad.support.sap.com/#/softwarecenter/template/products/%20_APP=00200682500000001943&_EVENT=DISPHIER&HEADER=Y&FUNCTIONBAR=N&EVENT=TREE&NE=NAVIGATE&ENR=73554900100200000585&V=MAINT&TA=ACTUAL&PAGE=SEARCH/SAP%20HANA%20STUDIO%202 Download missing plugins: https://mvnrepository.com/artifact/javax.xml.bind/jaxb-api/2.3.0 https://mvnrepository.com/artifact/com.sun.xml.bind/jaxb-impl/2.3.3 and put into the plugins folder Unpack dpagent.tar.gz Run Hana Studio and go to the Help -> Install new Software. Then click on Add, Local and choose patch to UI folder from extracted DPAGENT.TGZ Install the plugin. Create a hello world adapter. Change perspective to Plug-in development. Click on File->New->Plugin Project. Check to Generate an activator flag. Right-click on the project, Debug As ->Debug Configurations Unselect Target Platform and click on Add Required Bundles Select org.eclipse.equinox.console and com.sap.hana.dpagent. Next click on Add Required Bundles Click on Apply, then Debug. When this is finished, everything should work perfectly. Now we can use dplogin to deploy plugin into your Hana system. If you are using HANA Express, dpagent can be activated on HXE instance from SYSTEM connection by: ALTER DATABASE HXE ADD 'dpserver' ...