Q: I work in Milan (UniCredit Group) as a business intelligence (BI) architect. We want to consolidate two different data warehouses (Italian DW plus German DW using in a unique data model). I'd like to know if it's correct to create a unique logical enterprise data model or is it more correct have a master data management plus service-oriented architecture (SOA) as the correct environment in order to permit query, reporting and analysis as a service?

Let's compare the two approaches: It is always great to have a unique enterprise model and consolidate the 2 DWs in order to create one global DW. However, this takes time and effort. On the other hand, the idea of having a services-based architecture to access this data is also compelling. However, in my opinion, the fundamental problem with SOA is that currently services are designed to retrieve or update atomic data (a small subset of records). I have not yet seen a robust services-based tool that is able to retrieve data for analytical purposes (thousands of records) and hesitate to build an enterprise level architecture around it until the tool is found.

Register or login for access to this item and much more

All Information Management content is archived after seven days.

Community members receive:
  • All recent and archived articles
  • Conference offers and updates
  • A full menu of enewsletter options
  • Web seminars, white papers, ebooks

Don't have an account? Register for Free Unlimited Access