Chapter 10. Creating Workflows—Packages and Load Plans

Once individual interfaces have been created, you will want to orchestrate their execution. Part of the orchestration will be the definition of the order in which the interfaces have to be executed, which elements will be executed in parallel or in a series, and which other operations you will want to add to your processes to make the overall orchestration more sophisticated. In this chapter, we will review three elements that will be needed to achieve these goals: Packages, Load Plans, and ODI Tools.


Packages are the basic element of orchestration in ODI. This is where you will sequence your interfaces, and define what operation to perform when a step (or interface) fails. One important ...

Get Getting Started with Oracle Data Integrator 11g: A Hands-On Tutorial now with the O’Reilly learning platform.

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