12 Scenarios

Learn about scenarios in Oracle Data Integrator, what they are, how to create them, and how to run them.

Topics

• What are Scenarios
• Create and Run Scenarios

What are Scenarios

Learn what scenarios are in Oracle Data Integrator.

Once you have built and tested a component in Oracle Data Integrator (ODI), you can create a scenario corresponding to its state. Scenarios can only be created in a development work repository. If you modify the component at a later date, the scenario code does not change. You can generate scenarios for packages, procedures, mappings or variables. Scenarios that execute a procedure, mapping, or variable are only single-step. Those for packages can be single-step or multi-step.

Scenarios can be exported and then imported into other work repositories, which can be development or execution repositories.

See Introduction to Scenarios in Developing Integration Projects with Oracle Data Integrator.

Create and Run Scenarios

Learn how to create and run scenarios in Oracle Data Integrator.

1. Start generating a scenario using one of the following:
   1. Double-click the package, mapping, procedure or variable for which you want to create a scenario to open the object editor. From the ODI menu, select Generate, and then Scenario.
   2. In the Designer Navigator, right-click the package, mapping, procedure or variable for which you want to create a scenario, and select Generate Scenario.
2. Enter the scenario name and a version.
3. Click OK twice and the scenario appears on the Scenarios tab and under the Scenarios node of the source object under the project. If there are variables in the scenario, then after clicking the first OK, you can define the variables that are parameters for the scenario.

See Generating a Scenario in Developing Integration Projects with Oracle Data Integrator.

See Generating a Group of Scenarios in Developing Integration Projects with Oracle Data Integrator.

You can execute a scenario from within Oracle Data Integrator Studio, or from the command line.

In Oracle Data Integrator Studio:

1. Right-click the scenario and select Run.
2. In the Run dialog box, set the execution parameters and Agent. Click OK. If there are any variables used as parameters, select the appropriate values when the Variable Values dialog box is displayed.

To start a scenario from the command line:

1. Change the directory to <DOMAIN_HOME>/bin/ directory
2. Run the following command:
   • On UNIX:

     ./startscen.sh -INSTANCE=<ODIInstanceName>  <scenario_name>
           <scenario_version> <context_code>  [<log_level>] [-AGENT_URL=<remote_agent_url>]  [-ASYNC=yes|no]
           [-NAME=<local_agent_name>]  [-SESSION_NAME=<session_name>] [-KEYWORDS=<keywords>]
           [<variable>=<value>]*

   • On Windows:

     startscen.cmd "-INSTANCE=<ODIInstanceName>"
           <scenario_name> <scenario_version> <context_code>  [<log_level>]
           ["-AGENT_URL=<remote_agent_url>"]["-ASYNC=yes|no"]  ["-NAME=<local_agent_name>"]
           ["-SESSION_NAME=<session_name>"] ["-KEYWORDS=<keywords>"]
           ["<variable>=<value>"]*

See Executing a Scenario in Administering Oracle Data Integrator.