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

Using a file from a parameter variable

There are times when it may be necessary to load data from a file without knowing the exact name of the file prior to execution. To handle this unique situation, ODI provides a convenient method for developing an interface that references a data store with a variable resource name. All that is required at runtime is simply to pass a parameter containing the actual name of the file that needs to be processed.

This recipe will demonstrate how an interface can be developed initially using a known data store after which the resource name of that data store is replaced with an ODI variable. The interface can then be called from a package that accepts the true value or the resource (file) at runtime.

Getting ready ...

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