One Star

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
6 REPLIES
One Star

Re: Essbase

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?
Four Stars

Re: Essbase

I'd like to do the same.
Moderator

Re: Essbase

Hi,
Please vote for the feature jira issue https://jira.talendforge.org/browse/TDI-5548
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Seventeen Stars

Re: Essbase

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. 
Four Stars

Re: Essbase

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.
Seventeen Stars

Re: Essbase

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.