You are here: New Formats for 2016+SAP HANA Non-Spatial Reader/Writer

SAP HANA Non-Spatial Reader/Writer

Licensing options for this format begin with FME Professional Edition.

The SAP HANA Non-Spatial reader and writer modules provide FME with access to attribute data held in SAP HANA database tables.

FME provides read and write access via SAP's JDBC driver, which must be installed separately.

Downloading and Installing the JDBC Driver

The JDBC driver is available in the SAP HANA Client Libraries package, and is usually named ngdbc.jar.

This package is downloadable from the SAP HANA One Console. In version 90 of SAP HANA One (Amazon EC2 Instance), it can be found by following these instructions:

  1. Visit your SAP HANA One Portal by opening the EC2 Instance Public IP in a web browser.
  2. Click Open HANA One Console.
  3. Click Downloads.
  4. Download any of the SAP HANA Client Libraries (each contains a cross-platform JDBC driver).
  5. Extract <downloaded platform>/SAP_HANA_CLIENT/client/JDBC.tgz from the downloaded archive.
  6. Extract ngdbc.jar from JDBC.tgz.

Place ngdbc.jar in one of the locations that are added to the Java CLASSPATH when the Java Virtual Machine is loaded. These locations are:

  • <FME_install_directory>/plugins
  • <Server_install>/Resources/shared/Plugins/Java
  • <User_Documents>/FME/Plugins/Java