Upgrade to Pro — share decks privately, control downloads, hide ads and more …

SAP HANA Spatial and Open Source: Connecting the dots

SAP HANA Spatial and Open Source: Connecting the dots

Presented at SAP TechEd 2022 in Las Vegas, NV, USA

Vitaliy Rudnytskiy

January 19, 2023
Tweet

More Decks by Vitaliy Rudnytskiy

Other Decks in Programming

Transcript

  1. 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. 2
    INTERNAL
    © 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, Poland
    51°04'40.3"N 16°57'48.8"E (WGS84)

    View Slide

  3. 3
    INTERNAL
    © 2022 SAP SE or an SAP affiliate company. All rights reserved. ǀ
    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. 4
    INTERNAL
    © 2022 SAP SE or an SAP affiliate company. All rights reserved. ǀ
    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. 5
    INTERNAL
    © 2022 SAP SE or an SAP affiliate company. All rights reserved. ǀ
    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. 6
    INTERNAL
    © 2022 SAP SE or an SAP affiliate company. All rights reserved. ǀ
    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. 7
    INTERNAL
    © 2022 SAP SE or an SAP affiliate company. All rights reserved. ǀ
    Open Source Packages with SAP HANA Support

    View Slide

  8. 9
    INTERNAL
    © 2022 SAP SE or an SAP affiliate company. All rights reserved. ǀ
    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

  9. 11
    INTERNAL
    © 2022 SAP SE or an SAP affiliate company. All rights reserved. ǀ
    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

  10. 13
    INTERNAL
    © 2022 SAP SE or an SAP affiliate company. All rights reserved. ǀ
    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

  11. 15
    INTERNAL
    © 2022 SAP SE or an SAP affiliate company. All rights reserved. ǀ
    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

  12. 17
    INTERNAL
    © 2022 SAP SE or an SAP affiliate company. All rights reserved. ǀ
    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

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

    View Slide

  14. © 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