Supported and Unsupported OData Features
The OData service implementation in Integration Server supports the following OData features:
ATOM, JSON, and XML formats for representing the resources that are exposed as data services.
CRUD operations for each entity type.
System query options such as
$select,
$expand,
$filter,
$orderby,
$top,
$skip,
$format,
$inlinecount, and
$count.
Note: When there is an association between two entity types, to use the $expand query option, ensure that you have defined the relationship between the related keys in these entity types using the $filter option.
Association and navigation properties.
Note: To the achieve the $expand query option,
The OData service implementation in Integration Server does NOT support the following actions:
Rename, copy, or move OData services.
Copy and paste OData elements, such as entity types and complex types, within and outside the OData service editor.
Rename OData associations and navigation properties.
Rename External Entity Types.
The following OData features are NOT supported:
Function Imports
Referential constraints
Annotations
Collection type data type
Lambda query operators