Oracle SOA Database Adapters provide a polling mechanism that will periodically query a table to see if a there is a new or changed record. If so, it can trigger a BPEL process. This is enormously useful. However, on one client I ran into a series of issues with database pollers in a clustered environment when they … collided. (queue dramatic music)
A tenet of any integration toolset is the ability to interact with databases. With standards in place, this for the most part is fairly easy. But sometimes, the particulars of a database can create some unexpected complexity. One example of this is an integration solution developed within Mulesoft that invokes Oracle PL/SQL stored procedures and functions. In this scenario, knowing about some of the complexity beforehand will ensure less frustration by a developer during the development phase.
The more rigid an organizational structure becomes, the more hindered its teams will be. Agile should not lead to fragility, but should empower teams to create independently in an iterative framework. Anything less just isn’t Agile.