Oracle GoldenGate - A solution for real-time data integration and continuous data availability

Most businesses now depend heavily on the availability of their Information and most critical business processes are IT based. Business Continuity is the ability to continue business under any circumstances and is an important requirement for most modern companies. So the main requirements in today's businesses are High Availability and Disaster Recovery of information.

Oracle GoldenGate enables high availability and disaster tolerance with core functionality that supports real-time data integration with minimal overhead and ensuring scalability. With this feature business-critical applications such as ticket booking, online banking and online shopping can continue to operate without any hurdles. Oracle GoldenGate allows real-time data movement between similar and heterogeneous source and target thereby enabling real-time BI solutions, zero downtime system upgrades, multi-directional data synchronization for distributed systems, disaster recovery and migrations between heterogeneous databases, OS platforms and Servers.

Main advantages of Oracle GoldenGate include:

* High Performance: Data can be moved with sub-second latency. Performance impact on source system and the network is minimized by capturing only the data that has been committed from transaction logs.
* Reliability: Transaction integrity is maintained while moving data from source to target using check-pointing mechanism. Using this, in case of network outages or interruptions data movement is resumed from the check-points. These features ensures data integrity which otherwise can severely impact business operations.
* Heterogeneity: Oracle Golden Gate supports a variety of common, open source and legacy databases on most platforms. It can be deployed unidirectional or bidirectional in multiple topologies. GoldenGate also provides the flexibility to move data between like-to-like and heterogeneous systems.

Oracle GoldenGate supports data integration between many common databases including:

* Oracle Database
* IBM DB2
* MySQL
* Microsoft SQL Server
* Teradata
* Sybase
* Enscribe
* SQL/MX

The Operating Systems that are supported by Oracle GoldenGate include:

* HP Nonstop
* AIX
* RedHat AS
* Solaris
* z/OS
* Windows
* HP-UX
* Oracle Linux

With the above features and its support to a vast range of databases and platforms Oracle GoldenGate can be considered a best-in-class solution to enable real-time data integration and continuous data availability.