OData

You can connect Oracle Analytics to an OData database.

Supported Versions

4.0

Prerequisites

None.

Connectivity

Use Data Source With Support Connectivity Options Notes
Datasets Yes
  • Public
  • Data access - Cache only
 -
Semantic Modeler No

-

 -
Model Administration Tool No

-

 -
Oracle Analytics Publisher No

-

 -

For more information about this connectivity table, see Key to Connectivity Information.

Other Connectivity Information

  • Oracle Analytics doesn’t support the following OData features:
    • Columns other than the following data types: Edm.String, Edm.Int16, Edm.Int32, Edm.Int64, Edm.Double, Edm.Single, Edm.Decimal, Edm.Date, Edm.TimeOfDay, and Edm.DateTimeOffset.
    • Complex Types and Enums.

    • OData v4 Actions and Functions.

    • OData v4 servers with a custom $top limit. If you specify a custom limit for $top and a query exceeds the $top limit and receives a failure response from the server, then this might prevent you from loading tables in Oracle Analytics.

Useful Documentation Links