Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 214 Oracle Analytics News
- 43 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Essbase DSN
Summary
Essbase DSN
Content
I'm attempting to connect to an Essbase data source in DV for a Fusion Cloud instance and was wondering what the default port and URL look like.
I watched the following video and attempted with my own hostname but I'm still getting "Failed to save connection".
Answers
-
Yes looks like you're using the wrong port
0 -
I'll look into that, I'm not 100% sure to be honest. I'm guessing it would be the default for the ERP Cloud.
0 -
I'm seeing what I posted below. Assuming that I've got the wrong port or that something is wrong with the URL I used.
Essbase Error 1030818: The client timed out waiting to connect to Essbase Agent. Check your network connections, host and port values, and that Essbase is started.
0 -
Can you check in the logs what the error is?
You can find the logs at C:\Users\<your username>\AppData\Local\Temp\DVDesktop\logs
0 -
Just a quick one - what kind of Essbbase source? The 12c one baked into OBIEE doesn't work as a source. You can connect but not read any data.
0 -
I would check to make sure that the following ports are open for Essbase:
1423 (necessary to create the connection)
32768-33768 (necessary to pull back outline members and data in DV)
Also, your connection string should be server:1423
Blog link: https://realtrigeek.com/2017/03/17/essbase-as-a-data-source-in-oracle-data-visualization/
0