Loading data from an SQL query

With the release of ODI 11g came two very important new features: the ability to specify an inline query in the form of a temporary interface and the ability to specify the use of an inline query within a knowledge module. Together, these two new features can be combined to provide developers with the ability to use any SQL expression as a data source to an interface. It is the intent of this recipe to demonstrate a simple example of this powerful capability.

Getting ready

To follow along with the examples listed here, you will need an ODI project with the following KMs: LKM SQL to Oracle, IKM SQL_as_Source (this module can be downloaded from the Packt website), and IKM Oracle Incremental Update. From a resource perspective, ...

Get Oracle Data Integrator 11g Cookbook now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.