Following are just a few example scenarios in which we can help you leverage GoldenGate technology into working solutions.
Data Warehousing and Data Integration
- optimizing batch load and ongoing synchronization
- streamlining and integrating ETL/ELT processes
- utilizing in-database functions for transformation and delivery
- integrating non-relational and relational data
- automatic data mart/ODS/staging database creation tools
- real-time data quality
High Availability and Data Migration
- data and application migration solutions with near zero downtime
- coordination of application switchover with replication processing
- measuring exposure to outages
Performance Optimization and Management
- maximizing throughput
- latency analysis
- troubleshoot persistent issues and bottlenecks
- holistic analysis – system, network, database, disk
- capacity planning
- distributing capture, apply processes for optimal fault-tolerance and load balancing
Replication Topologies
- active-active
- one-to-many, many-to-one, many-to-many
- conflict detection and resolution strategies – automatic, database driven
Archive and Search Solutions
- transactional archive solutions for record retention and compliance
- heterogeneous “total recall” solutions – enable point-in-time queries against historical and current data
Load Balancing
- economical scale-out solutions – one to many heterogeneous replication to segment transactional and read-only activity to appropriate platforms
- creating real-time reporting databases
- maintaining cache
Custom Data Sources and Targets
- database change data capture – journals/logs
- file system intercepts for non-relational data
- xml, ascii, MQ, JMS input and output
- custom replication for unsupported database platforms
Database Recovery Strategies
- building custom backout scripts
- selective rollback and rollforward analysis and implementation
- n-way failover scenarios
- dealing with leftover transactions
Verification Strategies
- verifying replication is performing as expected
- batch verification using Veridata
- online verification strategies