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

SAP OData V4 sources in mappings

To read data from entities that are exposed and accessible through OData V4-compliant applications in SAP, configure an SAP OData V4 object as a source in a mapping.
Specify the name and description of the SAP OData V4 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 V4 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 V4 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 V4 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.
  • - Advanced. Uses an advanced filter to define a complex filter condition.
For more information on filters and operators that you can configure, see URI conventions for OData Version 2.0.
Sort
Add conditions to sort records.
Select one of the following sort options from the list:
  • - Not parameterized. Select the fields and type of sorting to use.
  • - Parameterized. Use a parameter to specify the sort option.
The following table describes the advanced source properties that you can configure for an SAP OData V4 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.
Data Serialization Format
The format of data that is transferred over the network.
Select one of the following formats from the list:
  • - ATOM/XML
  • - JSON
Default is JSON.
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 web service response 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.