ODI 12c - OWB Migration, Integration Plus Components

Today is another big day for ODI and OWB! Get your hands on the much anticipated functionality covering everything from new components added into the ODI 12c mapping designer, to the ETL design migration utility (announced here) to move designs from OWB 11.2.0.4 into ODI 12c which all complement the integration and auditing of OWB jobs from ODI which was included in 12c.

The patches for ODI and OWB are great news on many fronts, not only in being a major point in the roadmap. As well as the OWB migration this is great for the ODI the product, the new components provide a lot of great capabilities (and will help with a lot of those 'how do I do this' questions).

Included in the ODI patch you'll find a component bundle including transformation components from pivot/unpivot through subquery filtering on to table functions and the like. All great examples of the product's extensibility - a fusion of declarative design and technology specific knowledge modules in harmony. Lots of good stuff that you will hear much more of.

There are multiple patches - if you are only interested in ODI features and enhancements then all you need is the ODI patch below;

  • ODI 12.1.2.0.0 installed (ODI 12.1.2.0.0 plus patch number 17053768)

If you want the OWB migration utility then you will need the following patch to OWB as well as the ODI patch above;

  • OWB 11.2.0.4 installed (OWB 11.2.0.4 plus patch number 17547241)

If you install the ODI patch you will find some new components in the palette, the components let you express many more transformations - these were transformations which could be designed in OWB, now in ODI as well as the components we have knowledge modules to support their code generation for heterogenous environments.

The ODI 12c release included a new ODI Tool and support for monitoring OWB jobs - jobs can be initiated using the tool OdiStartOwbJob tool which is available for use from within packages, procedures, KMs or command line. The jobs can be monitored from ODI, this includes OWB mappings and process flows. The patch provides the migration utility plus components.

In subsequent postings we will deep dive into these areas. 

Comments:

May be locale problem. Change the ODI Studio to English by adding the following language/country settings to odi.conf, the new components will then show:

AddVMOption -Duser.language=en
AddVMOption -Duser.country=US

If you revert back to your default locale you should see these components, however the name of the components are still English. If it's this problem a bug has been logged.

Cheers
David

Posted by David on November 20, 2013 at 08:20 AM PST #

it works now. thank you , David.

Posted by guest on November 20, 2013 at 08:06 PM PST #

I Have read that there is an option to execute OWb mapping from ODI 12C, to achieve that do we need to do all the steps using OWB to ODI Migration Utility or can we achieve that without this migration.
Is the Utility is used for migrating OWB mapping to ODI metadata and can be executed as ODI component?

Also could see that Migration utility is released only for Linux, is there any plan for Windows?

Thanks for your help in advance.

Cheers
Mubs

Posted by Mubs on December 04, 2013 at 05:49 AM PST #

Hi Mubs

To integrate OWB jobs in ODI the migration utility patch is not needed, it works out of the box in ODI 12c. The production ODI 12c release has a tool for executing OWB jobs, plus you can monitor and manage them.

You can see some of the capabilities we posted in the blog below;
https://blogs.oracle.com/dataintegration/entry/planning_the_journey_from_oracle

Yes, the migration utility will be available on Windows soon, don't know, can't tell dates :-)
Cheers
David

Posted by David Allan on December 04, 2013 at 08:00 AM PST #

Thanks David for your reply. Having one more question,

Can we access OWB 10g from ODI 12c or is it mandatory to migrate to OWB 11g.

How will be the effort for migrating OWB 10g to 11g, hope that will not be a big task.

Regards
Mubs

Posted by guest on December 10, 2013 at 05:31 AM PST #

Hi Mubs

For the purposes of metadata migration it should be fairly painless, the upgrade path is well trodden now and you are probably only interested in design time metadata upgrade which makes it even simpler - its basically MDL export/import.

Cheers
David

Posted by David on December 10, 2013 at 08:33 AM PST #

David,

Does the pivot, unpivot operator works with other databases like sql server ?
Are they specific for oracle technology only.

-JIM

Posted by guest on December 12, 2013 at 11:29 AM PST #

Hi Jim

There are ANSI SQL KMs also included for pivot and unpivot so you can use them with SQLServer for example. The Oracle KM just provides the Oracle specific grammar.

Cheers
David

Posted by David on December 12, 2013 at 11:39 AM PST #

Hi David,

Thanks. With the new feature of in-session parallelism - can the execution units be executed on different ODI Agents (or still the entire session runs on a single agent) ?

-JIM

Posted by JIM on January 02, 2014 at 08:09 PM PST #

Hi Jim

No they cannot span multiple agents. The in-session parallelism feature operates within a single session instance and a session is not distributed across agents.

Cheers
David

Posted by David on January 03, 2014 at 09:15 AM PST #

Hi David.
I'm still facing the problem with display the new components (pivot,unpivot,table function) even after applied patch 17053768 and adding the mentioned lines in odi.conf. During openening the particular mapping in message log window the following:
Unable to create graphic for AGGREGATE11G
Unable to create graphic for DATASETX
Unable to create graphic for FILE
Unable to create graphic for UNPIVOT
Unable to create graphic for SUBQUERYFILTER
Unable to create graphic for PIVOT
Unable to create graphic for TABLEFUNCTION

Could you please advice whats the problem?
Thank you in advance for your replay.

Posted by guest on January 17, 2014 at 06:20 AM PST #

Hi David.
I'm still facing the problem with display the new components (pivot,unpivot,table function) even after applied patch 17053768 and adding the mentioned lines in odi.conf. During openening the particular mapping in message log window the following:
Unable to create graphic for AGGREGATE11G
Unable to create graphic for DATASETX
Unable to create graphic for FILE
Unable to create graphic for UNPIVOT
Unable to create graphic for SUBQUERYFILTER
Unable to create graphic for PIVOT
Unable to create graphic for TABLEFUNCTION

Could you please advice whats the problem?
Thank you in advance for your replay.

Posted by Slem on January 17, 2014 at 06:24 AM PST #

Hi David.
I'm still facing the problem with display the new components (pivot,unpivot,table function) even after applied patch 17053768 and adding the mentioned lines in odi.conf. During openening the particular mapping in message log window the following:
Unable to create graphic for AGGREGATE11G
Unable to create graphic for DATASETX
Unable to create graphic for FILE
Unable to create graphic for UNPIVOT
Unable to create graphic for SUBQUERYFILTER
Unable to create graphic for PIVOT
Unable to create graphic for TABLEFUNCTION

Could you please advice whats the problem?
Thank you in advance for your replay.

Posted by Slava on January 17, 2014 at 06:29 AM PST #

Is this a migrated mapping from OWB? Did you apply the patch to ODI?

Perhaps try renaming the .odi directory in the user home and restart the ODI studio? It is .odi on Linux and odi under C:\Users\<your_user>\AppData\Roaming\ on Windows

Cheers
David

Posted by David on January 17, 2014 at 08:35 AM PST #

Hi David,

I've applied patch to ODI home and didn't have any OWD mappings.

It works!! Thank you very much)

Cheers,
Slava

Posted by Slem on January 17, 2014 at 09:10 AM PST #

1. Can we migrate directly from OWB 10gR2 to ODI 12c on Solaris?

Posted by jdh on March 18, 2014 at 09:38 AM PDT #

No, the migration tools works from 11gR2 (11.2.0.3 and up at the moment). You can export the MDL from 10gR2, import into 11gR2 and then migrate to see what you get. It is a metadata migration tool.

Cheers
David

Posted by David on March 18, 2014 at 09:47 AM PDT #

Post a Comment:
  • HTML Syntax: NOT allowed
About

Learn the latest trends, use cases, product updates, and customer success examples for Oracle's data integration products-- including Oracle Data Integrator, Oracle GoldenGate and Oracle Enterprise Data Quality

Search

Archives
« July 2015
SunMonTueWedThuFriSat
   
3
4
5
6
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
 
       
Today