OpenAir OData Service
The Business Intelligence (BI) Connector feature uses the OData standard to make your published OpenAir resources available as a data source which you can import into BI tools applications supporting OData v4/JSON.
The Open Data Protocol — or OData — is an ISO/IEC approved and widely supported standard which allows the exchange of data between applications. Most BI tools, including Microsoft Excel, support OData either natively or with the aid of a plug-in.
OASIS Open Data Protocol (OData) TC gives the following overview:
The OASIS OData TC works to simplify the querying and sharing of data across disparate applications and multiple stakeholders for re-use in the enterprise, Cloud, and mobile devices. A REST-based protocol, OData builds on HTTP, AtomPub, and JSON using URIs to address and access data feed resources. It enables information to be accessed from a variety of sources including (but not limited to) relational databases, file systems, content management systems, and traditional Web sites. OData provides a way to break down data silos and increase the shared value of data by creating an ecosystem in which data consumers can interoperate with data producers in a way that is far more powerful than currently possible, enabling more applications to make sense of a broader set of data. Every producer and consumer of data that participates in this ecosystem increases its overall value.
For more information about OData, see the OData website.
OpenAir OData service or OData service designates the software technology supporting the BI Connector functionality. It works as a repository for published OpenAir resources and as the connection point which can be used to load OpenAir data into compatible applications.
OpenAir OData feed or OData feed designates the particular collection of published resources you have access to in the OpenAir OData service. For information about connecting to your OData feed, see Your OData Feed URL and Connection Details.
You can use your OData feed URL and connection details to:
-
Connect to your OData feed resource from your BI tools or other compatible applications — see Connecting BI Tools to Your OData Feed.
-
View OData feed resource data directly in your web browser. The browser displays your resource data as a JSON object — see Viewing Your OData Resource Data in a Web Browser.
-
(For developers) Request OData feed resource data in your applications using the HTTP GET method. The OData service returns the response as a JSON object — see Consuming OpenAir OData Resource Data in Your Applications.