SAP HANA Spatial and Open Source: Connecting the dots

1
INTERNAL
© 2022 SAP SE or an SAP affiliate company. All rights reserved. ǀ
SAP HANA Spatial and Open Source:
Connecting the dots
Mathias Kemeter, Witalij Rudnicki
SAP TechEd, 2022/11

View Slide

2
INTERNAL
Let me introduce myself
- Vitaliy Rudnytskiy (aka Witalij Rudnicki)
@Sygyzmundovych
- SAP’s Developers Center (developers.sap.com)
- Data, Analytics
- Based in Wrocław, Poland
51°04'40.3"N 16°57'48.8"E (WGS84)

View Slide

3
INTERNAL
The New Kid on the DBMS-Block
Multi-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 an
issue
• ..is a niche in the SAP ecosystem, although SAP HANA is a
Market Leader for Multi-model Data Platforms*
* According to the Forrester Wave for
Multi-model Data Platforms in Q1/2021
Our 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

View Slide

4
INTERNAL
Spatial data exchange formats
SAP HANA Spatial
Well-Known Text (WKT)
§ 'POINT(1 1)'
Well-Known Binary (WKB)
§ 0101000000000000000000F03F000000000000F03F
ESRI Shapefiles
§ Popular format for geospatial vector data
GeoJSON
§ {"x" : 8.6, "y" : 49.3, "spatialReference" : {"wkid" : 4326}}
Scalable Vector Graphic (SVG)
§ stroke="black" strokewidth=" 1" x="1" y="-1"/>
SAP HANA
Data sources
Analysis
/ Apps
files
input output

View Slide

5
INTERNAL
Trying it out: ASCII world map from open data shape files
https://blogs.sap.com/2017/02/13/ascii-art-map-of-the-world-using-sap-hana-geospatial-processing/

View Slide

6
INTERNAL
SAP HANA Database Explorer
Web-based Swiss Army Knife for managing data in SAP HANA Cloud
Community 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

View Slide

7
INTERNAL
Open Source Packages with SAP HANA Support

View Slide

9
INTERNAL
SAP HANA Python Client for Machine Learning
Integrate SAP HANA (Multi-model) with your favorite Python Libraries
Community 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 libraries
i.e. Pandas, GeoPandas, Kepler.gl, Folium, NetworkX, etc.
• Orchestrate complex workflows on SAP HANA with Python

View Slide

11
INTERNAL
GDAL
A Translator Library for Raster and Vector Geospatial Data Formats
https://gdal.org
When to use:
• Develop geospatial applications. GDAL bindings are available
for 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 software
Community 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

View Slide

13
INTERNAL
DBeaver
Free multi-platform database tool for developers, database administrators, analysts
https://dbeaver.io
Community 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 a
great variety of DBMS
• Import/Export data
• Move data between DBMS
• Get map previews for spatial result data sets

View Slide

15
INTERNAL
QGIS
A Free and Open Source Geographic Information System
Community 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.org
When to use:
• Analyze geospatial data on a map
• Sophisticated geospatial visualizations with custom
symbology
• Implement GIS workflows and provide read/write access to
GIS departments
• Import/Export spatial data formats

View Slide

17
INTERNAL
GeoServer
An Open-source Server for sharing Geospatial Data
Community Content:
• https://blogs.sap.com/2019/11/26/open-source-gis-with-sap-
hana/
• https://www.youtube.com/watch?v=RcdtBsxXkIU
https://geoserver.org
When to use:
• Consume spatial data in SAP HANA with standardized web
services
• Developing web applications, that need to show SAP HANA
data on a map
• Integrate spatial data in SAP HANA with 3rd party applications

View Slide

Thank you.
Witalij Rudnicki
SAP Developer Advocate
Mathias Kemeter
Head of SAP HANA Multi-model Engines

View Slide

© 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 of
SAP SE or an SAP affiliate company.
The information contained herein may be changed without prior notice. Some software products marketed by SAP SE and its
distributors 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 or
warranty 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 warranty
statements accompanying such products and services, if any. Nothing herein should be construed as constituting an additional
warranty.
In particular, SAP SE or its affiliated companies have no obligation to pursue any course of business outlined in this document or
any 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, and
functionality are all subject to change and may be changed by SAP SE or its affiliated companies at any time for any reason
without notice. The information in this document is not a commitment, promise, or legal obligation to deliver any material, code, or
functionality. All forward-looking statements are subject to various risks and uncertainties that could cause actual results to differ
materially from expectations. Readers are cautioned not to place undue reliance on these forward-looking statements, and they
should 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 registered
trademarks of SAP SE (or an SAP affiliate company) in Germany and other countries. All other product and service names
mentioned are the trademarks of their respective companies.
See www.sap.com/trademark for additional trademark information and notices.
www.sap.com/contactsap
Follow us

View Slide

SAP HANA Spatial and Open Source:Connecting the dots

SAP HANA Spatial and Open Source: Connecting the dots

Vitaliy Rudnytskiy

More Decks by Vitaliy Rudnytskiy

Other Decks in Programming

Featured

Transcript