SAP OData V2 Connector > Mappings and mapping tasks with SAP OData V2 Connector > SAP OData V2 sources in mappings
  

SAP OData V2 sources in mappings

To read data from entities that are exposed and accessible through OData V2-compliant applications in SAP, configure an SAP OData V2 object as a source in a mapping.
Specify the name and description of the SAP OData V2 source. Configure the source, query options, and advanced properties for the source object.
The following table describes the source properties that you can configure for an SAP OData V2 source:
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.
The following table describes the query options that you can configure for an SAP OData V2 source:
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:
  • - Not parameterized. Uses a basic filter to specify the object, field, operator, and value to select specific records. This filter option applies only to flat entities.
  • - Advanced. Uses an advanced filter to define a complex filter condition. This filter option applies to flat and hierarchical entities.
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.
The following table describes the advanced source properties that you can configure for an SAP OData V2 source:
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.
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.
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.
Tracing Level
Determines the amount of detail that appears in the log file.
Select one of the following options from the list:
  • - Terse
  • - Normal
  • - Verbose Initialization
  • - Verbose Data
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.