7 Data Integration Products

This chapter describes the licensing information for Data Integration products. It contains the following sections:

7.1 Oracle Data Integrator Enterprise Edition

Oracle Data Integrator Enterprise Edition is a software package for enabling scalable data integration in heterogeneous data environments.

Oracle Data Integrator Enterprise Edition includes the following components:

  • Oracle Data Integrator (ODI) (excluding those technologies separately licensed in the Oracle Application Adapters for Data Integration).

  • Oracle Warehouse Builder Enterprise ETL

To obtain high availability with Oracle Data Integrator Enterprise Edition, a separate license for the appropriate edition of Oracle WebLogic Server or Oracle Coherence is required.

Prerequisite: A license for Oracle Database Enterprise Edition is a prerequisite to using Oracle Warehouse Builder Enterprise ETL.

Oracle Warehouse Builder Enterprise ETL extends the extraction, transformation, and loading (ETL) features separately available with Oracle Database and includes the following functionality:

  • Accessing sources and targets

    • Native support for heterogeneous databases, including the definition of new platform types, JDBC connectivity, knowledge modules, and code templates

    • Support for Exadata hybrid columnar compression

    • Transparent Data Encryption (TDE) support

    • External Table support for Data Pump imports and exports

    • External Table preprocessor support

    • Change Data Capture mappings in ET

    • Publishing and consuming web services, including integrating with process orchestration technologies such as Oracle BPEL Process Manager

    • Importing Cobol copybooks using the built-in wizard

    • Targeting XML files

  • Data Guard certification and failover support

  • Working with dimensional objects

    • Creating slowly changing dimensions, types 2 and 3

    • Storing data in OLAP cube-organized materialized views

    • Defining orphan management policies

  • Designing and executing ETL jobs

    • Right-time data warehousing utilizing queues and real-time mappings

    • Reusing and embedding mapping code with pluggable mappings

    • Specifying the load order of multiple targets in a single mapping

    • Partitioning and parallelizing updates to tables by utilizing the data chunking feature

    • Scheduling ETL jobs using the built-in Schedule interface

    • Using advanced process flows features (activity templates, use of the following activities: Assign, Set Status, For Loop, While Loop, Route, Notification, EJB, Java Class, and Webservice)

    • Designing mappings to handle complex types using the following operators: varray iterator, construct object, and expand object

    • Rapidly moving large amounts of data with transportable modules

    • Using spatial transformations and streams transformations

    • Compiled PL/SQL code generation

    • Bulk code templates for Oracle --> Oracle, SQL Server --> Oracle, and DB2 --> Oracle

  • Integrating with other products

    • Deploying metadata directly to Oracle Discoverer End User Layer

    • Deriving and deploying metadata to Oracle Business Intelligence Enterprise Edition

  • Administering Warehouse Builder and its metadata repository

    • Support for database failover

    • Managing environments, including promoting from development to test to production, using the multiple configurations functionality

    • Interactively analyzing metadata lineage and impact and automatically propagating metadata change using the Metadata Dependency Manager

    • Extending the metadata repository using the following: user-defined objects, user-defined associations, user-defined modules, creating icon sets and custom icons

    • Hosting the OWB design repository in an Oracle Real Application Clusters (Oracle RAC) environment (executing in an Oracle RAC environment does not require this license)

    • Operating multiple databases with OWB repositories from a single Oracle home

Restricted use: A license for Oracle Data Integrator Enterprise Edition includes a restricted use license for Oracle WebLogic Server Standard Edition. Use of Oracle WebLogic Server Standard Edition is restricted to running the Oracle Data Integrator Web Console. Any other use requires a full use license.

7.2 Oracle Data Integration Suite

Oracle Data Integration Suite (ODI Suite) is a software bundle for enabling scalable, highly-accessible data integration in any heterogeneous data environment.

Oracle Data Integration Suite includes:

  • Oracle Data Integrator Enterprise Edition

  • Hyperion Data Relationship Management (up to maximum of 2,000 records per processor)

Restricted use: A license for Oracle Data Integration Suite includes restricted-use licenses for the following components:

  • Oracle WebLogic Suite is included as host solely for ODI Suite components including run-time components to provide Java run-time environment as well as configuration and administration components used for the setup and management of these run-time components.

  • Oracle BPEL Process Manager is included for use with Oracle Data Integrator and/or Hyperion Data Relationship Management as endpoints.

  • Oracle Service Bus is included for use with Oracle Data Integrator and/or Hyperion Data Relationship Management as endpoints.

7.3 Oracle Enterprise Data Quality

Oracle Enterprise Data Quality (EDQ) technology includes the following separately licensed products:

  • Oracle Enterprise Data Quality Profiling for Data Integration

  • Oracle Enterprise Data Quality Audit and Dashboard for Data Integration

  • Oracle Enterprise Data Quality Batch Processing for Data Integration

  • Oracle Enterprise Data Quality Real-time Processing for Data Integration

  • Oracle Enterprise Data Quality Address Verification Server for Data Integration

Restricted use: A license to any of the EDQ products listed above includes a restricted-use license for WebLogic Server Standard Edition (WLSSE). Use of WLSSE is restricted to hosting Java application logic that is distributed as part of the EDQ products listed above. Any modifications implemented as Java programs, which include Java that produces html interfaces or Java business logic, are not permitted. The restricted-use license for WLSSE includes use of the Application Development Framework subcomponent of the TopLink and ADF component. Any other use of WLSSE requires a full use license.

7.3.1 Oracle Enterprise Data Quality Audit and Dashboard for Data Integration

Prerequisite: A license to Oracle Enterprise Data Quality Profiling for Data Integration is a prerequisite to license and use Oracle Enterprise Data Quality Audit and Dashboard for Data Integration.

7.3.2 Oracle Enterprise Data Quality Batch Processing for Data Integration

Restricted use: Oracle Enterprise Data Quality Batch Processing for Data Integration is restricted to interoperation only with an Oracle software product that is included in the Oracle Technology Commercial Price List (http://www.oracle.com/us/corporate/pricing/technology-price-list-070617.pdf) or with your or any third party software application.

Prerequisite: A license to Oracle Enterprise Data Quality Profiling for Data Integration or Oracle Enterprise Data Quality Profile and Audit is a prerequisite to license and use Oracle Enterprise Data Quality Batch Processing for Data Integration.

7.3.3 Oracle Enterprise Data Quality Real-time Processing for Data Integration

Restricted use: Oracle Enterprise Data Quality Real-time Processing for Data Integration is restricted to interoperation only with an Oracle software product that is included in the Oracle Technology Commercial Price List (http://www.oracle.com/us/corporate/pricing/technology-price-list-070617.pdf) or with your or any third party software application.

Prerequisite: A license to Oracle Enterprise Data Quality Batch Processing for Data Integration is a prerequisite to license and use Oracle Enterprise Data Quality Real-time Processing for Data Integration.

7.3.4 Oracle Enterprise Data Quality Address Verification Server for Data Integration

Prerequisite: A subscription to address data packs obtained from Oracle's partner, Loqate Inc., is required to license and use Oracle Enterprise Data Quality Address Verification Server for Data Integration.

Prerequisite: A license to Oracle Enterprise Data Quality Batch Processing for Data Integration is a prerequisite to license and use Oracle Enterprise Data Quality Address Verification Server for Data Integration.

7.4 Oracle Application Adapters for Data Integration

Oracle Application Adapters for Data Integration assist for reverse-engineering metadata and extracting bulk data from the enterprise resource planning (ERP) software applications listed below in this section.

Restricted use: Each Application Adapter for Data Integration is licensed separately. Use of Application Adapter(s) for Data Integration is restricted for use with Oracle Data Integrator Enterprise Edition and the Oracle Data Integrator component.

Application Adapters for Data Integration are available for PeopleSoft, JD Edwards World, JDE Edwards Enterprise One, E-Business Suite, Siebel, Big Data, SAP Applications and SAP Business Warehouse Applications.

Table 7-1 Included components for Application Adapters for Data Integration

Oracle Application Adapters for Data Integration: Included Components:

Application Adapter for Data Integration for PeopleSoft

Reverse-engineering Knowledge Module PeopleSoft Oracle

Reverse-engineering Knowledge Module PeopleSoft MSSQL

Application Adapter for Data Integration for JD Edwards World

Reverse-engineering Knowledge Module JDE World

Reverse-engineering Knowledge Module JDE World (JDE World JDBC Driver)

Integration Knowledge Module JDE World Control Append

Application Adapter for Data Integration for JD Edwards Enterprise One

Reverse- Engineering Knowledge Module JDE Enterprise One Oracle

Reverse-Engineering Knowledge Module JDE Enterprise One SQL Server

Reverse-engineering Knowledge Module JDE Enterprise One DB2 UDB

Reverse-engineering Knowledge Module JDE Enterprise One DB2 AS400

Integration Knowledge Module JDE Enterprise One Control Append (UBE)

Application Adapter for Data Integration for Siebel

Integration Knowledge Module SQL to Siebel Append (EIM)

Loading Knowledge Module Siebel to SQL (EIM)

Reverse-engineering Knowledge Module Siebel Oracle

Reverse-engineering Knowledge Module Siebel EIM Oracle

Reverse-engineering Knowledge Module Siebel MSSQL

Reverse-engineering Knowledge Module Siebel EIM MSSQL

Application Adapter for Data Integration for E-Business Suite

Integration Knowledge Module E-Business Suite (Open Interface)

Reverse-engineering Knowledge Module E-Business Suite

Application Adapter for Data Integration for SAP Applications

Reverse-engineering Knowledge Module SAP ERP Connection Test

Loading Knowledge Module SAP ERP to Oracle (SQLLDR)

Loading Knowledge Module SAP ERP to SQL

Reverse-engineering Knowledge Module SAP ERP

Application Adapter for Data Integration for SAP Business Warehouse

Reverse-engineering Knowledge Module SAP BW

Loading Knowledge Module SAP BW to Oracle (SQLLDR)

Loading Knowledge Module SAP to SQL


7.5 Oracle Application Adapters for Warehouse Builder

Each Application Adapter for Warehouse Builder is licensed separately. Any use of Application Adapters for Warehouse Builder, including customers constructing their own application adapters for Warehouse Builder using Oracle-documented APIs, requires a full use license for Oracle Data Integrator Enterprise Edition.

Application Adapters for Warehouse Builder are available for PeopleSoft, SAP, Siebel, and E-Business Suite.

7.6 Oracle GoldenGate Products

Oracle Golden Gate technology includes the following separately licensed products:

  • Oracle GoldenGate

  • Oracle GoldenGate for Non Oracle Database

  • Oracle GoldenGate for Mainframe

  • Oracle GoldenGate for Teradata Replication Services

  • Oracle GoldenGate Application Adapters

  • Oracle GoldenGate Veridata

For details on a supported database platform for your product version please refer to the Oracle Fusion Middleware Supported System Configurations (http://www.oracle.com/technetwork/middleware/ias/downloads/fusion-certification-100350.html) and/or the certification tab under My Oracle Support (for supported customers only; http://support.oracle.com).

7.6.1 Oracle GoldenGate

Oracle GoldenGate provides the ability to capture and deliver database transactions for Oracle databases.

A license for Oracle GoldenGate includes Oracle Active Data Guard and XStream, subject to the following prerequisite:

Prerequisite: A license for Oracle Database Enterprise Edition is a prerequisite for using Oracle Active Data Guard or XStream.

Restricted use: A license for Oracle Golden Gate includes a restricted-use license to Oracle GoldenGate Applications Adapters (GGAA) for JMS and Flat File. Use of GGAA is restricted to the JMS functionality used solely for enabling communication from Oracle Golden Gate to separately licensed Oracle Coherence Grid Edition deployments.

7.6.2 Oracle GoldenGate for Non Oracle Database

Oracle GoldenGate for Non Oracle Database provides the ability to capture database transactions from supported non-Oracle open systems databases and/or deliver database transactions to supported non-Oracle open systems databases.

Oracle GoldenGate for Non Oracle Database does not include Oracle Active Data Guard, XStream or the restricted use license to Oracle GoldenGate Application Adapters for JMS and FlatFile.

7.6.3 Oracle GoldenGate for Mainframe

Oracle GoldenGate for Mainframe provides the ability to capture and deliver database transactions from HP NonStop or IBM DB2 on z/OS databases.

When Oracle GoldenGate for Mainframe is used in an HP NonStop environment for products that run on the Guardian operating system (Enscribe and SQL/MP), it includes SyncFile.

7.6.4 Oracle GoldenGate for Teradata Replication Services

Oracle GoldenGate for Teradata Replication Services provides the ability to capture database transactions from Teradata databases and deliver database transactions to Teradata databases.

Prerequisite: A license for Teradata Access manager from Teradata Corporation is a prerequisite to enable the capture process on Teradata.

7.6.5 Oracle GoldenGate Application Adapters

The following Oracle GoldenGate Application Adapters are available:

  • Oracle GoldenGate Application Adapter for Base24,

  • Oracle GoldenGate Application Adapter for JMS and Flat File

  • Oracle GoldenGate Application Adapter for Logger for Enscribe

7.6.5.1 Oracle GoldenGate for Application Adapter for Base24

Oracle GoldenGate provides adapters to integrate BASE24 components heterogeneously, moving data from ATM networks to the core banking systems for online processing.

A license for Oracle GoldenGate Application Adapter for Base24 includes the following components:

  • Oracle GoldenGate D24

  • Oracle GoldenGate N24

  • Oracle GoldenGate T24

7.6.5.2 Oracle GoldenGate Application Adapter for JMS and Flat File

Oracle GoldenGate Application Adapter for JMS and Flat File includes the following components:

  • Oracle GoldenGate for Flat File

  • Oracle GoldenGate for Java

7.6.5.3 Oracle GoldenGate Application Adapter for Logger for Enscribe

The adapter is for non-audited Enscribe database platforms.

7.7 Oracle GoldenGate Veridata

Oracle GoldenGate Veridata is a data comparison solution that identifies and reports data discrepancies between databases.

7.8 Oracle Data Service Integrator

Oracle Data Service Integrator is a platform for delivering real-time, integrated, reusable information as a service, regardless of where the data is from.

Restricted use: A license for Oracle Data Service Integrator includes a restricted-use license for Oracle WebLogic Server Enterprise Edition as host solely for Oracle Data Service Integrator, including run-time components to provide Java run-time environment and HTTP support, as well as configuration and administration components used for the setup and management of these run-time components.

7.9 Management Packs

The following Management Packs for Data Integration Technology are available:

  • Oracle Management Pack for Oracle Data Integrator

  • Oracle Management Pack for Oracle GoldenGate

7.9.1 Oracle Management Pack for Oracle GoldenGate

A license for Management Pack for Oracle GoldenGate includes Oracle GoldenGate Director.

Restricted use: A license for Management Pack for Oracle GoldenGate includes a restricted-use license for Oracle WebLogic Server Standard Edition. Oracle WebLogic Server Standard Edition use is restricted to hosting Java Enterprise Edition (Java EE) or Java application logic that is distributed as part of Management Pack for Oracle GoldenGate.

7.9.2 Oracle Management Pack for Oracle Data Integrator

Management Pack for Oracle Data Integrator provides a consolidated view of a user's entire Oracle Data Integrator (ODI) infrastructure enabling users to monitor and manage the ODI components centrally.