This release introduces a customer-facing OData API for the Arcoro Data Warehouse as a distinct extension of the public Arcoro API. It enables users to query warehouse data through standard OData-compatible tools such as Power BI, Excel, and custom scripts, while clearly separating analytics use cases from the existing transactional REST API.
Learn more about the Arcoro API from our dedicated page here.
Enhancements
- A dedicated customer-facing OData API surface for Arcoro Data Warehouse data.
- APIM exposure that keeps the warehouse OData experience separate from the transactional REST API.
- Support for standard OData query capabilities, including $select, $filter, $expand, $orderby, $top, $skip, and $count.
Please Note
- This API is intended for analytic and reporting use cases, not transactional or real-time workflows.
- The Data Warehouse is reloaded nightly, so returned data may lag OLTP data by up to approximately 24 hours.
- This surface is read-only. OData write operations such as POST, PATCH, and DELETE are not supported.
- Customers should use the REST API for operational, real-time use cases and use DW OData for analysis, extraction, and BI scenarios.