What are the new features of ODI12c?

.

The new release of Oracle Data Integrator (ODI 12c) is now available. Let´s find out what the new features of ODI12c are that this version includes.

First, is there anything fancy in the installation process?

Just one note here: to be able to use ODI Studio, the enterprise installation needs to be selected (instead of the Standalone option) while launching the ODI installation program.

pic1

For the configuration part, creating a new login to ODI repository you are requested to specify a new wallet password. ODI12c provides you with a possibility to store your credentials in a wallet that is protected by a password. How much it helps to protect and manage your credentials with a single password!

pic2

Goodbye Interfaces, Welcome Mappings

First of all, we do not deal with interfaces anymore; mappings are offered to the developers instead. On this background let´s talk about common features and functions across various ETL tools, like Informatica Powercenter, which has many advantages. As the previous version of ODI and Powercenter are totally different technologies, there is no tool to convert the flow automatically. Either you need to use the Powercenter workflow manager to build a new ODI package, or you can use a Powercenter mapping to create a new ODI interface, keeping in mind all the constraints that ODI11g may have, including its inability to load multiple targets. What changes now? Source and target data tables can now be dragged and dropped to the same canvas, which was not the case for the previous version.

Example canvas with components panel:

pic3

Moreover, all objects have IN and OUT connectors. There is also a possibility to use multiple targets within the same mapping as the OUT connector can be mapped to many IN connectors. The split component may be used to direct rows to the desired destination based on particular conditions. And speaking of the split option - a new components panel has been added, containing operations like join, filter, lookup or split to simplify mapping creation (see picture above). The star icon (distinct component), enables selecting particular rows.  Finally you can take advantage of the reusability of mappings, which can be applied across various projects by simply connecting to other components.

All these changes made Oracle Data Integrator more like Informatica Powercenter (or other ETL tools) when it comes to the creation of the transformation mappings. However, it’s good to remember that their main paradigm continues to be different, as ODI is still considered an ELT tool while Powercenter is a traditional ETL tool. Of course there will be supporters of both and the choice may depend on budget or functionality.

More Nice Features

We also found some other features that make our lives easier. One of them is the auto completion and syntax highlighting in expression fields. Another one is that when one column is selected all the related columns are highlighted across the mapping. The entire path for transformations is perfectly visible. Nice, isn’t it? I prefer that much more than checking every single box to track all modifications.

Undoubtedly, adding a debugger was long awaited. It provides you with options to set breakpoints, inspect the values of variables, debug sessions or data. Step by step, you can easily review your work.

pic4

We also enjoyed the enhanced security model. Security is assigned to a role and the same level of security is shared by all users belonging to that role. Additionally,  ODI standalone agents are managed by WebLogic Management Framework, which gives us the benefit of centralized management. You are offered a wizard to carry out the configuration:

pic5

Agents can be controlled by Node Manager.

Any drawbacks?

As always, there is a discussion around new releases on which features are useful and which are not. Some changes, like the layout, can be considered both as an advantage and a disadvantage. In 12c this is the case for the complexity. You are now able to see more objects at the same time, providing you with some new options like the components panel, but on the other hand it makes everything less transparent and a decent screen size is needed.

pic6

Even if this can be considered a small disadvantage, it is not a real problem. More troublesome may be that some operations are not that obvious to implement. Calculations as simple as a sum that used to require building an expression with a SUM function in the target, now obliges you to use the aggregate component prior to calculating the sum.

ODI and Oracle Warehouse Builder (OWB)

As announced, at a later stage there will be a possibility to migrate Oracle Warehouse Builders objects to ODI.  Currently all OWB jobs can be run in ODI using the OdiStartOwbJob tool and the OWB repository is a data server that can be accessed from Topology.

Summary

Expectations for this release were high. Surely the changes from the previous version are noticeable and the overall reception is good. The roadmap for ODI12c in the Oracle stack is looking very promising, acquiring a key role as default ELT tool of the new Oracle BI Applications. We are very excited to start working with ODI 12c in our projects.

Which features of ODI 12c do you find the most useful? We would be glad to receive your comments on this topic so let us know your experience.

4 Responses to “What are the new features of ODI12c?”

  1. Adi says:

    Hi,

    I installed ODI 12c 12.1.2. Web Logic Server, Node Manager and Managed Servers are running great but ODI Agent is continuously giving error:

    ‘SEVERE: org.apache.commons.cli.ParseException: ODI-1625: This must be executed from a domain. System property domain.home cannot be null”
    org.apache.commons.cli.ParseException: ODI-1625: This must be executed from a domain. System property domain.home cannot be null” ‘

    There is no agent in domain/bin, it’s on odi/agent/internal/bin. Also, in the google, saw that in 11g, odiparams.bat needed modification which was kept at agent/bin, but here, I can’t locate that file also. But I made an entry for odidomain in the credentials using wlst. Am I missing something?

    Here is the link where I’ve explained the problem in detail: https://community.oracle.com/thread/3513978

    Thanks a lot in advance…

  2. Magda says:

    Hi Adi,

    Did you create schemas with the RCU? Please make sure that this is configured correctly.
    Next, start the configuration wizard to configure the domain and create the ODI agent.

    I hope this helps,
    Magda

  3. sunilk says:

    Hi

    I am trying to invoke excode.sh script on ODI 12c collacated agent but throwin below error.

    ./encode.sh “-INSTANCE=OracleDIAgent1″
    /apps/odi_12.1.3/odi/agent/internal/bin/commODIEnv.sh: line 195: -
    Logging configuration class “oracle.core.ojdl.logging.LoggingConfiguration” failed
    oracle.core.ojdl.logging.LoggingConfigurationException: ODL-52042: undefined property: ${domain.home}.
    Jul 24, 2014 12:49:13 PM oracle.odi.param.CliParameterReader
    SEVERE: org.apache.commons.cli.ParseException: ODI-1625: This must be executed from a domain. System property domain.home cannot be null”
    org.apache.commons.cli.ParseException: ODI-1625: This must be executed from a domain. System property domain.home cannot be null”
    at oracle.odi.param.CliParameterReader.(CliParameterReader.java:94)
    at oracle.odi.Encode.getOdiInstance(Encode.java:24)
    at oracle.odi.Encode.main(Encode.java:52)

    java.lang.RuntimeException: org.apache.commons.cli.ParseException: ODI-1625: This must be executed from a domain. System property domain.home cannot be null”
    at oracle.odi.Encode.getOdiInstance(Encode.java:27)
    at oracle.odi.Encode.main(Encode.java:52)
    Caused by: org.apache.commons.cli.ParseException: ODI-1625: This must be executed from a domain. System property domain.home cannot be null”
    at oracle.odi.param.CliParameterReader.(CliParameterReader.java:94)
    at oracle.odi.Encode.getOdiInstance(Encode.java:24)
    … 1 more

    DESCRIPTION
    Encode a password. See Oracle Data Integrator documentation for the
    detailed syntax.

    SYNTAX
    encode.(cmd|sh) “-INSTANCE=”

    Can please anyone help me.Thanks in advance.

  4. admin says:

    Dear Sunilk,

    Looks like you are missing the -Ddomain.home modifier in your commODIEnv.sh.

    Try to modify the commODIenv.sh to include this modifier at the end of the ODI_JAVA_OPTIONS enviroment variable.

    Look for the line:

    set ODI_JAVA_OPTIONS=%JAVA_OPTIONS% ” (other options…)

    And add at the end

    -Ddomain.home=%DOMAIN_HOME%

    provided that your DOMAIN_HOME environment variable is set up.

    Hope that helps,
    Antonio.-

Leave a Comment

privacy policy - Copyright © 2000-2010 ClearPeaks

topnav