cancel
Showing results for 
Search instead for 
Did you mean: 

Complete newbie question - Can BI consume web services?

Former Member
0 Kudos

Post Author: Steve Lamont

CA Forum: Data Integration

I am working on a new client site working on integration between a whole slew of systems including CRM, billing, BI etc. The client is architecting a SOA oriented approach to all integration where it make sense. As part of the effort, a new BI database is being built and loaded via some ETL tool. The primary interface to access this new BI data will be business objects (BO). Now, in the current environments, there are multiple, disparate BI systems containing various data. The BO knowledge person (and he is not a business object employee) on this site is claiming that to access these other BI databases, he wants to do it by sending out requests via service calls. I fully understand that BO itself can be set up to be a service provider and provide services for other consumers to take advantage of, but how does BO itself consume services provided by other applications?

Obviously I don't fully understand BO, but my initial inclination is that this approach is wrong. If data is required from these other BI source, wouldn't they be configured as data sources within business objects? This BO guy claims that calling web services is more efficient that direct peer-to-peer calls via the database drivers.

Can any share some comments on this situation?

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Post Author: bhofmans

CA Forum: Data Integration

You posted your question to the wrong forum, please try to post it to one of the subforums in "Enterprise Reporting, Query & Analysis".

This forum is about Data Integrator, Business Objects ETL tool.

I'll try to answer your question anyway with my reporting background From what I know, YES we can consume web services in reports (Crystal reports), but for larger volumes of data a direct access to the database would be faster. A webservice approach might make sense if the webservice implements some business logic (semantic layer) which would be easier then to go directly to the tables.

And just for the record : also Data Integrator can consumer web services...