Problem #5 – Load data from XML (save data in MongoDB and MS SQL)

[martin-nikolov]

• You must create XML file holding additional information by your choice.

For example:

<?xml version="1.0" encoding="utf-8">
<expenses-by-month>
  <vendor name="Nestle Sofia Corp.">
    <expenses month="Jul-2013">30.00</expenses>
    <expenses month="Aug-2013">40.00</expenses>
  </vendor>
  <vendor name="Targovishte Bottling Company Ltd.">
    <expenses month="Jul-2013">200.00</expenses>
    <expenses month="Aug-2013">180.00</expenses>
  </vendor>
  <vendor name="Zagorka Corp.">
    <expenses month="Jul-2013">120.00</expenses>
    <expenses month="Aug-2013">180.00</expenses>
  </vendor>
<expenses-by-month>

• Your task is to read the XML file and to parse it.
• Save the data in the MongoDB database.
• Save the data in the SQL Server database.
• Please think how your database schema / document model will support the additional data.
• Input: XML file. Output: data loaded in the SQL Server; data loaded in the MongoDB.

[martin-nikolov]

Not implemented: Please think how your database schema / document model will support the additional data.