Oracle Data Integration

E-mail Print

 

Oracle Data Integration delivers pervasive and continuous access to timely and trusted data across heterogeneous systems. Its comprehensive capabilities include real-time and bulk data movement, transformation, bi-directional replication, data services, and data quality for customer and product domains.

 

 

Why Oracle?

Oracle’s products are designed to deliver maximum performance with lower cost of ownership, ease of use, and reliability. Oracle’s data integration solutions are certified for all leading technologies to deliver fast time to value. Customers report 80% lower TCO, five times higher performance, and a 70% reduction in development costs.

BULK DATA TRANSFORMATION AND INTEGRATION

Oracle offers unique, next-generation Extract Load and Transform (ELT) technology that improves performance and reduces data integration costs—even across heterogeneous systems. Unlike conventional Extract Transform and Load (ETL) tools, Oracle delivers the productivity of a declarative design approach and the benefits of an active integration platform for seamless batch and real-time integration.

>Oracle Data Integrator Enterprise Edition

  • High-performance bulk data movement and data transformation
  • E-LT architecture for improved performance and lower TCO
  • Heterogeneous platform support for enterprise data integration
  • Knowledge modules for optimized developer productivity and extensibility
  • Service-oriented data integration and management for SOA environments

REAL-TIME DATA INTEGRATION AND REPLICATION

Oracle GoldenGate products offer real-time data integration, transactional data replication, and data comparison across heterogeneous systems. Oracle GoldenGate enables real-time business intelligence for improved business insight, query offloading to maximize OLTP performance, zero-downtime data migration, disaster recovery, and active-active database synchronization for continuous availability.

>Oracle GoldenGate

  • Log-based change data capture, distribution, transformation, and delivery
  • Support for heterogeneous databases and operating systems
  • Bidirectional replication without distance limitation
  • Transactional integrity
  • Reliable data delivery and fast recovery after interruptions

>Oracle GoldenGate Veridata

  • Perform high-speed data comparison while data sources are online
  • Verify data consistency across heterogeneous, large-volume databases
  • Selectively compare datasets with little impact on the infrastructure
  • Get details on tables, rows, and columns that are out of synch

>Oracle Management Pack for Oracle GoldenGate

  • Web-based interfaces for increased visibility into Oracle GoldenGate components
  • Automatic solution discovery and customizable views
  • Real-time feedback and alert notification on Oracle GoldenGate processes
  • Email, SNMP, and third-party integration
  • Centralized command and control

>Oracle GoldenGate Application Adapters

  • Deliver real-time change data to Flat Files, JMS Messages and Java APIs
  • Capture data in real-time from JMS messages and deliver to databases
  • Provide out-of-the-box templates, and samples for third-party systems
  • Use a simple Java API for customization and integration into your existing code
  • Plug into Oracle GoldenGate architecture for management and monitoring

DATA QUALITY

Oracle enables organizations to measure, improve, and manage the quality of data from any domain, including customer and product data, and minimize exposure to risk. Our data quality products provide powerful data profiling, cleansing, matching, and monitoring capabilities, unparalleled ease of use, and integration with Oracle Master Data Management.

>Oracle Enterprise Data Quality

  • Offers best-of-breed data quality techniques for customer and product data
  • Supports business-oriented user interfaces with modern, open architecture
  • Standardizes, match-merges, analyzes, and cleanses enterprise data
  • Provides customized dashboards to view data changes over time