Real-time reporting solution combining Geo-spatial and Financial data

In this blog post, I describe the steps I followed to create a real-time reporting solution combining Geo spatial and Financial data. The data is federated from SAP S/4HANA®  Flexible Real Estate Management (RE-FX), SAP Geographical Enablement Framework (SAP Geo Framework) and consumed using Esri ArcGIS (Pro or Insights).

This was an iterative process between the Data provisioning and Data consumption.

Components

◉ SAP S/4HANA Flexible Real Estate Management

◉ SAP Geographical Enablement Framework

◉ Esri ArcGIS Pro and ArcGIS Insights

Geospatial Data Processing in SAP HANA

Introduction:

To create a location enabled model in SAP Analytics Cloud from a live HANA calculation view, Location Data must be prepared through SAP HANA Studio.

The Latitude and Longitude can be converted in to Location Dimension using Spatial data types like Geometry (ST_Geometry) and POINT (ST_Point).

Finding evacuation paths under real wildfire conditions – an application of SAP HANA graph and spatial

Motivation

Global warming is affecting the temperature, precipitation levels, and soil moisture of our forest, turning them into kindling during wildfire season. To exemplify the severity of the problem, the 2018 wildfire season in the State of California USA was the most destructive and deadliest recorded thus far, with over 7500 fires burning an area of over 1,670,000 acres.

Good Things Come Together: DBeaver, SAP HANA Spatial & Beer

German areas with high Biergarten density? Spoiler: The result won’t surprise…

SAP HANA Spatial offers in-database capabilities for handling and processing geospatial data. Furthermore, by leveraging the SAP HANA embedded machine learning capabilities developers are equipped with the ability to infuse spatial analytical models into their applications without the explicit need to actually visualize the geo-referenced input data.

Using SAP HANA as a service (HaaS) with Esri ArcGIS Enterprise 10.7.1 and Pro 2.4

This means ArcGIS Enterprise can use SAP HANA Service as the underlying database to support ArcGIS’s System of Record, System of Insight and System of Engagement.  HaaS is the first-ever database as a service that is fully supported by Esri ArcGIS technology.

Basically, the SAP Cloud Platform, SAP HANA service gives you cloud instances of SAP HANA on-demand, that are managed by SAP.  It’s great if you want to stand up HANA quickly and only want to pay for what you use.

Open Source GIS with SAP HANA

Introduction

SAP’s in-memory database SAP HANA features a geospatial engine, which makes SAP HANA a predestinated storage for geospatial vector data. Once data is residing in SAP HANA developers can leverage the power of HANA’s multi-model engines (e.g. graph and json document store) as well as the advanced analytics capabilities and embedded machine learning (e.g. PAL, APL, EML).

SAP Hana Geospatial – Making things simple

SAP Hana customers often ask about an easy way to use Hana Geospatial capabilities to address their business scenarios related to simple location problems such as determining the “distance between two locations” or if “location X is accessible from location Y in less than 10 minutes by car”, or what is “minimum distance between location Z to location A”…

How to Connect SAP HANA with GeoServer

Meanwhile SAP HANA and its spatial features can be used with a lot of third party GIS (Geographical Information Systems) tools. One crucial question is on how to connect SAP HANA with these tools. This might be quite different from tool to tool and sometimes also be kind of hidden information, especially when the possibility and support for a certain tool is new and recent. In this blog I go into the details how to connect SAP HANA with GeoServer.