Data Integration Solution Architect / Data Architect

Looking for challenges. Contact me on Linkedin.

Oracle Workflow server is not mandatory to have ETL process scheduled in OWB

In Oracle Warehouse Builder 10g R2 you can schedule ETL mapping without Oracle Workflow server. Though, in tutorials in Oracle Library the only examples of scheduling ETL was through Process Flows, which are implemented in Oracle Workflow server. To schedule ETL mapping you should create Calendar and assign it to Mapping Object in Project Explorer. Details can be found in these blogs:

  1. Using DBMS Scheduler with OWB Mappings
  2. Using DBMS Scheduler with OWB Mappings