Ramani SAP-HANA

With a Ramani example application for SAP-HANA, we demonstrate how you can ingest Copernicus data and other EO-data examples into your SAP-HANA database. The plugin embedded in the example App handles access to the RAMANI map server (referred to as ‘Digital Data Library’ or DDL), it returns tiled-map displays from the DDL to get an appreciation for the data on offer, and provides functionality to import selections of map data from the DDL into your SAP-HANA Database. You can then use any SAP-HANA functions or SQL-statements to query and analyze the new data.

Supported Platforms

This plugin is intended for SAP-HANA and assumes you use the Web-IDE.

System Requirements

  • SAP HANA Database (with the required permissions)
  • Ramani Cloud Username
  • Ramani Cloud API Key

SAP HANA Accesslinks

  • To manage your HCP account/ manage databases, enter https://account.hana.ondemand.com/cockpit with your assigned/ registered P User.
  • To manage your particular SAP HANA XS instance, enter https://{YOUR SAP-HANA BASE}/sap/hana/xs/admin/ with your assigned SYSTEM user.
  • To manager your particular SAP HANA instance, enter https://{YOUR SAP-HANA BASE}/sap/hana/ide/ or https://{YOUR SAP-HANA BASE}/sap/hana/admin/cockpit with your assigned SYSTEM user

E.g. To alter or create an HANA Database Users:
Enter through:
https://{YOUR SAP-HANA BASE}/sap/hana/ide/security/
E.g. grant a new role to a DB User:
Search for *Developer, add sap.hana.ide.roles::Developer (or e.g. SecurityDeveloper for respective IDE)

Obtaining the Plugin

This plugin is distributed as a zip file. Download it form this address.

Adding the Plugin into your project

  1. Login into your SAP HANA Web-IDE
  2. Open your Project Tree
  3. Right Click on the Content, and choose New -> Package
  4. Give name "sap.hana.spatial.RAMANI" to the new package, (the other fields can be left bank).
  5. Open right menu from the new package and select Import -> Archive

    The plugin is distributed as a zip file and can be downloaded at the following address: https://ramani.ujuizi.com/RAMANI_SAP-HANA.zip
  6. After importing, select "Refresh" and add a new query access file. In folder "xsjs" create the file "query.xssqlcc" with the content:
    
              {"description": "Query SQL Connection"}
  7. Select "Activate all" from the same context-sensitive menu.
  8. After importing the package go to the XS Admin Tool (https://{YOUR SAP-HANA BASE}/sap/hana/xs/admin/) and set the SAP-Hana password to DB User credentials. To do this, select package sap -> hana -> spatial -> RAMANI
  9. Create New Database Schema, go to https://{YOUR SAP-HANA BASE}/sap/hana/ide/catalog/
  10. Next, create tables in your SAP HANA database using the following structure:
    1. Table ESA_DATA 
      
CREATE COLUMN TABLE {dbschema}."ESA_DATA" ("ID" BIGINT, "SHAPE" ST_POINT(1000004326), "D_VALUE" DOUBLE NOT NULL  ) UNLOAD PRIORITY 5 AUTO MERGE
    2. Table ESA_METADATA 
      
CREATE COLUMN TABLE {dbschema}."ESA_METADATA" ( "ID" BIGINT, "T_STAMP" LONGDATE, "DATASET" NVARCHAR(255), "LAYER" NVARCHAR(255), "VARIABLE" NVARCHAR(255), "UNIT" NVARCHAR(255), "INSERTED" LONGDATE, PRIMARY KEY("ID"), UNIQUE ("DATASET", "LAYER")  ) UNLOAD PRIORITY 5 AUTO MERGE
    3. Table USECASE_SEQ 
      
CREATE SEQUENCE {dbschema}.USECASE_SEQ RESET BY SELECT IFNULL(MAX(ID),1) FROM {dbschema}.ESA_METADATA
  11. Assign schema to your user with SAP-HANA Security
    https://{YOUR SAP-HANA BASE}/sap/hana/ide/security/
  12. Run the demo Application by visiting this address:
    https://{YOUR SAP-HANA BASE}/sap/hana/spatial/RAMANI/index.html
    or open the index.html file from sap.hana.spatial.RAMANI and click on Run (F8) button (located at the top-part of the IDE).
  13. On first launch, you will be presented with the following configuration requirements:

    Here you must provide the RC-API Key which you can get from the RAMANI client-area under the "API Keys"-tab (register here if you have not done so already).

Using the Plugin for your own project

The example application was built to demo the plugin’s functionality, and so you may wish to adapt it to another context, i.e. to access other maps and tailor it to fit the needs of your users.

To add new maps:

  1. Login into your Ramani Cloud-dashboard page, and click on "Editor"
  2. Open the Edit-Tab, and from the available maps under "Public Layers" find a relevant map for the use-case your App is targeting. To learn more about adding new maps to your personal Maps library see the following Tutorials
  3. Either from those listed under group "Public" or from any of your own maps library, add the one of your interest to "Favorites" (click icon next to the Map-name)
  4. Explore the new Map-favorite under layer group “Favorites” and make sure the map renders as expected.
  5. Switch to your browser tab and reload the SAP demo application’s web-page. Under the button “Map list” you should now see a new Favorites-group, with your favorite map listed there.