ChainBuilder ESB Getting Started Guide
Take a guided tour of the ChainBuilder ESB product by reviewing this printable targeted document. Topics include software installation and several use case scenarios to help you understand how to put the product to use quickly. The individual steps within each case study vary depending on what is implemented, but sample functionality discussed includes creating the project, creating message definitions, creating the transformation, creating the flow and deploying the project.
Use Case Files : JDBC
This use case sets up an a ChainBuilder ESB project that uses the JDBC component and the Map Editor's JDBC operation. This example illustrates the classic example of using SQL commands to read database and perform operations based on that content. The zip file includes the JDBC Use Case documentation which steps you through this two part Use Case. The first part of the Use Case demonstrates reading from a CSV file, transforming it into jdbc_request messages with SQL command and SQL bind variables, executing the request, and checking the success/failure using the Content Based Router (CBR). The second part of the Use Case uses a script to polls the database every second for unprocessed orders. (The script creates a SQL query command to perform the poll.) If there are unprocessed orders, an update is performed on each row returned and a XML message is sent to a file.
