oralce大学ODI培训资料13课件.ppt

Oracle Data Integrator 11g: Integration and Administration 13 - * Procedures: Overview The first step is to define what procedures are and how they work. Then you will examine a few examples of the sort of procedures that you can create. Oracle Data Integrator 11g: Integration and Administration 13 - * What Is a Procedure? A procedure in ODI consists of a series of commands executed in sequence. Commands contain code that can be executed by database engines, the operating system where the Agent is running, or directly by ODI. You can also define options in the procedure to control its behavior at run time. A very useful property of procedures is that they are reusable and can be inserted into packages. Thus, just as procedures comprise commands, a package can contain several procedures as steps. Oracle Data Integrator 11g: Integration and Administration 13 - * Procedure: Examples The following are some examples of uses of procedures: Email Administrator procedure: This procedure contains a single command that calls the tool. You can then add an option to specify the email address. Thus, to change the email address of the administrator, you do not have to modify the procedure. You can even reuse the procedure in several places, each with different parameters to send emails to different people. You can also create a procedure called Clean Environment. You can create an ODI procedure to create an RDBMS table and populate it with data. Oracle Data Integrator 11g: Integration and Administration 13 - * Procedure: Examples (continued) Another example of a procedure is Initialize Drive. This consists of two commands: 1. First, a command to mount the drive is required. The text of this command depends on the current operating system. Therefore, an option is created to parameterize the procedure depending on the operating system. 2. Then, a work directory is created on the mounted drive. The ODI command, OdiMkDir, is used here. The last example for a procedure is