For Information & Knowledge Management Professionals (Length: 12 pages)

Executive Summary (This is a document excerpt)

Data integration techniques such as extract, transform, and load (ETL); enterprise information integration (EII); change data capture (CDC); and even custom-coding play a significant and perhaps the most critical role in delivering operational business intelligence (BI) capability. The key issue for data architects and BI app developers to keep in mind is the need to map these data integration options against the primary characteristic requirements of operational BI apps, such as tolerance for latency, unique data sources, decision-making time frame, data volume and quality, and cost of ownership. Also note: Employing only one of these techniques may do more harm than good; you must look at the total picture.