June 6, 2005 at 9:13 am
Has anyone out there found a way to connect to Essbase through ODBC, OLEDB, etc.? I have a new project that requires I bring information from Essbase into SQL. The obvious answer seems to be:
-Create Excel spreadsheets that pull the information from Essbase:
(Caveat - the Excel/Hyperion definitions would need to be part of the VBA code so new business unit, account (or any other sub-cateogry) will be pulled into the output).
-Setup DTS to read the Excel sheets and build SQL tables based on that.
Unfortunately, I don't know Excel very well, and I'm certainly not familiar with its VBA interface (although I know some VB6). Accordingly, I am really trying to keep the whole project in SQL.
Any suggestions?
June 6, 2005 at 10:37 am
I guess you have to first find out what version of EssBase you are connecting to. EssBase is a proprietary database format and as such little is public knowledge about it. I heard recent versions are more 'open' but EssBase is a 'black box'. You pretty much have the use the tools they provide - and they use spreadsheet import and export alot - so I would suggest using that. Let's say you did figure it all out... in future versions they WILL change their structure and then all you efforts must be done again. Not much help, sorry you have to work with Hyperion! Bret
June 7, 2005 at 7:55 am
Essbase, being an OLAP database, is very often fed from some other structured data source. It may be easier to go to that source rather than the Essbase datastore itself.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply