How to find DSN for Oracle Essbase Database Direct Connection

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.

BalagurunathanBagavathy-Oracle

@Conor Murnane

I suggest you to create a SR for this issue as it helps to review the configuration. Please collect the information mentioned in the article below and upload it in the SR.
What Information To Provide To Oracle Support For Troubleshooting Private Access Channel(PAC) Issues in Oracle Analytics Cloud(OAC) (Doc ID 2756864.1)