dbTalk Databases Forums  

Connecting to Business Objects and extracting data

comp.databases.olap comp.databases.olap


Discuss Connecting to Business Objects and extracting data in the comp.databases.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
denzel
 
Posts: n/a

Default Connecting to Business Objects and extracting data - 10-24-2006 , 08:59 AM






Hello,

is there a way to connect to a "Business Objects" data storage in order
to retrieve OLAP data?

For Oracle, you have to use the Oracle OLAP java api, which enable you
to connect, read meta-data (hierarchies, etc.), perform complex SQL
request with "simple" java method calls, and convert the result table in
POJO (Plain Old Java Objects).

I would like to do the same for "Business Objects". But i can't find
anything on Google about extracting data, only importing into BO.

TIA

Reply With Quote
  #2  
Old   
Nigel Pendse
 
Posts: n/a

Default Re: Connecting to Business Objects and extracting data - 10-24-2006 , 10:37 AM






That's because BusinessObjects is a reporting tool, not an OLAP
database. Apart from cached report contents, it doesn't store
information.

"denzel" <denzel (AT) invalid (DOT) domain> wrote

Quote:
Hello,

is there a way to connect to a "Business Objects" data storage in
order to retrieve OLAP data?

For Oracle, you have to use the Oracle OLAP java api, which enable you
to connect, read meta-data (hierarchies, etc.), perform complex SQL
request with "simple" java method calls, and convert the result table
in POJO (Plain Old Java Objects).

I would like to do the same for "Business Objects". But i can't find
anything on Google about extracting data, only importing into BO.

TIA



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.