Skip to Content
Technical Articles
Author's profile photo Mathias Kemeter

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:

 

Assigned tags

      5 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo gobinath palanisamy
      gobinath palanisamy

      Can you please tell me how to bring this map into SAP GEF without arcgis Server/Enterprise(because the database already in SAP Environment).

      Author's profile photo Mathias Kemeter
      Mathias Kemeter
      Blog Post Author

      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

      Author's profile photo Tyrone Scamaton
      Tyrone Scamaton

      Hi Mathias,

       

      Thanks for the blog!

       

      Are you familiar at all with integrating ArcGIS with SAP Plant Maintenance?

       

      Regards,

      Tyrone.

      Author's profile photo Mathias Kemeter
      Mathias Kemeter
      Blog Post Author

      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

      Author's profile photo Tom Turchioe
      Tom Turchioe

      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.