topic Re: Essbase in Talend Studio

Essbase

Anonymous — Sat, 16 Nov 2024 13:14:53 GMT

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

Re: Essbase

Anonymous — Thu, 11 Aug 2011 05:19:00 GMT

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?

Re: Essbase

Dezzsoke — Tue, 09 Sep 2014 14:33:41 GMT

I'd like to do the same.

Re: Essbase

Anonymous — Wed, 10 Sep 2014 04:44:42 GMT

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

Re: Essbase

Anonymous — Wed, 10 Sep 2014 07:00:08 GMT

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.

Re: Essbase

Dezzsoke — Wed, 10 Sep 2014 12:00:11 GMT

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.

Re: Essbase

Anonymous — Wed, 10 Sep 2014 15:41:05 GMT

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.