How to Create a Package

How to Create and Name a Package
1. Locate the project and folder in the Projects view where you want to create the package.
A package always belongs to a project, but you can use interfaces from other projects in
the package.
2. Right-click the Packages node and select Insert Package.
3. Provide a meaningful name to your package in the Name field.
4. Describe what the package does by entering details in the Description field. This
description appears in the package documentation and is useful when performing
changes or maintenance.
5. To begin adding steps, click the Diagram tab.
Package Diagram
 
 This is how the Diagram tab of a package appears.
The Diagram represents the steps of the package as icons, with green links representing the
success path between them. The currently selected step is highlighted by a box around it. The
first step is marked with a green arrow.
At the bottom, you see the properties of the currently selected step. You can rename the step
here. Different properties are displayed for different types of steps.
In Toolbox at the left, all the tools that you can use are categorized. You can also access the
tools without categorization under All. Tools are covered in the next slide.
On the toolbar are buttons for sequencing packages. This is examined more closely in the
next slide. You can move or undock the Toolbox and the Properties pane to improve your
workspace.
 Package Diagram Toolbar
 
The following three tools are the most important. You use them frequently.
• “Next step on success”: You can draw a link from one step to the next with this. If the
first step executes successfully, ODI executes the next step in the chain. For example,
the first step might populate your ORDERS table, whereas the second can write the total
number of orders to a file.
• “Next step on failure”: This tool does the opposite. You can draw a link from one step
to another that should be run if the first fails. For example, you can create a failure link
from the second step above to an email step. If ODI is unable to write to the file, it sends
an email informing you about the problem.
Linking steps are covered in detail in the slides that follow.
• “Select”: You can use this tool to stop drawing links and to lay out the diagram more
clearly.
• ―Hide/show success links‖ and ―Hide/show failure links‖ enable you to see certain
aspects of the diagram more clearly by hiding links.
• ―Duplicate selection‖ and ―Delete selection‖ are self-explanatory and can also be
accessed by right-clicking a step.
• ―Rearrange selection‖ rearranges the diagram completely and automatically according
to a predetermined algorithm.
• ―Execute selected step‖ is useful to see the result of just one step. ―Execute package‖
runs all steps starting from the first step. You can also use the Execute button in the
lower-right corner of the window.
• ―Page setup‖ and ―Print package‖ enable you to configure and print a comprehensive
report of all the steps in your package.
• Finally, ―Show errors in the diagram‖ checks your diagram for errors, such as unlinked
steps.