Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 16 Oracle Analytics Lounge
- 215 Oracle Analytics News
- 43 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 79 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
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