We’ve talked a lot lately about 2013’s top BPM trends, case management in particular. Of all the new and exciting things we could be talking about though, what makes case management within Oralce BPM so important? Simply put, if BPM is a car, case management will be its future driver. Oracle has begun to focus more attention and roll out additional functionality specific to case management with their BPM Suite.
About a month ago, I wrote a shell script to do some automated file transactions. As part of the scripting process, the last step required me to have certain files ready in a specific folder on a server to be consumed by other downstream systems. These downstream systems needed some of the data in these files to be modified for them, to be able to consume them successfully. The number of files created and the amount of data in these files would vary per execution of the shell script, but the data that needed to be changed was known to me.
I recently had a customer who needed to consolidate data from several legacy databases (Sybase, DB2, and Oracle 10g) and then copy the transformed result set to a Microsoft SQL Server 2008 database. This was clearly an ETL use case so, being a good consultant, I suggested that they use a tool like Oracle Data Integrator. However, because they had a limited budget for new licenses and already had a license to Oracle SOA Suite 11g that they wanted to test out, they asked me to do this using BPEL.
Remember the commercial with the “Easy” button? When you press it miraculous things happen and all your wishes come true. This is what Oracle had in mind when it created the SOA Database Adapter. Perhaps I’m overstating this just a little, but the idea is to remove most of the pain from interacting with a database, allowing the user to focus on the important things – like retrieving, saving, updating and deleting information.
If you are reading this blog topic, then like so many, you are trying to use the Oracle SOA 11g Database Adapter to fit your database polling needs and are in need of a little assistance.
When deciding to use the Oracle SOA Database Adapter the use of a good poller friendly staging table makes life a bit easier. It is also good to know a few things about how the database adapter works.
(This is an excerpt from Lesson 8 "Oracle BPM and ADF (Part 1)" from Avio Consulting's new self-paced online Oracle BPM Developer Workshop training.)
Understanding ADF's architecture is an essential step to understanding how to use it with Oracle BPM. This describes the different layers of ADF's architecture and how they tie to Oracle BPM.
ADF Model View Controller (MVC) Architecture
In Part 1 of this series we imported JDeveloper libraries into our Maven repository and in Part 2 we built a WAR file for our ADF project using Maven. In Part 3, we will now take one or more of these WAR files and package them into an EAR file for deployment. Before we start looking at the pom.xml for the EAR build, you should know that, unlike JDeveloper, Maven defines the EAR as a separate project.
In the first part of this series we looked at how to prepare your Maven repository by importing all of the JDeveloper libraries into it. Now that we have all of the required libraries in our Maven repository, we can work to build our ADF application into a WAR file.
Creating the pom.xml