OData Service
Overview
API-enabled data access was once the sole preserve of Enterprise operations, i.e. those with in-house development capability. In order to bridge the gap and allow citizen-driven API integrations we have introduced the OData (Open Data Protocol) Service. It is a dedicated service that can integrate with any application or platform that supports OData feeds which includes Microsoft Excel and Power BI. It enables user-access to ITAS Data Entities and Reports whilst implementing common policies and permissions managed through ITAS.
It also provides an alternative, low-code method of building workflows through an Enterprise-managed platform such as SnapLogic, Mulesoft or Power Platform.
Purpose
This service provides the source data for a number of scenarios:
- Users needing to get raw data from a single or collection of Data Entities (tables)
- Users needing to access custom ITAS Reports (see list below)
- System Integrators needing data for regular extracts to other systems either on-demand or scheduled
- Reporting Database users needing to extract timestamped data either for direct reporting or providing a staging area for data to be moved at a later date
ITAS Reports available to OData
(premium subscription required)
| Name | Version | Release |
| Cash Usage | 1 | 8.16 |
| Position | 2 | 8.18 |
| Valuation | 1 | 8.17 |
| Futures Open Position | 1 | 8.17 |
| Counterparty Risk | 1 | 8.18 |
| Currency Exposure | 1 | 8.18 |
Identity and Policy Integration
Access to the assets exposed by the OData Server is controlled in the same way as when accessed through Trader Desktop and Web (Data) Portal platforms. Identity is validated through either Basic Authentication (user provides Windows credentials to be verified by the ITAS Identity Server) or a dedicated token where the previous method cannot be employed. Once the user is identified, their policies and permissions assigned to the ITAS (CMP) account will be applied as normal, including authorisation to Trading Entities, Data Access permissions and so on.
Where the service is used for system integrations, dedicated tokens can be provided to elevate access rights.
This feature is available to Enterprise and Premium Plan subscribers through Data Management Services.