Data coming into the organization from various business applications must be integrated quickly so that additional business processes and decisions can be executed in a timely, accurate manner. And because applications increasingly are serving users on a 24x7 basis, new information is always arriving and it becomes impractical to impose any outage in the overall IT process.

As a result, the IT group must drive down the latency in integrating that new information with other enterprise systems, such as with data warehouses, reporting systems, data stores, or other OLTP-supporting databases. For more critical and revenue-generating data, batch loading that data nightly or even several times per day is no longer sufficient for many leading companies -- new data needs to be integrated faster, often within hours, minutes, or even seconds.

Companies generally rely upon traditional data integration technologies, such as ETL products or home-grown scripts, to periodically move large volumes of data to a target system. This requires outage windows and imposes significant overhead on the IT systems involved, which makes these solutions unable to operate in real time.

Design for Real Time
GoldenGate Software, leveraging its Transactional Data Management (TDM) software platform, delivers excellent solutions that enable the continuous, real-time capture, routing, transformation, and delivery of data transactions across heterogeneous environments. End to end, once new data is committed at the source system, it is applied to the target systems with only sub-second latency. With less data being moved at any given time, this means less burden on the infrastructure.

GoldenGate offers several key advantages over other data integration solutions, including:

• Continuous, real-time data movement
• No need for batch outage windows
• Significantly lower impact and overhead on source and target systems
• Eliminates need for middle-tier ETL server
• Flexibility to apply transformations/mappings within the target database
• Easier to implement, customize, and maintain

Customers worldwide are increasingly implementing GoldenGate TDM to generate solutions for real-time data integration. Among the popular solutions from GoldenGate in this area are:

GoldenGate for Real-Time Data Warehousing -- GoldenGate enables the real-time movement of new transactional data from primary systems into the data warehouse, thereby making the most current data always available to drive enhanced business intelligence.

GoldenGate for Live Reporting -- Many reporting activities ideally seek to use the latest data available, and that often means running reports against production databases which in turn degrades performance on those systems. With GoldenGate, a secondary system is deployed to serve the purposes of real-time, "live" reporting, freeing up the resources of the critical source systems.

GoldenGate for Transactional Data Integration -- For point-to-point data integration needs, GoldenGate is ideal for moving data in real time with minimal impact and with an architecture that is substantially easier to customize and maintain as application requirements change.