Page History

...

• Once the connection is established between all the boxes / states, you can see an arrow connecting each state. This constitutes the Process Definition Language for your integration profile.
• Double-click on "DB2QBCustomer" state or right-click on the same and click on "Open Dataflow" to open the state.
• Drag Create Reader, Create Map & Create Writer into the center of the console and name each one as "DBReader", "DBmap" & "QBWriter" respectively. A screenshot below illustrates the same.
• Establish connection between Reader, Map and Writer by first right-clicking on each a box and select "connect" and left clicking on the following box as shown.

Note: Always establish connection between states in the sequence of Reader: — Map: — Writer:

• Once the connection is established, all control flows will be displayed with arrows. A screenshot below illustrates the same. Image Added
• Right Click\Properties on DBReader. The properties will be displayed in the bottom left area of DBSync Console. Select Database from Adapter Drop Down. Image Added
• Enter the following query within the query section of the database adapter.