The entire flow for database consistency integration takes less than 10 minutes to develop on Fiorano. The flow consists of two database components connected via ‘routes’, with a simple transformation component in the middle to ensure that the data formats are consistent. Further, the Fiorano environment allows the flow to be modified dynamically, even while running; changes to the flow do not require the flow to be stopped and ‘redeployed’. Each individual component can also be independently reconfigured on-the-fly.

This whitepaper compares the performance and ease-of-use of the Fiorano and Oracle SOA platforms in the deployment of one of the most popular patterns in integration: the database consistency integration pattern. In this pattern, an update to a table in a source database (DB1) results in an update to another table in a target database running on a different machine. Information flow is one-way, from source to target, and asynchronous.


 Learn More »