O'Reilly logo

Getting Started with Talend Open Studio for Data Integration by Jonathan Bowen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required