Modeling Guide

SAP HANA Monitor

The SAP HANA Monitor operator creates a trigger on a given table and for each row inserted it saves a copy on a temporary table and polls this temporary table for those new rows.

Configuration Parameters

Parameter

Type

Description

dsn

string

Mandatory. The connection string.

Default: "hdb://user:password@host:port"

tableMonitored

string

Mandatory. The table monitored.

Default: "

schemaName

string

Mandatory. The schema of the monitored table.

Default: "

tableColumnNames

string

Mandatory. The columns names of the monitored table each followed by its type.

Default: "

pollPeriodInMs

int

Mandatory.

The time in milliseconds on which the temporary table will be polled for new rows.

Default: 1000

numRetryAttempts

int

The number of retry attempts.

Default: 0

retryPeriodInMs

int

The waiting time in milliseconds between consecutive retry attempts.

Default: 0

connectionTimeoutInMs

int

The number of milliseconds to wait for when connecting to HANA before timing out.

Default: 10000

Input

None

Output

Output

Type

Description

outResult

string

The SAP HANA server response to the poll query after the period in ms have passed.