Property | Description |
|---|---|
Connection | Name of the source connection. You can select an existing connection or create a new connection for the source connection property. |
Source Type | Type of the source object. Select Single Object as the source type. Default is Single Object. |
Object | Name of the SAP OData V2 source object based on the source type selected. Select the source object for a single source. You can also select an existing object from the list. |
Property | Description |
|---|---|
Filter | Filters record based on the filter condition in a read operation. You can configure a simple filter or an advanced filter to filter rows from the source based on a filter condition. You can improve efficiency by filtering early in the data flow. Click Configure to add conditions to filter records from the data that the Secure Agent reads from the source. Select one of the following filter options from the list:
If you configure a filter here, do not enter the $filter query in the Query Data Options field in the advanced source properties. For more information on filters and operators that you can configure, see URI conventions for OData Version 2.0. |
Sort | Not applicable for SAP OData V2 Connector. |
Property | Description |
|---|---|
Page Size | Determines the number of rows to read in each request. Default is 1000. |
Number of Rows to Skip | Sets the number of rows you can skip. For example, you can set this property to n to skip the first n rows in a source and read from the (n+1) row. Default is 0. If you enter the number of rows to skip, do not enter the $skip query in the Query Data Options field in the advanced source properties. |
Number of Rows to Fetch | Determines the number of rows you can read from the source. For example, specify a value of 100 to read 100 records from the source. Specify 0 to read all records from the source. Default is 0. If you enter the number of rows to read, do not enter the $top query in the Query Data Options field in the advanced source properties. |
Maximum Retry Attempts | The maximum number of retry attempts made to receive the response from the OData V2 endpoint. Default is 1. |
Retry Interval in seconds | The time in seconds to wait between each retry attempt. Default is 5. |
Query Data Options | Additional data queries to use when you read data from the SAP OData V2 sources. You can enter multiple data queries, separated by an ampersand (&), in the following format: <Query option1>=<value>&<Query option2>=<value>&<Custom query3>=<value>.... For example, if you want to filter records with a unique identifier greater than or equal to 4500000000000190001 and sort them in the descending order by their unique identifiers, enter the following data queries: $filter=Uniqueid ge '4500000000000190001'&$orderby=Uniqueid desc When you add data queries, ensure that there is no space before and after the equal sign (=). If you enter the $filter, $top, or $skip query in this field, do not configure a filter condition in the Filter field, or enter values in the Number of Rows to Fetch or Number of Rows to Skip field, respectively. For more information about the list of data queries that you can configure, see Query options in the SAP documentation. |
Tracing Level | Determines the amount of detail that appears in the log file. Select one of the following options from the list:
Default is Normal. |
Cache Size for Web Service Response (KB) | The memory in KB available for the web service response. If the source contains many rows or columns, you might want to increase the cache size. Default is 1024. |
Optimize transformation | Select to improve performance for processing records at run time. Default is disabled. |