Scheduling Oracle BPM and SSIS

Scheduling computational tasks is a very fundamental functionality, which is provided by most OS. Recently I was looking into scheduling tasks in SOA environment. There are several tools at ones disposal to schedule tasks they could be placed in one or more of following buckets

•    Scheduling library, example Quartz
•    Software Package, example job Scheduler
•    Service Orchestration/ Choreography tools, example Oracle BPM
•    Databases, primarily for database tasks



Scheduling library
This approach works best if one has to there is minimal UI required to for scheduling. Example picking up schedule from a property file etc

Software Package
COTS or Open source packages provide UI, with user management, ability to schedule various types of tasks. They are good at getting up and running rather quickly but their UI may not alight with UI for in-house applications. Also on has to take into account the business process surrounding scheduling tasks such as manager approvals.

Service Orchestration
Depending on the enterprise mix, and tasks that need to be scheduled this may fit the needs. In SOA environment BPM could easily be used to schedule services and sketch various scenarios.




I am looking into integration of Oracle BPM with Microsoft SSIS package. The
primary use for SSIS is data warehousing, as the product features a
fast and flexible tool for data extraction, transformation, and loading
(ETL).


In terms of integration, i plank to kick start, SSIS package from
Oracle BPM and have mechanism, so that SSIS package can provide
feedback as to when its completed successfully or failed. Also i want
to take action in BPM in case there is no feedback from SSIS after set
interval example 2 hours.



First start with BPM process

1)Initialization - Automatic activity

2)Place timer - to insure process proceeds at set schedule

3)Launch SSIS - Automatic activity.

4)Notification wait with due transition- so that process waits for sucess/faliure notification, if that dues not come it will preform (due) transition after set interval to next state