Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Essbase

Does anyone know how we can connect into Hyperion EssBase ?

I see it mentioned in this case study http://www.talend.com/open-source-provider/casestudy/CaseStudy_Exane_EN.php
but no idea how they plan on actually doing it.
Glen
Labels (2)
6 Replies
Anonymous
Not applicable
Author

I want to connect into Oracle(Hyperion) EssBase by TIS too.
Please tell me whether it is possible in the existing Component.
If it is impossible, EssBase connector scheduled to be released?
Dezzsoke
Contributor III
Contributor III

I'd like to do the same.
Anonymous
Not applicable
Author

Hi,
Please vote for the feature jira issue https://jira.talendforge.org/browse/TDI-5548
Best regards
Sabrina
Anonymous
Not applicable
Author

I know a consulting company which has made such connector and I know there are some attempts to build new independent Open Source adapters but so far there is no component available to do this job.
Mostly Essbase will be filled with MaxL scripts and read out in the same way. 
Dezzsoke
Contributor III
Contributor III

So ESSBase is like SAP, has its own programming language, and interface, and we need to use that to get the data?
We need to create a copy of that db, so executing SELECT * queries is a must.
Anonymous
Not applicable
Author

Essbase is an OLAP tool and accepts MDX queries. If you need to unload the whole data you will probably get a very huge amount of data because of the amount of dimensions and the necessary cross products.