Wednesday 5 October 2022

GDAL with SAP HANA driver in OSGeo4W

I got great news from our SAP HANA multi-model engineering team: now OGR driver for SAP HANA is included in OSGeo4W too!

OSGeo4W is a binary distribution of a broad collection of open-source geospatial software for Windows environments.

Setup SAP HANA plug-in…


Now, when installing or configuring OSGeo4W on your Windows machine, search for hana and include gdal-hana package to be installed.

SAP HANA Exam, SAP HANA Career, SAP HANA Tutorial and Materials, SAP HANA Career, SAP HANA Jobs, SAP HANA Prep, SAP HANA Preparation

Once the OSGeo4W setup process is completed check in the OSGeo4W Shell that the OGR driver for SAP HANA is included:

ogrinfo --formats | find /i "HANA"

SAP HANA Exam, SAP HANA Career, SAP HANA Tutorial and Materials, SAP HANA Career, SAP HANA Jobs, SAP HANA Prep, SAP HANA Preparation

…and use it!


I described some basic examples in the “Use it” post, like:

ogrinfo -ro HANA:"DSN=DBADMIN-VITAL-TRIAL-HC-HDB;DRIVER=HDBODBC;SCHEMA=TESTGEO"

SAP HANA Exam, SAP HANA Career, SAP HANA Tutorial and Materials, SAP HANA Career, SAP HANA Jobs, SAP HANA Prep, SAP HANA Preparation

Just remember to use Windows Command Prompt’s new line ^ syntax…

ogrinfo -ro HANA:"DSN=DBADMIN-VITAL-TRIAL-HC-HDB;SCHEMA=TESTGEO" ^
  -so world-continents

SAP HANA Exam, SAP HANA Career, SAP HANA Tutorial and Materials, SAP HANA Career, SAP HANA Jobs, SAP HANA Prep, SAP HANA Preparation

…and setup ODBC connection properly on your Windows machine:

SAP HANA Exam, SAP HANA Career, SAP HANA Tutorial and Materials, SAP HANA Career, SAP HANA Jobs, SAP HANA Prep, SAP HANA Preparation

No comments:

Post a Comment