Skip to content
TwinCommitDocs

SAP HANA target

TwinCommit applies changes to SAP HANA with array-bound UPSERT ... WITH PRIMARY KEY and keyed DELETE statements. The checkpoint is updated in the same transaction. Target tables are column-store by default.

Supported: SAP HANA 2.0 SPS 05 and later · SAP HANA Cloud.

Configuration

Section titled “Configuration”
target:
  type: saphana
  host: hana-analytics.internal
  port: 30015
  tenant: ANA
  user: TWINCOMMIT
  password: ${HANA_TARGET_PASSWORD}
  schema: REPLICA
  table_type: column        # column | row

How apply works

Section titled “How apply works”
  • Inserts and updates use UPSERT REPLICA.ORDERS VALUES (?, ?, ...) WITH PRIMARY KEY with array input.
  • Deletes are array-bound.
  • The checkpoint row is updated, then the transaction commits.

Grants

Section titled “Grants”
CREATE USER TWINCOMMIT PASSWORD "********" NO FORCE_FIRST_PASSWORD_CHANGE;
CREATE SCHEMA REPLICA OWNED BY TWINCOMMIT;