Integration Reporting

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.   

Last updated 24 Apr 2023


Contents of OData Service


Was this helpful?
Thanks for your feedback

Recently viewed