This chapter describes the licensing information for Data Integration products. It contains the following sections:
Section 7.4, "Oracle Application Adapters for Data Integration"
Section 7.5, "Oracle Application Adapters for Warehouse Builder"
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.
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.
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.
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.
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.
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.
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.
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, JD Edwards Enterprise One, E-Business Suite, Siebel, 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 |
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.
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
).
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.
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.
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.
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.
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
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
Oracle GoldenGate Veridata is a data comparison solution that identifies and reports data discrepancies between databases.
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.
The following Management Packs for Data Integration Technology are available:
Oracle Management Pack for Oracle Data Integrator
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.