Real-Time Data Integration for Data Warehousing and Operational Business Intelligence
Data warehouses are used for more than just strategic reporting, analytics, and forecasting. Today, incorporating business intelligence into operational decision-making enables organizations to optimize business performance throughout the day. However, to achieve those efficiencies, data must be provided in real time. The demand for low-latency data is causing IT organizations to evaluate a range of approaches: intraday batch extract, transform, and load (ETL) processes; mini-batches; enterprise application integration (EAI); extract, load, and transform (ELT) technologies; and real-time change data capture (CDC). The challenge is to determine what solution or combination of solutions will meet the need for current data, which will propel the move to operational data warehousing. This white paper addresses the business reasons to move to real-time data warehousing and describes the common data integration approaches, with an emphasis on using real-time CDC capabilities and Oracle’s data integration offerings in that area -- including Oracle GoldenGate 11g and Oracle Data Integrator Enterprise Edition 11g.