OpenAir OData Service
OpenAir Business Intelligence Connector 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 designates the software technology supporting OpenAir Business Intelligence Connector’s features. 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 designates the particular collection of published resources you have access to in the OpenAir OData service. For information about connecting to your OpenAir OData feed, see Your OpenAir OData Feed URL and Connection Details.
You can use your OpenAir OData feed URL and connection details to:
-
Connect to your OpenAir OData feed resource from your BI tools or other compatible applications — see Connecting BI Tools to Your OpenAir OData Feed.
-
View OpenAir OData feed resource data directly in your web browser. The browser displays your resource data as a JSON object — see Viewing Your OpenAir OData Resource Data in a Web Browser.
-
(For developers) Request OpenAir OData feed resource data in your applications using the HTTP GET method. The OpenAir OData service returns the response as a JSON object — see Consuming OpenAir OData Resource Data in Your Applications.