Modeling Guide

OData Query Consumer

OData SQL Consumer (com.sap.dh.sdi.odata.query.consumer) is based on system.externalOperator and uses datahub-flowagent for execution

Configuration Parameters

Parameter

Type

Description

Default (N)VARCHAR Size integer The default size of a varchar.

Default: 1024

Batch Query boolean Determines whether the query is performed in batches or not.

Default: false

Query string OData Query URI that is standard to this OData source.
Fetch Size integer Indicates the number of rows that will be fetched from the source in each request. For wide tables, smaller values are better. For tables with fewer columns, larger values are better.

Default: 100

Input

Input

Type

Description

inSQL

string

OData Query URI that is valid for this OData Source.

Output

Output

Type

Description

outConfig

string.flowagent.config

FlowAgent type port, which only Flowagent producers can consume (i.e., Flowagent File Producer). In order to get the data as string, Flowagent CSV Producer can be used as producer.

outError

string

Operator error. If mapped, the operator error will be sent to the operator this port is mapped to and the graph will remain running. If not mapped, the graph will terminate with the operator error.