Oracle Data Integrator 12c FAQ





General
 


What is Oracle Data Integrator (ODI)?

Oracle Data Integrator is a comprehensive data integration platform that covers all data integration requirements: from high-volume, high-performance batch loads, to event-driven, trickle-feed integration processes, to SOA-enabled data services.

Which projects are suitable for Oracle Data Integrator?

Oracle Data Integrator can be used in a variety of projects including:

  • Conventional Data Integration
  • Business Intelligence and Data Warehousing
  • Modernization Initiatives
  • Migrations and Consolidations
  • Service Oriented Architecture (SOA) Initiatives
  • Master Data Management 

What platforms does Oracle Data Integrator support?

The Oracle Data Integrator system requirements and supported platforms can be found here.

Is ODI 12c certified with Oracle Database 12c and Pluggable Databases?

Please refer to the certification matrix. All features and types of the certified database version are supported.

Is ODI 12c compatible with Oracle Database 11g Express Edition?

Please refer to the certification matrix. All features and types of the certified database version are supported.

Which technologies does Oracle Data Integrator integrate with?

A list of the source and target technologies supported by Oracle Data Integrator is included in the Oracle Data Integrator system requirements and supported platforms.

Where can I find the Oracle Data Integrator documentation?

The Oracle Data Integrator documentation can be found in the Oracle Fusion Middleware Documentation Library.

I want to get started with Oracle Data Integrator, is a demo environment provided?

Yes you can find the Getting Started Guide and the Demo Environment on the Oracle Data Integrator OTN page.


New Features

 

Where can I find a list of all the new features in this release?

The ODI Overview page on the Oracle Technology Network (OTN) contains several white papers covering the new features included in Oracle Data Integrator 12.1.2.0.0, 11.1.1.7, 11.1.1.6, 11.1.1.5 and 11.1.1.3.
 

Installation


Where can I download Oracle Data Integrator?

Oracle Data Integrator 12c is available in the Oracle Data Integrator Downloads on OTN and on eDelivery.

Where can I download Repository Creation Utility (RCU)?

The RCU is now part of the base installation for Oracle Data Integrator.

Does RCU support non-Oracle databases?

Yes, it supports non-Oracle databases but only for the Standalone Agent. Please refer to the certification matrix for more details.

What is the proper RCU for ODI 12c and where do I find it?

The RCU is laid down as part of the ODI installation and can be found under the install directly. Please refer to the documentation for further details.

Is the use of RCU mandatory for creating ODI 12c repositories?

Yes, it is strongly recommended because RCU creates the dependent schema types as well which are needed down the line for configuring the ODI Agent.

Should we install the Fusion Middleware (FMW) infrastructure only for the purpose of using the ODI Studio?

No, the ODI 12.1.2 installer lays down the needed FMW infrastructure silently if it is not already present in the installation directory.

Should the ODI 12c home be placed under Fusion Middleware home?

Yes, as long as the Fusion Middleware version is supported in the certification matrix.

If a Fusion Middleware home already exists and is used by ODI 11g, can the ODI 12c install go into it also?

No, ODI 12c can be installed on the supported version of the Fusion Middleware home only.

I have already installed the Enterprise install type for ODI in my oracle_home, do I need to install it again if I want to have Standalone Agent(s)?  Why is this needed when the Enterprise install type itself includes Standalone Agent(s)?

Yes, you would need to install the Standalone install type again in a separate Oracle home.  The Enterprise install type contains the Collocated Standalone Agent which is different from the Standalone Agent.  Please refer to the Installation Guide to understand the difference among the various types of Agents.

Can the configuration wizard launched from the Enterprise install location be used for configuring a Standalone Agent also?

No.  To configure the Standalone Agent the configuration wizard should be launched from the Standalone installation location.  The configuration wizard from the Enterprise install location can be used for configuring Collocated Standalone Agent(s) that get installed with the Enterprise install type.

Does the Standalone Agent require WebLogic Server (WLS) for installation?

No, WLS is not required for Standalone Agent(s).  The libraries required by the WebLogic Management Framework get laid down by the installer on selecting the Standalone install option.

How do I modify the username/password configuration for a Standalone Agent?

The username/password can be updated through the configuration wizard.

What install type should be selected for managing a Standalone Collocated Agent by Enterprise Manager Cloud Control (EMCC)?

The required EMCC plugins are available with the EMCC installer and not included in the ODI installer.

Does the Collocated Agent also take advantage of the High Availability (HA) capabilities of WebLogic Server?

No.  High Availability is available only for the JEE Agent.

What Edition of WebLogic Server is required for a Standalone Collocated Agent?

Standard Edition of WLS would be sufficient.

Can the ODI installer be installed with JRE?

No. JDK is required to run the installer.
 
 

Architecture 


Where can I find some information about the Oracle Data Integrator concepts and its architecture?

You can find such information in the Oracle Data Integrator Architecture Overview.

Where can I find the High Availability Guide for Oracle Data Integrator?

You can find more information about High Availability in Oracle Data Integrator in the Fusion Middleware High Availability Guide.

Where can I find some information about the Oracle Management Pack for Oracle Data Integrator?

You can find more information about the Oracle Management Pack for Oracle Data Integrator here.

 

Upgrade


Can I upgrade from a previous version of ODI to ODI 12c?

You are able to upgrade ODI 12c from ODI 11.1.1.6 and above. If you are working with a version below 11.1.1.6 (for example, v10, 11.1.1.3, 11.1.1.5,...), please upgrade to 11.1.1.6 first. After upgrading to 11.1.1.6, you are eligible to upgrade to ODI 12c.

What is the best method for doing an ODI 11g to ODI 12c upgrade?

Depending on your installation type, please refer to the Upgrade Guide for the upgrade path.

Why should I upgrade to Oracle Data Integrator 12c?

Oracle Data Integrator 12c includes numerous product enhancements and capabilities. Oracle has invested in the following key areas in this release:

  • Superior productivity with a new flow-based declarative user interface. The enhanced user experience is simple yet powerful and comprehensive; the ability to seamlessly reuse mapping logic speeds up development and overall time to solution.

  • Improved parallelism functionality increases Oracle Data Integrator’s already high performance architecture.

  • High performance E-LT capabilities integrated with Oracle GoldenGate enable faster and more efficient loading and transformation of real-time data into a data warehouse.  Customers can now easily configure and deploy real-time data warehousing solutions without impacting source systems or batch window dependencies.
  • Improved interoperability with Oracle Warehouse Builder, providing the foundation for customers to start migrating to Oracle’s strategic Oracle Data Integrator platform.
  • Direct integration into Oracle Enterprise Manager  Cloud Control 12c for improved IT productivity in monitoring Oracle technology and applications from one central location.

  • Extended Big Data support in unifying integration tooling via industry standards across unstructured/semi-structured and structured data.


You can refer to the white paper covering the new features included in Oracle Data Integrator 12.1.2.0.0, available on the ODI Overview page on the Oracle Technology Network (OTN).


Customers

 

Where can I find more information about current customers and how they implemented Oracle Data Integrator?

You can find more information about our Oracle Data Integrator customers in the Oracle Data Integration Successes.


Licensing


Where can I find information about the Oracle Data Integrator Pricing and Licensing?

The latest Oracle pricing and licensing information can be found in the Global Pricing and Licensing page on Oracle.com.

Does Oracle Data Integrator 12c include WebLogic Server?

Oracle Data Integrator 12c includes a restricted use license of WebLogic Server Standard Edition to use for running the Oracle Data Integrator Web Console.


Training


Are there any public training courses available for Oracle Data Integrator?

Yes, Oracle University offers instructor-led and online trainings. You can go to http://education.oracle.com to get a complete listing of the courses available. If you do not see the course you are interested in, please send Oracle University an email, as they may be able to add courses to suit your needs.


Miscellaneous


Where can I find the Oracle Data Integrator Applications Adapters?

The Application Adapters are included in the Oracle Data Integrator installer. They are laid down by default for both install types:  Standalone and Enterprise.

Where can I find a list of known issues and workarounds?

Known issues and workarounds are documented in the Oracle Data Integrator Release Notes.

Where can I find a list of the Oracle Data Integrator error codes?

You can find all the ODI error codes in the Oracle Fusion Middleware Error Messages Reference 12c book.

I have more questions about Oracle Data Integrator, where can I find additional information?

There is a Data Integrator Forum , please submit your Oracle Data Integrator product related questions to the discussion forum. 
You can also find the Oracle Data Integration blog at http://blogs.oracle.com/dataintegration/