O'Reilly logo

Oracle Data Integrator 11g Cookbook by Peter C. Boyd-Bowman, Denis Gray, Christophe Dupupet, Julien Testut

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Generating interfaces from data models or diagrams

Another often overlooked feature of ODI is its ability to generate interfaces from either data models or model diagrams. By selecting one or more data stores from a data model or diagram, ODI can create either an inbound or outbound interface capable of moving data in or out of the specified data store.

Getting ready

In this recipe, we will generate three such interfaces and compare the results. To follow along with the examples listed here, you will need an ODI project with at least the following KMs: LKM SQL to SQL, IKM SQL Control Append, and IKM Oracle Incremental Update. From a resource perspective, you will need to have imported the DEMO_SRC and DEMO_TRG data models as described in the ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required