SAP HANA Integration Requirements

The following are the prerequisites necessary for IBM Automatic Data Lineage to connect to this third-party system, which you may choose to do at your sole discretion. Note that while these are usually sufficient to connect to this third-party system, we cannot guarantee that the connection or integration will be successful since we have no control, liability, or responsibility for third-party products or services, including for their performance.

• SAP HANA on premises 2.0 SPS 05 or newer or SAP HANA Cloud

  • The differences between the on-premises and cloud versions are described in https://help.sap.com/viewer/3c53bc7b58934a9795b6dd8c7e28cf05/hanacloud/en-US/a55dd4eb896c4198828f179f4a12feab.html .

• SAP HANA JDBC driver
  The Manta Flow client distribution does not contain SAP HANA JDBC driver. Use the JDBC driver available with the SAP HANA client and copy the driver JAR file to <MANTA_DIR_HOME>/scenarios/manta-dataflow-cli/lib-ext.

• User having the following rights:

  • PUBLIC role (usually assigned implicitly)

  • or CATALOG READ system privilege with SELECT granted on the following system views

    • SYS.TABLES

    • SYS.TABLE_COLUMNS_ODBC

    • SYS.VIRTUAL_TABLES

    • SYS.VIEWS

    • SYS.VIEW_COLUMNS

    • SYS.VIEW_PARAMETERS

    • SYS.FUNCTIONS

    • SYS.FUNCTION_PARAMETERS

    • SYS.FUNCTION_PARAMETER_COLUMNS

    • SYS.PROCEDURES

    • SYS.PROCEDURE_PARAMETERS

    • SYS.PROCEDURE_PARAMETER_COLUMNS

    • SYS.LIBRARIES

    • SYS.OBJECT_DEPENDENCIES

    • SYS.REMOTE_SOURCES

    • SYS.SCHEMAS

    • SYS.SEQUENCES

    • SYS.SYNONYMS

    • SYS.TRIGGERS

• Connection parameters:

  • Name or IP address of the database

  • Port on which the database listens for JDBC connections

  • User name

  • User password

• Database must be accessible via network

Supported Features

• Statements that are supported include CREATE TABLE, CREATE VIEW (parametrized and calculation views not supported), CREATE FUNCTION/PROCEDURE, CREATE TRIGGER, DO BEGIN ... END, TRUNCATE TABLE, SELECT, INSERT, DELETE, UPDATE, UPSERT, CALL, IF/WHILE/FOR, MERGE INTO, ALTER TABLE, CREATE TYPE, and RENAME COLUMN.

Known Unsupported Features

Automatic Data Lineage does not support the following SAP HANA features. This list includes all of the features that IBM is aware are unsupported, but it might not be comprehensive.

• Lineage through dynamically executed code through EXECUTE IMMEDIATE

• Statements that are currently unsupported include EXPORT INTO, CREATE SEQUENCE, CREATE DATABASE, CREATE SCHEMA, GRAPH WORKSPACES, and CREATE INDEX.

• Lineage through Calculation Views: https://help.sap.com/docs/SAP_HANA_PLATFORM/fc5ace7a367c434190a8047881f92ed8/d60ad1f0bb571014af49c9db1740d68c.html