Denodo OData 4.0 Service

OData (Open Data Protocol) is a REST-based protocol for querying and updating data using simple HTTP messages. It is an OASIS standard based on technologies such as HTTP, Atom/XML and JSON.

Virtual DataPort provides an OData 4.0 compliant interface, through is “Denodo OData service”.

The OData Service is available at: https://denodo-server.acme.com:9090/denodo-odata4-service/denodo-odata.svc/<database name>/.

Note

The segment “<database name>” is mandatory.

Features

The standard OData 4.0 defines three levels of conformance for OData services. The Denodo OData 4.0 Service conforms to the Intermediate Conformance Level by providing the following functionality:

  • Read-only access to Denodo databases:

    • Metadata

    • Entities

    • Items of an entity

    • Properties of an item

    • Property values

    • Relationships between entities

  • Format results in Atom and JSON

  • Query options

    • $select

    • $filter

    • $expand

    • $orderby

    • $skip

    • $top

    • $count

  • Parameter aliases

  • Pagination

  • Authentication

    • HTTP Basic

    • Kerberos (SPNEGO)

In addition, this service also supports OAuth 2.0 authentication.