SO BI IT or Service Orientation meets Business Intelligence
Business Intelligence (BI) and Service Orientation (SO) are two architectural paradigms that have been developed independently. In the Architecture Journal 6: There is a complete article about this new concept, which draw my attention since one my BI colleague mention it. So what is about; well BI and SOA together. That's thought did not cross my mind before. Currently I am working at Inter Access in a business-unit Microsoft & BI Solutions. I am working in the BizTalk, SOA, EAI space and doing interesting jobs/projects around it. Brainstorming with my colleague about this SOBI (BI with SO) concept is challenging. One important thing about SOBI is message size and frequency. When to use ETL or Services. The picture below, taken from the article says it all in my opinion and experience. Large messages, low volume (frequency) use ETL tool like (since I am a Microsoft guy) SQL Server Integration Services (SSIS) a component of SQL Server 2005. Message size versus message volume W