ODI - Monitoring

How to monitor the execution of ODI.

Operator is the production management and monitoring module. It is designed for IT production operators. and is basically a GUI that displays the status of executions.

In the work repository, you can find the table SNP_STEP_REPORT and SNP_EXP_TEXT that you can join on I_TXT_STEP_MESS = I_TXT. This is the join for the error message text.

The only column that needs further definition is the decode statement for STEP_STATUS (Status). These can also be found in the ODI Documentation Substitution Methods Reference.

• 'D' = Success'
• 'E' = 'Error'
• 'Q' = 'Queued'
• 'W' = 'Waiting'
• 'M' = 'Warning'

• Creating an ODI (Oracle Data Integrator) Dashboard with OBIEE