Robotron Robotron ist Oracle Platinum Partner
Robotron Datenbank-Software GmbH

Oracle Middleware

...for Data Integration

Oracle Data Integration includes a rich set of data management products and components for data movement, reunification, quality, profiling and metadata management. The spectrum ranges from the Oracle database utilities to powerful tools for heterogeneous environments or for real-time integration and replication. These products have special meaning for extracting, transforming, and loading (ETL) of data sources into a Data Warehouse.

The Oracle Data Integrator provides comprehensive and continuous access to current and trustworthy data on heterogeneous systems. The detailed functions include real-time movement of data (even large amounts of data), transformations, bidirectional replication, data services and maintaining the data quality for customer and product domains.

In particular we primarily work with the following components:

  • Oracle Warehouse Builder (OWB)
  • Oracle Data Integrator Enterprise Edition (ODI)
  • Oracle GoldenGate

The OWB simplifies the design and loading of Oracle Data Warehouses and data marts. The OWB covers all the required tasks embedded to operate in a unified metadata management and a graphical user interface.

Characteristics:

  • server computer with a maximum of 2 sockets, ie slots for processors
  • minimum licensing of 5 users with Named User license metric
  • data modeling of Oracle target environment
  • data compliance, e.g. Data Profiling
  • data integration
  • data quality

The central OWB functionality is provided free of charge as part of the Standard and Enterprise editions of the database or Oracle Business Intelligence Standard Edition One. Oracle Warehouse Builder Enterprise ETL is an extension of the OWB multiple features.

The ODI is a unique technology for extracting, transforming, and loading (ETL) of data. It improves the performance and reduces the cost of data integration across heterogeneous systems. ODI is the strategic ETL tool Oracle and perspective (Oracle 12c Rel 2) Oracle Warehouse Builder (OWB) to replace. ODI includes connectivity to all major databases and applications. The user interface is easy to use and therefore helps to increase productivity and reduce development costs.

Overview:

  • high performance bulk data transmission and data transformation
  • ETL architecture
  • support of heterogeneous platforms
  • knowledge moduls for optimized developer productivity and expandability
  • service-oriented data integration and usage in SOA environments

Task:

ODI is the strategic platform by Oracle for successive and comprehensive data integration. With the ODI you can move and convert data in heterogeneous systems with excellent performance in batch or real time and in synchronous or asynchronous mode. The placement and design of the integration infrastructure is quick and easy, requiring none or only little programming effort.

Licensing conditions:

The number of licensed processors is determined from the number of processor cores and a processor factor.

A minimum of 25 users per processor licensing for license metric Named Users Plus is required.

Oracle GoldenGate is the leading high-performance software for log-based, bi-directional data replication using Change Data Capture (CDC) of modified transaction data in real time, data transformation and data delivery across heterogeneous systems and for continuous availability and zero down time. Oracle GoldenGate provides implementation, operation, modification and extension at low exposure to the associated database.

Licensing conditions:

The number of licensed processors is determined from the number of processor cores and a processor factor.

A minimum of 25 users per processor licensing for license metric Named Users Plus is required.

Contact

Thomas Kasparek

Thomas Kasparek
Tel: +49 351 25859-2621
Contact form