CODEWITHSUNDEEP
sqlsql-serverreporting-servicesssisbusiness-objects
CeeVei
CeeVei

Reputation: 95

use business objects as source to SSIS

I may be completely off-track, but is it possible to use BO universe as a Source to my SSIS/SSRS.

We've been given a task recently where we've to tap into BO to make SSRS reports. Can we do that?

And if need be can we use that as a source to SSIS for any further transformation.

Also - please help in providing link on how to do it. Google provided me only links where SQL is a source instead of destination.

Thank you for your help.

Upvotes: 1

Views: 1628

Answers (2)

DocZerø
DocZerø

Reputation: 8567

You can, if:

  • you can query the universe using the REST interface (i.e. web service)
  • you can consume the OData flow that is returned as the result set

For more information, have a look at SAP BusinessObjects BI Universe Connector Technical Guide.

There are some requirements regarding the version of BusinessObjects and the type of universe you're using:

  • SAP BusinessObjects BI 4.1 SP2 or later are supported
  • the universe has to be created with the Information Design Tool (i.e. have a .UNX extension)

The current limitations are described in the aforementioned article.

Upvotes: 3

Ciarán
Ciarán

Reputation: 3057

You cannot use Business Objects Universes as a data source in SSIS/SSRS. Universes do not contain data, they are simply an abstraction layer that generates SQL for reporting.

You also cannot link SSRS/SSIS to Business Objects to use universes to generate SQL for downstream use. The links simply do not exist.

Upvotes: 3

Related Questions