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?
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.
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.
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.