Integration with Ease.
JDBC stands for Java Database Connectivity and defines a Java standard to access relational databases products. JDBC drivers are available for any relational database product. Database access and operations can be easily done in Flow Director and can be combined with anything.
Get Flow DirectorThe above example shows how to move data from one database into another. It defines a connection to a local Postgres (left) and a remote DB2 production database (right). The flow moves local orders stored in Postgres to the DB2 production database. Which orders to move is specified through messages coming in from a queue called MoveOrderRequests. Each request initiates a query on the local Postgres database which returns a set of orders. Each of them is inserted into the DB2 database and therafter deleted in the local Postgres database.