Categories
How to find DSN for Oracle Essbase Database Direct Connection

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
Best Answer
-
Figured out the issue see not from this documentation:
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.
1
Answers
-
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)0