Has anyone successfully used OData to connect SharePoint with Oracle Analytics?
If OData isn’t supported or practical, what other recommended or supported approaches have you used to integrate SharePoint data with Oracle Analytics?
additionally
Oracle Analytics reintroduced the OData connector in the September 2024 update to support the OData v4.0 protocol. However, you should be aware of several restrictions that may affect a SharePoint integration:
Data Type Limitations: OAC only supports a specific set of OData data types, including Edm.String, Edm.Int16/32/64, Edm.Double, Edm.Decimal, Edm.Date, and Edm.DateTimeOffset. Unsupported Elements: The connector does not support complex types, Enums, or OData v4 Actions and Functions. Server Limits: If your SharePoint/OData server uses a custom $top limit that causes query failures when exceeded, OAC may be unable to load the tables.
an alternatives is to use REST API Connector
@User_0WRRJ - Welcome to Oracle Analytics Community!
Odata is supported or certified with OAC. Please refer the below notes and it has all the details needed for establishing the connectivity. Kindly validate the version of Odata.
Reference - https://docs.oracle.com/en/cloud/paas/analytics-cloud/acsds/odata.html
Do you know if connections that do not use TLS will be affected by the September 2026 update? Regards, Alison.
Hi Team, We would like to raise an enhancement request for the SSO/SAML configuration guidance for OAS 2026. We have already raised multiple SRs regarding OAS 2026 SSO configuration. However, we are facing difficulties getting the required guidance, as the available documentation does not clearly cover the OAS 2026 SSO…
We are planning to archive the Contract and Lease data currently sourced from the External Source as Contract and Lease accounting functions are being migrated to Oracle's CLM and Lease Accounting modules. At this stage, only active and partially closed records are being converted into Oracle and the remaining historical…
The difference column is a calculation, and I would like to average that row.
We are trying to convert our OAS reports to OAC and one of the parameters in the where clause of the report is what I am trying to make in OAC. I created a calculation as follows and I am trying to put it into a filter . The code validates EVALUATE('GREATEST ( TRUNC ( NVL (%1, TO_DATE (''1/1/2013'', ''mm/dd/yyyy'') ) ),…
