Rules and guidelines for SAP OData V2 objects

General guidelines

Consider the following general guidelines when you configure a mapping or task:

• - A mapping might fail with a data truncation error when you read a large data set. To resolve this error, reduce the page size in the advanced source properties.
• - A mapping fails when you use a Joiner transformation to join data from multiple sources that use different authentication types to connect to an SAP OData V2 service.
• - When you read data from hierarchical entities, ensure that the column names do not contain Unicode characters.
• - You can't display field names by labels when you configure source or target fields in a mapping.
• - Data corruption occurs in the target if you specify the $select query in the Query Data Options field for SAP OData V2 sources that contain hierarchical entities.

Filter operations

Consider the following rules and guidelines when you filter data from the source in a mapping or task:

• - You can't configure data filters on child objects for hierarchical entities.
• - To use advanced data filters when you filter data from an SAP OData V2 source, ensure that the filter condition contains only the field name, operator, and field value. You need to remove any additional text that is appended to the filter condition.
• - You can't use a parameter in a filter expression in a simple data filter when you filter data from an object.
• - You can use only the following filter operators in a simple filter:
• - Equals
• - Not Equals
• - Less Than
• - Less or Equals
• - Greater Than
• - Greater or Equals

Data types

To read or write data of the Edm.Time, Edm.DateTime, or Edm.DateTimeOffset data type, ensure that the source or target field contains the corresponding transformation data type based on the source or target object that you use in a mapping.

Parameterization

Consider the following rules and guidelines when you parameterize the connection in a mapping or task:

• - You can't parameterize an SAP OData V2 connection used in the Source or Target transformation.
• - You can't overwrite the source and target connection properties at run time.

Object metadata

Entities that have a cyclic relationship with each other are ignored and the task does not fetch the metadata for such entities.

For example, if a business partner has a relationship with contact details and contact details in turn have a relationship with business partner, then the business partner details within contact fields are ignored and not displayed.

Partitioning

You can't configure partitioning for the SAP OData V2 source.

Data preview

You can't preview data of an SAP OData V2 object that contains hierarchical data.