Supported and Unsupported OData Features
The OData service implementation in Integration Server supports the following OData features:
![*](chapterTOC_bullet.png)
ATOM, JSON, and XML formats for representing the resources that are exposed as data services.
![*](chapterTOC_bullet.png)
CRUD operations for each entity type.
![*](chapterTOC_bullet.png)
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.
![*](chapterTOC_bullet.png)
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:
![*](chapterTOC_bullet.png)
Rename, copy, or move OData services.
![*](chapterTOC_bullet.png)
Copy and paste OData elements, such as entity types and complex types, within and outside the OData service editor.
![*](chapterTOC_bullet.png)
Rename OData associations and navigation properties.
![*](chapterTOC_bullet.png)
Rename External Entity Types.
The following OData features are NOT supported:
![*](chapterTOC_bullet.png)
Function Imports
![*](chapterTOC_bullet.png)
Referential constraints
![*](chapterTOC_bullet.png)
Annotations
![*](chapterTOC_bullet.png)
Collection type data type
![*](chapterTOC_bullet.png)
Lambda query operators