Oracle Analytics and AI

Conor Murnane

Hello - We are setting up a connection from OAC to an On-Prem Essbase Cube using a PAC/Load Balancer

When we get to the point of connecting OAC to Essbase we are running into connection issues and not getting any status returns. The connection continues to spin.

Any recommendations on how we identify the correct DSN for the Essbase connection?

ex. ip address:port or http(s)://<hostname>:<port>/essbase/capi/<private essbase host address>/<Oracle Essbase Agent port on the specified host>

Thanks

Conor Murnane

Figured out the issue see not from this documentation: https://docs.oracle.com/en/cloud/paas/analytics-cloud/acoci/top-faqs-private-data-sources.html#ACOCI-GUID-43BEF504-B756-42D8-91F4-5251219A65C8

FAQ #7 - In Oracle Analytics Cloud, create a data source connection using the hostname datasource-ds-01.ocivn.example.com.

Only use server host name as DSN for connection.