Operational Data Warehousing

The growth of today’s data volumes is exponential. This, combined with the increasing struggle for more immediate access to real-time information, is creating constant pressure on IT to respond and deliver quickly and with high efficiency. To optimize operational data warehousing efforts, enterprises are recognizing that high-performance data replication and change data capture (CDC) technologies are critical for business intelligence (BI) and data warehouse projects.

What all operational data warehouse projects have in common is the challenge of getting data from the transactional systems of the business into the structures of the data warehouse. Depending on the specific environment, as well as the complexity and number of source systems, this can be a time-consuming, costly and very difficult process.

Attunity Replicate and Attunity CDC, efficiently underpin data warehousing and real-time business intelligence by capturing and streaming data changes from operational systems as they happen. This results in up-to-date data and eliminates the need for periodic updates/batch jobs and their inherent data latency.

Attunity Replicate’s high-performance data replication capabilities enable the generation of files for quickly loading data warehouses. Attunity CDC leverages existing ETL tools and extends their functionality to support low latency data warehouses and operational data stores (ODS).