ODI - Scenarios

Card Puncher Data Processing


A scenario is the partially-generated code (SQL, shell, etc) for the objects (interfaces, procedures, etc.) contained in a package.

Once generated, the scenario is stored inside the Work repository. The scenario can be exported then re-imported into another Repository for use in one or more different contexts.

Once generated, the scenario's code is frozen, and all subsequent modifications of the package and/or data models which contributed to its creation will not affect it. If you want to update a scenario - for example because one of its interfaces has been changed - then you must generate a new version of the scenario from the package.

The scenario's properties are displayed in the Scenario window’s Scenario window in the Designer module or via the Operator module. Operation of a scenario takes place from the same window or from an operating system command window. In the Designer module, scenarios are grouped under their respective packages.

Run a Scenario from an OS Command

  • Open an MS-DOS command prompt window or a console in UNIX.
  • In the Oracle Data Integrator installation folder, open the “bin” directory and use the startscen command


startscen ScenarioName ScenarioVersion ScenarioContext Logging Level


startscen MyScenario 001 GLOBAL "-v=2"
  • When the execution is finished, the command prompt should look like this:
E:\Odi\oracledi\bin>startscen MyScenario 001 GLOBAL "-v=2"
A JDK is required to execute Web Services with OracleDI. You are currently using a JRE.
OracleDI: Starting scenario MyScenario 001 in context GLOBAL ...
01/10/2010 01:45:01 PM(main): Creating session for scenario:MyScenario - 001
01/10/2010 01:45:02 PM(main): Session : 8005 is running
01/10/2010 01:45:25 PM(main): Session : 8005 finished with return code : 0
DwgJv.main: Exit. Return code:0

Documentation / Reference

Discover More
Odi Topology Jee
ODI - (Agent|Server)

ODI Agent is a lightweight Java process that orchestrates the execution of ODI scenarios. The ODI Agent can be installed to allow for lights-out processing of ODI scenarios developed with Designer :...
Card Puncher Data Processing
ODI - Packages

A package is a pre-defined sequence of steps, designed to be executed in order. There are many types of steps, such as: Interfaces Procedures Actions/evaluations on variables Actions on models,...
Odi Project
ODI - Project

A project is a group of objects developed using Designer and is the first thing to do when you begin to design. Oracle...
Odi Jkm Oracle
ODI - Setting up Journalizing/CDC

This is the basic process for setting up CDC on an Oracle Data Integrator data model. Each of these steps is described in more detail below. Set the CDC parameters Add the datastores to the CDC ...

Share this page:
Follow us:
Task Runner