Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
cs_bhimavarapu
Starting Member
23 Posts |
 Posted - 2003-11-07 : 11:37:52
|
| I need to pull only a tiny fraction of data from Essbase database / cube. I am planning to use DTS to pull data and store it into the SQL Server tables. I am now seaching for a driver for Essbase as datasource. Could some one help if they already handled a similar requirement and had a better solution. Also, I would like to know the driver if there is one available.Thanks allChandra |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-11-07 : 12:03:53
|
| I have never even heard of Essbase. Your best bet is to go to the vendor's web site.Tara |
 |
|
|
cs_bhimavarapu
Starting Member
23 Posts |
Posted - 2003-11-07 : 12:18:57
|
| Essbase Analytic ServicesAnalytical processing is the engine that creates the shared information for business performance management. Essbase Analytic Services provide the processing power, scalability, performance, manageability, and security needed for delivering information to a broad class of users accountable for corporate performance, including executives, operational managers and front-line workers anywhere in the extended enterprise.URL: www.essbase.comI haven't had any luck there.... |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-11-07 : 12:29:09
|
| I doubt you'll have any luck here either. I would suggesting contacting the vendor by e-mail or by phone to find out if they have any drivers for this. Maybe they've got some export utility which allows data to be exported to files. If that's the case, then you wouldn't need the drivers since DTS can already import data from files.Tara |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2003-11-07 : 13:21:52
|
| I found"There is an ODBC connection for Essabse coming with v7.0, which is tobe released sometime later this year - it is currently in beta."No idea if it's true.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2003-11-10 : 10:41:56
|
| We have some ESSBASE operations, and my colleagues say that we're using a combination of 2 products to manipulate the data.Hyperion API's are used with Excel for read/updating local data.andADL Essbase Pipeline is used to pump data into/from ESSBASEADL has an inbuilt route into ESSBASE (it doesn't use ODBC) and is very fast...but isn't very sophisticated to work with. Input/output data outside ESSBASE is typically flat files.The Hyperion stuff is an Excel Add-in, which presents API's to the user to work with the data via VBA. |
|
|
|
|
|
|
|
|
Connecting to Essbase.....