Technical Articles
Esri ArcGIS Pro & SAP HANA – Upload, Visualize and Process Spatial Data
Hexagonal clustering of AirBnB listings in Berlin visualized in Esri ArcGIS Pro
As you may know, Esri ArcGIS Pro integrates with SAP HANA Spatial. In this short video I will demonstrate how to use ArcGIS Pro to
- connect to SAP HANA,
- upload listings of AirBnb in Berlin to SAP HANA
- and push down hexagonal binning using a Query Layer.
More details on how to setup the ODBC connection can be found in Tom Turchioe‘s blog:
Using SAP HANA as a service (HaaS) with Esri ArcGIS Enterprise 10.7.1 and Pro 2.4
To learn more about why Esri and SAP are better together, I recommend reviewing the following resources:
- Esri+SAP – Better Together on GeoNet
- The Four Advantages of ArcGIS on HANA by Tom Turchioe
- Reap all the Benefits of SAP HANA as an Esri Geodatabase and Now Deploy Anywhere by Matthew Zenus
- ArcGIS + HANA: GIS acceleration and increased agility for ArcGIS content creators and users by Tom Turchioe
Can you please tell me how to bring this map into SAP GEF without arcgis Server/Enterprise(because the database already in SAP Environment).
Hi Gobinath,
I am not very familiar with GEF. However, what you see in the video above is in fact an Esri map. So I would anticipate that you need ArcGIS Server/Enterprise.
Regards,
Mathias
Hi Mathias,
Thanks for the blog!
Are you familiar at all with integrating ArcGIS with SAP Plant Maintenance?
Regards,
Tyrone.
Hi Tyrone,
please excuse my late answer. I am not familiar, but Tom Turchioe, who is also referenced in the blog above, may be able to add insights.
Regards,
Mathias
Tyrone,
The enabling link is a foreign key relationship between the GIS and ERP data. Our customers establish this in a few ways - manually via a spreadsheet and periodic refresh of the GIS data, a bespoke process or via an async process that makes sure PM objects exist for each geometry (i.e. once a transformer goes into service, a corresponding equipment record is created in PM). These are referred to as sync frameworks. We have an engineered service called Sync4GEF. Our partners Rizing and Cybertech have sync frameworks (Mercury and Unity Engine respectively). Another, GeoNexus, is in the process of being certified to work with our GeoEnablement Framework (GEF). Our GEF framework is integrated into PM and our customer can obtain that version from us. GEF puts maps into PM and makes PM spatially aware. This makes it possible to define work orders and notifications spatially. Maintenance plans can be based on a geometry (i.e. inspect this group of power poles). ArcGIS is still the system of record for asset geometries and GEF can reference ArcGIS feature services.
However the SAP object key is maintained in the relevant feature class(es) as an attribute within the FC, once that's there, HANA has the capability to dynamically query the SAP ERP system. This is a big benefit of having the geodatabase (either as an SOR or a system of engagement) on HANA (or HANA Cloud). You can surface PM master data in ArcGIS either through a view (SQL or calc) or a query layer. One advantage of S/4 is that queries from the geodatabase can go against S/4 ABAP CDS views as an S/4 user. There's no need to understand the underlying PM schema and these CDS views are supported by us. So any queries against these CDS views won't break. Authentication via SDI/DPA (SAP data provisioning agent) is done at the S/4 user level. If the PM system isn't S/4, you can still query on the fly but it will be at the database level.
The upshot is the integration with SAP PM is greatly eased by the geodatabase being on HANA provided the SAP equipment number or TPLNR (FLOC) is stored as an attribute in the feature classes. Feel free to email me at tom.turchioe@sap.com if you have more questions.