Configuration
This section explains each of the properties in the configuration blade.

Property | Description |
---|---|
Collection | This associates the Agent to a specific Collection (default to that of the current Data Stream). |
Property | Description |
---|---|
Use Connection Variables | Tick to select saved variables; or enter the text manually for the authentication properties. |
DSN | The System Data Source Name as setup under ODBC Data Sources. |
Driver | The name of the 64-bit HANA ODBC Driver. |
Server | The IP Address of the SAP HANA Server. |
Port | The Port number on which SAP HANA Server is running. |
Username | The user name to use for authenticating the connection. |
Password | The password to use for authenticating the connection. |
Query Timeout (sec) | The number of seconds to timeout a non-completing call to SAP HANA. |
Property | Description |
---|---|
Database | The name of the database to connect to. |
Schema | The name of the schema to which the table belongs. The list is generated based on the database selected. |
Table | The name of the table to connect to. The list is generated based on the schema selected. |
Columns To Return | The columns returned in the output payload. If no columns are specified, the Agent will return all the columns from the table. The list is generated based on the table selected. |
Results Returned As | The options are Append to Current (selected columns appended to the input payload) or New (selected columns only). |
Property | Description |
---|---|
Filters | Optional filter criteria applied to the selected table, made up of the following:
|
Limit Rows Returned | The maximum number of rows to be returned. If left blank (default), all qualifying rows will be returned. |
Sort By | The (optional) order in which the data should be sorted. More than one sort order can be specified. |
Before configuring the Action Agent, please ensure that its input endpoint is connected to a parent Agent which will be sending data to it.
Name | Description |
---|---|
Output | The read events will be made available on this Endpoint with attributes based on the Columns To Return and Return Results As properties. |
Error | Errors encountered during the execution of this Agent will be published on this endpoint. |