7

GDAL with SAP HANA driver in OSGeo4W

 1 year ago
source link: https://blogs.sap.com/2022/08/04/gdal-with-sap-hana-driver-in-osgeo4w/
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
August 4, 2022 1 minute read

GDAL with SAP HANA driver in OSGeo4W

In my previous blog posts, I wrote about the OGR driver for SAP HANA available in the most wide-used geospatial data processing software GDAL/OGR. I wrote as well about how to build the software from the source on macOS.

I got great news from our SAP HANA multi-model engineering team: now OGR driver SAP HANA is included in OSGeo4W too. OSGeo4W is a binary distribution of a broad set 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.

2022-08-04_19-47-18.png

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"
2022-08-04_19-57-50.png

…and use it!

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

ogrinfo -ro HANA:"DSN=DBADMIN-VITAL-TRIAL-HC-HDB;DRIVER=HDBODBC;SCHEMA=TESTGEO"
2022-08-04_20-01-28.png

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
2022-08-04_20-07-36.png

…and setup ODBC connection properly on your Windows machine:

2022-08-04_20-11-49.png

Regards,
-Vitaliy, aka @Sygyzmundovych


About Joyk


Aggregate valuable and interesting links.
Joyk means Joy of geeK