Presented at SAP TechEd 2022 in Las Vegas, NV, USA
1INTERNAL© 2022 SAP SE or an SAP affiliate company. All rights reserved. ǀSAP HANA Spatial and Open Source:Connecting the dotsMathias Kemeter, Witalij RudnickiSAP TechEd, 2022/11
View Slide
2INTERNAL© 2022 SAP SE or an SAP affiliate company. All rights reserved. ǀLet me introduce myself- Vitaliy Rudnytskiy (aka Witalij Rudnicki)@Sygyzmundovych- SAP’s Developers Center (developers.sap.com)- Data, Analytics- Based in Wrocław, Poland51°04'40.3"N 16°57'48.8"E (WGS84)
3INTERNAL© 2022 SAP SE or an SAP affiliate company. All rights reserved. ǀThe New Kid on the DBMS-BlockMulti-model data..• ..is the non-ordinary not-strictly-relational stuff• ..brings a big portion of NoSQL with it• ..is somewhat appealing, but consumption and complexity is anissue• ..is a niche in the SAP ecosystem, although SAP HANA is aMarket Leader for Multi-model Data Platforms** According to the Forrester Wave forMulti-model Data Platforms in Q1/2021Our Approach:• Drive SQL Integration instead of NoSQL approaches, where feasible• Deliver baseline tooling support as part of our stack (i.e. DB Explorer)• Increase adoption with integration into domain specific client software(i.e. contributions to Open Source Software)• Cover NoSQL complexities with standards
4INTERNAL© 2022 SAP SE or an SAP affiliate company. All rights reserved. ǀSpatial data exchange formatsSAP HANA SpatialWell-Known Text (WKT)§ 'POINT(1 1)'Well-Known Binary (WKB)§ 0101000000000000000000F03F000000000000F03FESRI Shapefiles§ Popular format for geospatial vector dataGeoJSON§ {"x" : 8.6, "y" : 49.3, "spatialReference" : {"wkid" : 4326}}Scalable Vector Graphic (SVG)§ stroke="black" strokewidth=" 1" x="1" y="-1"/>SAP HANAData sourcesAnalysis/ Appsfilesinput output
5INTERNAL© 2022 SAP SE or an SAP affiliate company. All rights reserved. ǀTrying it out: ASCII world map from open data shape fileshttps://blogs.sap.com/2017/02/13/ascii-art-map-of-the-world-using-sap-hana-geospatial-processing/
6INTERNAL© 2022 SAP SE or an SAP affiliate company. All rights reserved. ǀSAP HANA Database ExplorerWeb-based Swiss Army Knife for managing data in SAP HANA CloudCommunity Content:• https://developers.sap.com/tutorials/hana-dbx-multi-model.html• https://blogs.sap.com/2022/06/21/visualize-your-spatial-data-in-sap-hana-database-explorer/When to use:• Managing (Multi-model) Data in SAP HANA Cloud• Visualizations for Graph, Spatial and JSON• Import/Export of data• First choice for developers & administrators.Mostly not suitable for Domain Experts
7INTERNAL© 2022 SAP SE or an SAP affiliate company. All rights reserved. ǀOpen Source Packages with SAP HANA Support
9INTERNAL© 2022 SAP SE or an SAP affiliate company. All rights reserved. ǀSAP HANA Python Client for Machine LearningIntegrate SAP HANA (Multi-model) with your favorite Python LibrariesCommunity Content:• https://blogs.sap.com/2020/11/04/tap-into-your-network-using-python/• https://blogs.sap.com/2021/07/21/augment-your-python-analysis-with-multi-model-data-in-sap-hana-cloud/https://pypi.org/project/hana-ml/When to use:• You’re a developer• Advanced Analytics / Data Science / Machine Learning scenarios• Integration with Python librariesi.e. Pandas, GeoPandas, Kepler.gl, Folium, NetworkX, etc.• Orchestrate complex workflows on SAP HANA with Python
11INTERNAL© 2022 SAP SE or an SAP affiliate company. All rights reserved. ǀGDALA Translator Library for Raster and Vector Geospatial Data Formatshttps://gdal.orgWhen to use:• Develop geospatial applications. GDAL bindings are availablefor many languages. Also there are command line tools.• Migrate data from geospatial data sources to SAP HANA• Import/Export almost any geospatial format• Integrate SAP HANA with 3rd party GIS softwareCommunity Content:• Non existing yet. This is too hot off the press. Meanwhile,there is a documentation:• https://github.com/OSGeo/gdal/blob/v3.5.0/NEWS.md• https://gdal.org/drivers/vector/hana.html
13INTERNAL© 2022 SAP SE or an SAP affiliate company. All rights reserved. ǀDBeaverFree multi-platform database tool for developers, database administrators, analystshttps://dbeaver.ioCommunity Content:• https://blogs.sap.com/2020/01/08/good-things-come-together-dbeaver-sap-hana-spatial-beer/• https://blogs.sap.com/2020/04/20/secure-connection-from-dbeaver-to-sap-hana-cloud/When to use:• Manage multiple databases: DBeaver offers support for agreat variety of DBMS• Import/Export data• Move data between DBMS• Get map previews for spatial result data sets
15INTERNAL© 2022 SAP SE or an SAP affiliate company. All rights reserved. ǀQGISA Free and Open Source Geographic Information SystemCommunity Content:• https://blogs.sap.com/2021/02/23/qgis-3.18-supports-sap-hana-cloud/• https://blogs.sap.com/2021/03/01/creating-a-playground-for-spatial-analytics/https://qgis.orgWhen to use:• Analyze geospatial data on a map• Sophisticated geospatial visualizations with customsymbology• Implement GIS workflows and provide read/write access toGIS departments• Import/Export spatial data formats
17INTERNAL© 2022 SAP SE or an SAP affiliate company. All rights reserved. ǀGeoServerAn Open-source Server for sharing Geospatial DataCommunity Content:• https://blogs.sap.com/2019/11/26/open-source-gis-with-sap-hana/• https://www.youtube.com/watch?v=RcdtBsxXkIUhttps://geoserver.orgWhen to use:• Consume spatial data in SAP HANA with standardized webservices• Developing web applications, that need to show SAP HANAdata on a map• Integrate spatial data in SAP HANA with 3rd party applications
Thank you.Witalij RudnickiSAP Developer AdvocateMathias KemeterHead of SAP HANA Multi-model Engines
© 2022 SAP SE or an SAP affiliate company. All rights reserved.No part of this publication may be reproduced or transmitted in any form or for any purpose without the express permission ofSAP SE or an SAP affiliate company.The information contained herein may be changed without prior notice. Some software products marketed by SAP SE and itsdistributors contain proprietary software components of other software vendors. National product specifications may vary.These materials are provided by SAP SE or an SAP affiliate company for informational purposes only, without representation orwarranty of any kind, and SAP or its affiliated companies shall not be liable for errors or omissions with respect to the materials.The only warranties for SAP or SAP affiliate company products and services are those that are set forth in the express warrantystatements accompanying such products and services, if any. Nothing herein should be construed as constituting an additionalwarranty.In particular, SAP SE or its affiliated companies have no obligation to pursue any course of business outlined in this document orany related presentation, or to develop or release any functionality mentioned therein. This document, or any related presentation,and SAP SE’s or its affiliated companies’ strategy and possible future developments, products, and/or platforms, directions, andfunctionality are all subject to change and may be changed by SAP SE or its affiliated companies at any time for any reasonwithout notice. The information in this document is not a commitment, promise, or legal obligation to deliver any material, code, orfunctionality. All forward-looking statements are subject to various risks and uncertainties that could cause actual results to differmaterially from expectations. Readers are cautioned not to place undue reliance on these forward-looking statements, and theyshould not be relied upon in making purchasing decisions.SAP and other SAP products and services mentioned herein as well as their respective logos are trademarks or registeredtrademarks of SAP SE (or an SAP affiliate company) in Germany and other countries. All other product and service namesmentioned are the trademarks of their respective companies.See www.sap.com/trademark for additional trademark information and notices.www.sap.com/contactsapFollow us