SAP HANA Connector Configuration

Connecting to SAP HANA database for metadata ingestion requires configuration guidance, or there are issues establishing a connection to HANA instances.

Note: For DataHub Cloud customers, infrastructure-level changes are managed by DataHub Support.

1. Configure SAP HANA connector:

This example is for SAP HANA but configuration principles can be adapted for other enterprise database systems.

source:
  type: hana
  config:
    host_port: "hana-server.company.com:30015"
    database: "SYSTEMDB"  # or your database name
    username: "${HANA_USER}"
    password: "${HANA_PASSWORD}"
    # Schema filtering
    schema_pattern:
      allow: ["PROD_.*", "ANALYTICS"]
      deny: ["TEMP_.*", "TEST_.*"]

2. Verify HANA connectivity:

   • Ensure HANA instance is accessible from DataHub executor
   • Check firewall rules allow connections on HANA port (typically 3XX15)
   • Test connectivity using SAP HANA Studio or hdbcli from same network

3. Configure HANA permissions:

   • Service account needs CATALOG READ privileges
   • Grant access to system views for metadata extraction:

This SQL example is specific to SAP HANA but similar privilege grants exist in other database systems.

-- Grant necessary system privileges
GRANT CATALOG READ TO datahub_user;
GRANT SELECT ON SCHEMA _SYS_REPO TO datahub_user;

4. Troubleshoot connection issues:
   • Verify HANA instance name and port
   • Check if SSL/TLS is required and configure accordingly
   • Confirm username/password authentication is enabled
   • Review HANA audit logs for connection attempts

Test configurations in a development environment before applying to production. Always backup configurations before making changes.

• DataHub Documentation

• 5779, 5752, 5812