Using JDBC with Flow Director

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 Director

The 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.

Share this page:
Data Privacy

Copyright ©2023 Edge Broker GmbH. All rights reserved.

Some icons by Icons8.