Calling an ODI Scenario from APEX
How to call scenario odi from apex application.
Instead to open the client to execute the run of the scenario there is possibility to call odi scenario just using a button created into your application front-end apex.
Objects to create
– Job type PLSQL_BLOCK
– Apex button to enable the job indicated
Here the source for the button
As we developed the following
Download the script that contains:
– create job
– enable the job created
Out of scope:
– Create scenario propaedeutic for the job, in this case the scenario calls PKG_ALLINEA_CASSE (see ScenarioName tag)