Configuration

This section explains each of the properties in the configuration blade. 
General
Property
Description
Collection
This associates the Agent to a specific Collection (default to that of the current Data Stream).
Refer to Collections and Stream Hosts to understand more about Collections.
Connection Details
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.
Object Details
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).
Filtering & Sorting
Property
Description
Filters
Optional filter criteria applied to the selected table, made up of the following:
Column (from the selected HANA table)
Operand (operation such as equals, less than)
Mapping (from the input payload)
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.
Endpoints
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.

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: Column (from the selected HANA table) Operand (operation such as equals, less than) Mapping (from the input payload)
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.

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.

Last modified 6mo ago