on 03-28-2007 6:13 PM
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?
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...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
10 | |
10 | |
9 | |
7 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.