BO to Qlikview

[Anonymous]

Hi All,

We need to Extract data from BO universe into qlikview. No connector available for this option.

Please let me know any method for accessing BO Universe.

Thnks in advance.

[#2]

how about extracting to excel first, and then load that?

[chriscammers]

How about using Query as a web service as your data source? You'd have to predefine your query in the QAAWS builder and figure out how to authenticate to BO's security. I have not dealt with BO since XI3.1 so some of this may be out of date, but at the time getting data into Xcelsius worked well with QAAWS and may be applicable with Qlikview.

Fortunately the universe does not really contain any data so if you were to build the Query in WEBI and extract the SQL code then you could very easily use it in Qlikview, with some exceptions. the main drawback to extracting the sql would be that if the Unverse changed then you would not pick up that change .

[#4]

DataRoket has a QlikView connector for all BO Universe data.  Connecting directly, at the report level, in-memory and more.  Let us know if this meets your needs.  http://tinyurl.com/3har8tl