GoldenGate provides a leading Transactional Data Management (TDM) solution for capturing, routing, transforming, delivering, and verifying transactional data in real time across major databases and environments.
Businesses increasingly must be able to access, analyze, act on, and verify data transactions faster than ever, often in real time — and without system interruption or downtime. That must account for three major components:
|
1. |
The exponential growth in transactional data volumes. |
|
2. |
The need to store, manage, and account for such data. |
| 3. |
The need to work within heterogeneous, cross-platform, and distributed IT environments. |
The GoldenGate TDM solution allows high volumes of transactional data to be moved across different platforms and between heterogeneous databases, even bi-directionally, with sub-second latency and with 100% accuracy, reliability, and integrity. As a result, customers can maximize the performance, accessibility, and availability of the transactional data that drives their mission-critical business processes.
Transactional Data Management
Most business activity, whether with customers, partners, employees, or other parties, is conducted as transactions. Common transaction examples would include online bill paying, in-store purchases, returning an item, placing an order for shipping, updating account information, and making reservations.
Businesses and users are leveraging technology to interact and conduct transactions in increasing numbers of ways, such as through Web applications, wireless devices, ATM networks, distributed Point-of-Sale systems, distributed computing environments, automated phone systems, and many more avenues. As a result, an overwhelming majority of business transactions is executed digitally.
Those transactions are represented in the database as a data transaction. Those data transactions collectively are also known as transactional data.
Because the volume of transactional data is growing exponentially, with 90% of all new information in digital form, businesses must be able to access, analyze, and act on that data faster than ever. Those trends are driving requirements in key areas, including:
| Reduced latency |
Real-time data is no longer a luxury but a competitive necessity that more and more organizations are coming to expect. |
| Heterogeneous support |
Data must be integrated across a variety of databases and platforms. |
| Transaction Awareness |
Since the vast majority of new data being created is transactional in nature, the completeness, accuracy, and reliability of transactional data must be guaranteed. |
For the IT organization, this means that there should be a solution in place that can facilitate the efficient movement of data in real time across any mix of database systems and platforms. In most businesses cases, there is no need to move all of the data from one database to another on a constant basis, because not all of the data changes. Instead, it is ideal to move only the new and changed data – transactional data – in order to give target systems the most current view of activity.
GoldenGate and Transactional Data Management:
TDM provides guaranteed capture, routing, transformation, delivery, and verification of data transactions across heterogeneous environments in real time.
GoldenGate Software is the market leader in Transactional Data Management (TDM) solutions. GoldenGate's TDM technology meets those needs, allowing high volumes of transactional data to be moved across different platforms to target databases -- with sub-second latency and with 100 percent accuracy, reliability, and integrity.
Benefits of using GoldenGate's TDM technology:
| Reduced latency |
GoldenGate enables continuous (not batch) movement of data from sources to targets at sub-second speed, with exceptionally high performance even at high volumes and with minimal impact on the IT infrastructure. |
| Heterogeneous support |
GoldenGate bridges legacy, relational, open systems, and data warehouses residing on different platforms. It supports versatile topologies and provides open APIs for further customization and extensibility. |
| Transaction Awareness |
GoldenGate ensures transactional integrity and availability as data is moved between systems. |
Click here for more about key technology features
GoldenGate Solutions
GoldenGate Software's Transactional Data Management (TDM) solutions enable our customers to effectively maximize the performance, accessibility, and availability of the transactional data that drive their mission-critical business processes.
GoldenGate’s TDM platform can be leveraged across the enterprise for any number of business-critical initiatives, including:
GoldenGate Solutions for High Availability and Disaster Recovery Projects
Today's business continuity plans require that stringent recovery time and recovery point objectives are met - minimizing downtime in the event of a disruption and eliminating data loss whenever possible. In the meantime, the high availability and disaster recovery solution should not impose unmanageable burdens on the data source and targets.
By leveraging GoldenGate for High Availability and Disaster Recovery, companies meet the most demanding service level requirements and data availability criteria. GoldenGate's Transactional Data Management (TDM) helps eliminate downtime and minimize data loss through solutions that include:
GoldenGate Live Standby
For meeting the most demanding recovery time and recovery point objectives, primary and secondary servers can concurrently process data transactions. Live Standby provides two major benefits. First, if one of the systems fails, the other system is readily available to take over, making the failure invisible to end users and eliminating outages. Second, because both the primary and secondary systems can service the business needs under normal operating conditions, companies maximize the return on their hardware investments. Also with GoldenGate Live Standby, companies can avoid downtime during software, database, and even operating system upgrades. |
GoldenGate Disaster Recovery
This high-availability implementation addresses disaster recovery needs, by ensuring that transactional data from a source system is delivered to a backup system that remains inactive until failover. Because GoldenGate captures and applies transactional data in real time, stringent recovery point objectives can be met. |
GoldenGate Real-Time Vaulting
With this GoldenGate solution for minimizing or altogether eliminating data loss, businesses can store their transaction activity across networks and at off-site locations -- with no distance limitations. |
| Key Features of GoldenGate's TDM for High Availability and Disaster Recovery: |
| · |
Real-time data capture and delivery |
| · |
Minimized data loss |
| · |
No distance limitations |
| · |
Distributed deployment support (network and geographic) |
| · |
Point-in-time/selective recovery and roll-back |
| · |
Heterogeneous systems and platform support |
| · |
High performance even with high volumes of transactional data | |
GoldenGate Solutions for Data Integration Needs
Through Transactional Data Management (TDM) solutions, GoldenGate offers real-time data integration when batch processing and outage windows are not sufficient to meet business needs.
GoldenGate's TDM solutions for Transactional Data Integration include:
GoldenGate Real-Time Data Integration
For enterprise applications that need to share and utilize real-time transactional data, GoldenGate allows companies to replace batch processing and minimize dependencies on maintenance (outage) windows.
GoldenGate Active Data Warehousing
GoldenGate enables bi-directional data flow between data sources and the data warehouse. In this setting, transactional data is captured and sent to the data warehouse, and from there, business decision data is captured and delivered back to the transaction processing systems (or to operational data stores).
GoldenGate Zero-Downtime Migrations
As companies move to migrate or upgrade databases, applications, or operating systems, GoldenGate provides a solution that eliminates downtime. Once GoldenGate ensures the new system is up-to-date with the older, soon-to-be replaced system, data transactions from the older system continue to be captured and delivered to the new system in real time until the cutover is completed. The result is a seamless migration for the company and end users.
| Key Features of GoldenGate's TDM for Transactional Data Integration: |
| · |
Real-time selective data capture and delivery |
| · |
Data transformation |
| · |
Guaranteed integrity of data transactions |
| · |
Heterogeneous system and platform support |
| · |
High performance even with very high volumes |
| · |
Distributed deployment support (network and geographic) |
| · |
Dynamic and selective rollback capabilities | |
GoldenGate Solutions for High-Performance Distributed Computing
GoldenGate Software Transactional Data Management (TDM) can support the needs of high-performance, distributed computing applications and initiatives. GoldenGate's capabilities allow for unparalleled scalability through real-time delivery of data transactions across applications in heterogeneous environments.
GoldenGate's TDM solutions for High-Performance Distributed Computing include:
GoldenGate Live Reporting
Because GoldenGate lets customers off-load their analytic processing activities from transaction processing systems to reporting environments, businesses can implement real-time reporting without impacting their operational systems. Real-time transactional data is captured and delivered to the reporting systems, to support up-to-date reporting capabilities.
GoldenGate E-Business Grids
With this GoldenGate solution, businesses can achieve unparalleled scalability in transactional data sharing across the data infrastructure, to support high-volume e-business applications. This solution allows companies to implement database tiering across legacy, commercial, and open-source databases. For example, specified transactional data can be off-loaded from HP Nonstop systems to lower-cost MySQL databases running on Linux.
| Key Features of GoldenGate's TDM for High-Performance Distributed Computing: |
| · |
Real-time data capture, transformation, and delivery capabilities |
| · |
Distributed deployment support (network and geographic) |
| · |
Versatile and highly scalable |
| · |
Heterogeneous systems and platform support |
| · |
High performance even with high volumes of transactional data |
| · |
Guaranteed transaction integrity |
| · |
Extensible, with support for customization through open APIs | |
GoldenGate Transactional Data Management: Key Features
GoldenGate's Transactional Data Management (TDM) technology features a unique architecture that allows for real-time transactional data management across heterogeneous environments. The platform consists of decoupled modules that are combined to create the best possible solution for business requirements, whether it is high availability and disaster recovery, data integration, high-performance distributed computing, or compliance projects.
How the TDM technology works:
| · |
Capture Transactional Data -- GoldenGate uses its "Capture" process modules at any number of source systems in the configured solution. GoldenGate Capture modules read data transactions as they occur at the source systems. |
| · |
Advanced Queueing -- GoldenGate converts the captured data into a universal format so that transactional data can be moved across heterogeneous environments. With the advanced queuing features, GoldenGate eliminates any single point of failure and ensures data integrity is maintained even in the event of failures. |
| · |
Delivery -- GoldenGate delivers and applies captured data to a wide selection of data targets with efficiency and speed. In bi-directional configurations, this capture-delivery-apply process runs concurrently between the source and target systems. |
| · |
Real-time TDM -- GoldenGate's architecture enables sub-second latency, so that data can be kept consistent across multiple databases. |
Key features include:
| Log-based extraction |
Our technology is designed to read the native database transaction logs directly, enabling advanced changed data capture with high performance and minimum impact to source systems. |
| Data transformations |
Users can map, enrich, translate, and transform transactional data in real time as it is captured or applied to target systems. |
| Routing |
The delivery of data is done efficiently and flexibly across systems and network locations. This feature also enables users to support various topologies, such as one-to-one, many-to-one, one-to-many, many-to-many and bi-directional movement of data. |
| Dynamic rollback and selective recovery |
GoldenGate's architecture provides capabilities for point-in-time and selective recovery. |
| Advanced conflict detection and resolution |
In multi-master environments, customer business rules can be implemented to detect and resolve conflicts automatically. |
| Compression and encryption |
These features reduce bandwidth and provide security advantages for highly distributed environments. |
Download the GoldenGate TDM Data Sheet
GoldenGate Veridata™
GoldenGate Veridata is a high-speed data comparison solution that identifies and reports data discrepancies across systems without interrupting business processes.
Veridata reduces the amount of time and resources required to compare data, eliminates introduction of human errors, and ensures that potential problems are instantly identified and addressed.
Veridata processes selected data sets at unparalleled speeds. The user selects pertinent tables or fields on the source and target databases and starts the comparison with a few simple clicks. As the data on the source and target change, Veridata reports persistent discrepancies and identifies records that are in-flight. Based on their own business requirements, users have the power to determine how to handle this in-flight data.
Whether used for compliance, testing or troubleshooting, GoldenGate Veridata offers a non-intrusive architecture that can handle large and dynamic data sets and allows the user to selectively compare datasets without interrupting day-to-day business operations.
Request More Information
View Upcoming and Archived Webcasts
Download the GoldenGate Veridata™ brochure
GoldenGate Director™ -- Manage TDM Deployments
GoldenGate Director allows organizations to easily manage their GoldenGate Transactional Data Management (TDM) deployments. As an optional add-on for new or existing GoldenGate customers, GoldenGate Director is a server-based product that features an intuitive graphical interface for centrally designing, configuring, managing, monitoring, and reporting on the GoldenGate processes implemented across your business.
GoldenGate Director gives customers:
| · |
Centralized configuration, management, and monitoring of GoldenGate TDM solutions |
| · |
Rich-client and Web-based interfaces for increased visibility into GoldenGate processes |
| · |
Alert notifications and integration with third-party monitoring products |
| · |
Real-time feedback on GoldenGate processes |
| · |
Zero-impact implementation that retains the unparalleled performance of GoldenGate TDM solutions |
GoldenGate Director utilizes the GoldenGate Management Services architecture to communicate with, control, and monitor GoldenGate processes, and it runs transparently on top of those processes with no impact on solution performance. In addition, GoldenGate Director can be integrated with third-party monitoring solutions that may be part of a customer's existing investment.
With the addition of GoldenGate Director, users can improve the productivity and responsiveness of the IT staff, leverage existing infrastructure to maximize their return on investment, and reduce the time to production of essential TDM solutions for High Availability and Disaster Recovery, Transactional Data Integration, High Performance Distributed Computing, and Compliance.
Download the GoldenGate Director Data Sheet
GoldenGate and BASE24
GoldenGate has developed add-on product modules for ACI’s BASE24 electronic funds transfer product for the banking, retail and e-business industries. ACI also has chosen to embed GoldenGate in BASE24-es™, the next-generation implementation of ACI's world-class payments platform, to address business availability, data protection and business visibility.
GoldenGate modules for BASE24 include:
| · |
GoldenGate E24 – Super-Extract Real-Time Feed – Automatically captures, transforms, and delivers BASE24 transactions in real time to settlement systems, including platforms based on Oracle, Sybase, MySQL and other databases. This reduces the overall batch processing time previously required, and data no longer sits on tape for hours at a time. |
| · |
GoldenGate M24 – “Zero-downtime system migrations” – Enables system administrators to load new databases during BASE24 upgrades while the application remains active on the production system. |
| · |
GoldenGate T24 – “Moving Tokenized Data into a Structured Format” – Resolves problems with moving tokenized or segmented data to other platforms and databases. The user defines which token data areas to capture, organize, and output, and additional mapping and transformation functions are still available. |
| · |
GoldenGate D24 – “Dual Site Processing for High Availability” – Allows transactional data to be synchronized bi-directionally in real time throughout the day. In the event of an outage on one system, the full transaction load will be processed on the remaining machine, ensuring continuous availability. Lets customers take advantage of the ACI Dual Site enhancement for BASE24 6.0 version 4. |
Dual Site Support using GoldenGate
In order to meet the requirements of the increasing number of customers wishing to implement a dual-site production environment, GoldenGate and ACI Worldwide joined forces and designed a standard product solution. To support this design, ACI Worldwide has introduced additional functionality to version 4 of BASE24 6.0.
ACI defines a dual site production environment when production transactions are split between two separate HP NSK machines, with any single machine capable of handling all transactions. The bi-directional replication of configuration, customer and transaction data between the two sites is fundamental to provide contingency of a dual site system.
The enhancements made available in Release 6.0 version 4 facilitate dual site operation in conjunction with a third party product such as GoldenGate. GoldenGate is used to undertake the replication of transactions or data between the two sites and the enhancements to BASE24 6.0 are intended to provide support for processing options that will allow and simplify the configuration and operation of a dual site environment.