Guide To Integrating
OWB9.2 And Oracle Workflow
A
recent posting on Oracle
Warehouse Builder prompted
some questions from readers
on the process of
integrating Oracle Workflow
with Oracle Warehouse
Builder; this integration
has also been a 'hot topic'
on the
OTN OWB Forum. The OWB
documentation stops short of
explaining how workflow
jobs, created using OWB9.2
and deployed using the
Deployment Manager, are
actually submitted and run
using Oracle Workflow, and
therefore
Sonia Brown put together
some notes on how this
integration is achieved.
The document covers the
following steps, with a
number of screenshots to
illustrate the process;
-
Installing Oracle
Workflow Server
-
Edit
init.ora file
-
Start
Oracle Universall
Installer for Oracle
Database 9.2
-
Install
and configure Web Server
-
Workflow
web interface virtual
directory mappings
-
Installing Workflow help
documents
-
Set up a
directory service for
Oracle Workflow
-
Verify
your base URL
-
Implement Oracle
Internet Directory
integration (optional)
-
Implement Single Sign-On
integration (optional)
-
Installing Additional
Languages
-
Installing Workflow
Builder Client
(Optional)
-
Installation
-
OWB
Configuration Settings
-
Create
Workflow Location
-
Create a
Process Flow using
Workflow Location
-
Set
Properties of a Process
Flow
-
Deploy
the Process Flow
-
Process
Flows using Workflow
Server
-
Launch
process
-
View
Process Information
-
Oracle
Workflow Builder Import
(Optional)
-
Process
Flow Import
There's also a
viewlet available on OTN,
that shows how Oracle
Enterprise Manager can be
used to run the resultant
Oracle Workflow processes;
one thing to be aware of is
that the preferred database
user credentials must be
those of the Runtime Access
User, whilst the Runtime
Owner's details are used in
the properties page.
Integrate Oracle Warehouse
Builder with Workflow