Oracle Data Integrator available

ODI is now also available for download.  New installs of ODI support Java 1.7 for server components, which I thought was interesting.

New features in this release:

ODI WebSphere Support (Hot-Pluggability)
This ODI release introduces the support of IBM WebSphere Application Server (WAS). ODI Agents and datasources can now be deployed on Oracle WebLogic Server (WLS) and IBM WebSphere Application Server (WAS).

XML Driver Enhancements
Full support for XML Schema constructs by using standard Oracle parser:

  • New JDBC driver parameter compat_mode to indicate the compatibility with mapping modes such as the XDK XSD parser.
  • New JDBC driver command WRITEMAPPINGFILE to help understand the relational structure that has been created for the XSD/DTD file. The mapping file contains the element/attribute name to table/table.column name mapping for each element/attribute.
  • The JDBC command CREATE SCHEMA includes now the compat_mode parameter.

SSL Support for Standalone Agent
The Standalone Agent now supports the SSL protocol for secure connectivity. New parameters added to specify the Standalone Agent server side transport protocol and to configure the SSL truststore and keystore:

  • New environment variables in scripts
  • New configuration variables in scripts
  • Java system properties in scripts

Include EDQ Open Tool in ODI Core
The EDQ Open Tool introduced in ODI 11gR1 PS2 ( to invoke an Oracle Enterprise Data Quality (Datanomic) Job is now available as a standard ODI tool. The OdiEnterpriseDataQuality tool includes a new, optional parameter to connect MBean domains.


From an EPM perspective, we just scratch the surface of what ODI can do.  Most of my clients are operating under the limited use license that comes with Planning and/or HFM.   ODI is a great tool that allows some great automation to be built for EPM administrators, though.  Most of my experience with ODI has been replacing old HAL routines during Planning application upgrades, so these features don’t really change the game very much for me.

If you want it, here it is; come and get it:  Oracle Data Integrator Downloads.

One comment

  1. Hello there I am so excited I found your website, I really
    found you by mistake, while I was researching on Yahoo for something else, Anyways I am here now and would just like to say kudos for a incredible post and a all round
    exciting blog (I also love the theme/design),
    I don’t have time to read through it all at the moment but I have bookmarked it and also added
    your RSS feeds, so when I have time I will be back to read
    a lot more, Please do keep up the great work.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s