Case Study: AUTOonline achieves real-time BI and faster reporting with Attunity Oracle-CDC for SSIS

AUTOonline Enables Real-Time Business Intelligence With Attunity Oracle-CDC For SSIS And SQL Server 2008 R2

AUTOonline, an internet eCommerce network for marketing used vehicles, faced a challenge in delivering real-time business intelligence and up-to-the-minute vehicle information. Their main Oracle production systems were strained, and running queries for reporting risked harming the performance of their customer-facing web applications. To address this, they turned to vendor Attunity for a solution.

Attunity implemented its Oracle-CDC for SSIS data replication software to offload data from the Oracle databases. This solution uses log-based change data capture (CDC) to replicate data in real-time with low latency to a Microsoft SQL Server 2008 R2 BI platform. The results for AUTOonline included a 30% increase in report processing capacity, the ability to deliver real-time BI to management, and a significantly improved online experience for their customers and dealers.

AUTOonline

Kai Müller

IT Director