Getting Started with Talend Open Studio for Data Integration

Order file processing

Now that we have product and inventory data on our website, we can start to take orders. The key points for this process are noted as follows:

1. Customers visit the website and place orders for merchandise.
2. The orders are stored in the website system and, on an hourly basis, all new orders are extracted to an XML file. Order extract files are time-stamped to make the filename unique and so that we can determine which is the newest or oldest file. A sample of the order extract is as follows:

   <?xml version="1.0" encoding="UTF-8"?> <ORDERS> <ORDER ID="10" ORDER_DATE="06/06/12"> <DELIVERY_ADDRESS> <TITLE>Mr</TITLE> <FIRST_NAME>James</FIRST_NAME> <LAST_NAME>Smith</LAST_NAME> <ADDRESS1>123 North Street</ADDRESS1> <ADDRESS2>Greenhills</ADDRESS2> ...