Real-Time Data Integration and Heterogeneous Database Replication.....

As data volumes grow at an exponential rate, many organizations are looking at ways to leverage big data as an advantage to their business. However research indicates that most organizations do not think they are prepared to leverage the enterprise data that they have. Data velocity in particular, seems to be a key challenge in handling big data. In a recent study by Aberdeen Group that surveyed 247 executives 53% of respondents said that too much crucial information is delivered too late1 .

Today data is generated at a much faster rate due to online transactions taking place anywhere and anytime, as well as due to the increased number of devices, along with the increased connectivity and communication between these devices, also called “the Internet of Things”. Most of this data, though, loses its inherent value very fast by becoming less relevant and less effective in influencing operational decisions— unless it is integrated, analyzed and consumed almost immediately.

To extract value from such perishable data in a dynamically changing environment that includes a diversity of sources, both on cloud and on premises, organizations need to capture, analyze and act upon them in near realtime. In addition they need to ensure that their systems can run uninterrupted to support customers 24/7 with reliable data meaning without experiencing interruptions in data availability, sluggish application performance, or stale data. There are four aspects to this challenge.

» Availability. Business-critical applications and underlying data must be accessible at or near 24/7/365 without service interruption or performance degradation

» Reduced latency. Data must remain fresh. As it ages, data becomes less relevant and less valuable—day-old data is often insufficient in today’s competitive landscape.

» Heterogeneity and IT flexibility. Integration and replication solutions must have the flexibility to be easily modified and distributed across diverse IT systems including on premises and cloud environments.

» Transaction integrity. Data completeness and accuracy must be ensured as it is moved between systems. In short, companies need a platform that allows business applications to benefit from continuous access to realtime information in diverse IT environments, without compromising performance and data integrity or demanding significant resources to deploy and manage.

Oracle GoldenGate 12c empowers organizations to capture, route, transform, and deliver transactional data between heterogeneous databases and applications in real time with minimal overhead. Using unique real-time, log-based replication technology, Oracle provides high availability and real-time data integration solutions that enable the management and movement of transactional data across the enterprise. Oracle GoldenGate is designed for low-impact and easy implementation, operation, modification, and extension to support the evolving needs of enterprise information management.