Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

SOA and Data Warehousing

2 posters

Go down

SOA and Data Warehousing Empty SOA and Data Warehousing

Post  DilMustafa Mon Jun 08, 2009 12:50 am

Hello everyone....

I need your help here. I am working on some DW related roadmaps. I am stuck on role SOA(Service Oriented Architecture) is going to play in Data Warehousing ETL in- particular and BI in-general. Your comments on above mentioned are much appreciated.




Posts : 49
Join date : 2009-02-03
Location : Calgary, Canada

Back to top Go down

SOA and Data Warehousing Empty Re: SOA and Data Warehousing

Post  ngalemmo Mon Jun 08, 2009 11:50 am

I really depends on what you are trying to do.

For traditional batch loading of a DW, using a SOA to implement it is incredibly inefficient and buys you absolutely nothing in terms of maintainability and flexibility. But, it may be worthwhile to implement a real-time data feed from web based/capable applications.

It is more useful as a means to provide data to custom applications, as it provides a secured, structured mechanism to expose data in a generic manner. However, if the intent is to implement BI using out-of-the-box BI tools, then a SOA doesn't help.

Thing is, there is not particular reason to commit to a SOA up front. The data warehouse is, after all, just a database. If a future need comes up that is best handled using services, it is easy enough to implement them without affecting the existing infrastructure.

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

Back to top Go down

Back to top

- Similar topics

Permissions in this forum:
You cannot reply to topics in this forum