Chapter 10. Worked Examples

This chapter builds on the knowledge we have gained in the previous chapters and illustrates a number of real-life integration scenarios. You will see that the examples use techniques from different chapters and combine file manipulations with database queries, subjobs with file management, for example, to create full end-to-end integration jobs.

You will hopefully have learned now that the Studio is incredibly flexible, and one result of this is that there is often more than one way to approach a task and develop a suitable job that satisfies the integration requirement. Keep this in mind as we walk through the scenarios in this chapter and see if you can come up with different configurations that achieve the same end.

First let's set the scene. Delightful Dresses is a fashion retailer and it operates an e-commerce website to sell its products online. It sources some of its merchandise directly and has an Enterprise Resource Planning (ERP) application to support...