Your Challenges

Data Integration

Golden Gate Logo

Oracle GoldenGate is a comprehensive software package for enabling the replication of data in heterogeneous data environments. The product set enables high availability solutions, real-time data integration,  transactional change data capture, data replication, transformations, and verification between operational and analytical enterprise systems. 

Business Need

Leading companies have recognized the importance of taking a strategic approach to data integration to reduce costs, enable business intelligence, and unlock operational efficiencies. Oracle offers a complete set of data integration solutions, including the following products. 

Oracle Goldengate

As Oracle’s solution for enterprise-wide heterogeneous real time data access and delivery needs, Oracle GoldenGate complements Oracle Data Integrator Enterprise Edition to provide the real time data integration required for real time business intelligence. By reading transaction logs, Oracle GoldenGate imposes minimal impact on transactional systems and maintains transactional integrity across databases. Oracle GoldenGate moves data with very low latencies in the most demanding operational and business intelligence environments.

Oracle GoldenGate is Oracle’s strategic solution for real time data integration. It enables non-invasive operational reporting and other types of query offloading by maintaining a real-time replica that can be on a different database platform and lower cost hardware. In combination with Oracle Data Integrator Enterprise Edition for transformation, Oracle GoldenGate makes real time business intelligence possible, allowing companies to combine insight about the current state with historical context. 

  • Real-Time access to real-time information
  • Disaster recovery solutions
  • Zero downtime database upgrades
  • One way or bi-directional replication between data centers
  • Heterogeneous solution for operating sytsems and database source and targets
  • Offloading performance overhead off production systems to increase system performance

Support and optimization for heterogeneous databases remains a critical part of Oracle’s strategy with the Oracle GoldenGate product. Heterogeneous database support for Oracle GoldenGate includes IBM DB2, Microsoft SQL Server, Teradata, Netezza, Enscribe, HP NonStop SQL, and others. 

Oracle Data Integrator Enterprise Edition    

Oracle Data Integrator Enterprise Edition delivers high-performance movement and transformation of heterogeneous data in batches and mini-batches for use in data warehousing, business intelligence, application integration, and service oriented architecture use cases.  Oracle Data Integrator Enteprise Edition utilizes heterogeneous databases to perform high speed complex data transformations and leverage existing resources.  With its flexible, modular architecture and declaritive design methodology, Oracle Data Integrator Enteprise Edition helps companies reduce total cost of ownership for data integration.  In addition,Oracle Data Integrator Enterprise Edition integrates with Oracle's and third party data quality products.

Oracle Data Integrator Enterprise Edition remains the strategic data integration product from Oracle for ETL, ELT, batch integration, mini-batch integration, and bulk transformation.  The changed data capture functionality included with Oracle Data Integrator Enteprise Edition is suitable for periodic, ongoing loads for data warehouse.

Recommended Data Integration Use Cases

  • Typical Data Warehouse Loading & SOA Use Cases: Oracle Data Integrator Enterprise Edition
    For typical batch-oriented data warehousing, Oracle Data Integrator Enterprise Edition (ODI-EE) is the recommended solution. ODI-EE extracts, loads, and transforms data for initial loads and incremental batch updates with set-based execution of complex transformations. It can also work with comprehensive data quality products such as Oracle Data Quality. ODI-EE is also the solution for bulk transformations in a SOA.
     
  • Data Synchronization, Query Offloading: Oracle GoldenGate
    Oracle GoldenGate is recommended for data synchronization use cases in which two systems are kept in sync bi-directionally and for use cases of moving database transactions from more expensive systems to less expensive, then running BI tools and other queries against the lower cost replica to reduce the load and cost on mission critical transactional systems. 
     
  • Combining Oracle GoldenGate and Oracle Data Integrator Enterprise Edition
    It is a powerful combination to use Oracle GoldenGate and Oracle Data Integrator together for real time business intelligence. Oracle GoldenGate captures database transactions from OLTP sources and propagates them in real time to a permanent staging area in an enterprise data warehouse, Then, ODI picks up the changes from the permanent staging area and performs transformation within the database to load into the optimized data warehouse schema. By combining information about the current business state with historical analysis and context, companies can drive informed business decisions throughout the day.

    There is no other solution available in the market that offers real time data integration and transformation within heteogeneous databases to enable real time business intelligence without additional server investment. 

 

PTi News

Predictive Technologies has completed Oracle Database and Oracle Golden Gate specializations with Oracle and is now finalizing implementation tests for Oracle Linux and OracleVM for a total of 5 Oracle Specializations. READ MORE

Industry Insight

The Oracle Critical Patch Update for October 2011 was released on October 18th, 2011. READ MORE

Contact Us

Need Help?

Twitter Feed