Homework¶
Well done for completing the training.
In this guide¶
-
Day 1 – Data Exports (SQL to XML) (1 Hr)
Export customers and their delivery addresses from the Sage database to an XML file, using a shared connection, a Hierarchy and a Filter
-
Day 2 – Exporting Transactional Data (1 Hr)
Export transactional data, and use the Database Writer to flag the exported transactions so they are not exported twice
-
Hierarchical Data Files (30 Mins)
Read a file holding header, detail and sub-detail records with a CSV Reader, and get the key fields right
-
Describe an XML document to the Xml Reader, which does not work out its own schema as the other readers do
Document Purpose¶
Complete the homework to practise the techniques from the training on new kinds of data.
Days 1 and 2 each have a Sage 200 and a Sage 300 version. Follow the one that matches the training manual you worked through. The other two exercises are the same for both products.