Vora Client

The Vora Client operator works as a client for the SAP Vora Transaction Coordinator, and allows you to run statements on it.

Graph com.sap.demo.vora.client demonstrates how to use this operator.

Configuration Parameters

Parameter	Type	Description
connection	object	The object containing the connection parameters to a Vora instance.
terminateOnError	bool	A flag that indicates whether or not the graph should stop if this operator encounters an error. If set to `false`, an output may represent an error, in which case its attribute `message.error` will be `true` and its body will contain a string describing the error. Default: true
numRetryAttempts	int	The number of times to retry an unsuccessful operation before raising an error. Default: 5
retryPeriodInMs	int	The waiting time in milliseconds between consecutive retry attempts. Default: 500
connectionTimeoutInMs	int	The number of milliseconds to wait for when connecting to Vora before timing out. Default: 60000

Input	Type	Description
`sql`	message	Accepts SQL code in a message's body to be executed by the SAP Vora Transaction Coordinator. If the attribute `message.request.id` is present, it will be preserved on the output. If a response callback is present: If result is not connected, the callback will be invoked. If result is connected, the callback will be forwarded to the output without being invoked.

Output	Type	Description
`result`	message	A message containing the result of an operation. If the operation retrieved rows, they will be stored in the message body as `[]map[string]interface{}`, where the keys in each map are the names of each selected column. Otherwise, the body will be `null`.

See terminateOnError for error outputs.

When executing queries, the retrieved data will be output according to the following type equivalence:

Column Type	Output Type
`TINYINT, SMALLINT, INTEGER, BIGINT`	`int64`
`REAL, DOUBLE`	`float64`
`DECIMAL`	`string ("x.y")`
`VARCHAR, CHAR`	`string`
`DATE`	`string ("YYYY-mm-dd")`
`TIME`	`string ("HH:MM:SS")`
`TIMESTAMP`	`string ("YYYY-mm-dd HH:MM:SS.NNNNNNN")`
`BOOLEAN`	`BOOL`