GoldenGate Software, Inc. - the leader in Transactional Data Management

DATA INTEGRATION SOLUTIONS: REAL-TIME CHANGE DATA CAPTURE FOR ETL

Utilize Real-Time Data While Maintaining Your ETL Investment

Companies increasingly want up-to-date information to make quick and accurate decisions about their business. In order to enable such operational Business Intelligence in today's competitive world, many companies need real-time information, and are finding that solutions involving intra-day ETL (extract-transform-load) or mini-batch ETL are insufficient and problematic to deploy.

In addition, with more businesses operating 24x7, the batch windows required by traditional ETL systems to extract data from source OLTP systems negatively impact operations. This creates a challenge for IT groups who want to decrease data latency and/or eliminate batch windows, yet leverage the significant investment already made in their ETL solution due to heavy transformation requirements.

GoldenGate's Real-Time for ETL solution leverages change data capture (CDC) technology and provides real-time capture, routing, transformation, and delivery of transactional data with minimal impact on production source systems. Real-Time for ETL solutions from GoldenGate enable real-time, continuous changed data feeds to the ETL server to enable fresh business intelligence without batch windows.

KEY BENEFITS:

Provides a real-time transactional CDC solution to complement ETL
Eliminates batch windows
Allows organizations the flexibility to leverage existing ETL investments
Offers negligible impact on production systems
Supports multiple ETL and "ELT" tools from leading vendors
Easy implementation, customization, and maintenance

GoldenGate also provides solutions for direct, continuous real-time feeds from source systems into the target data warehouse or reporting database, without the need for a middle-tier ETL server. Read more about our Real-Time Data Warehousing solution.

RESOURCES:

• White Paper: Augmenting ETL Systems with GoldenGate's Change Data Capture Capabilities: View the detailed abstract | Download the PDF

• Web Seminar: "Real-Time and ETL: When Opposites Attract" - Play the on-demand webcast now

"Transforming BI from Reactive to Proactive: DIRECTV Shares its Winning Data Warehousing Strategy"
Learn in this on-demand webinar how DIRECTV combines GoldenGate's real-time data integration change data capture solution with a Teradata Warehouse to achieve operational BI that improves customer service. Playback now

Case Study: Oracle uses GoldenGate to ensure seamless migration with minimal downtime for Siebel CRM On Demand and its hosted customers. Download PDF.