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. |