Challenge Overview
Ilium is a direct to consumer seller of various items. One set of items can be seen at the GreatCleaners site (http://greatcleaners.com). Processing of sales by the GreatCleaners includes sending of daily sales data to invoicing and inventory system (SAP).
This process is already implemented and based on hand-coded data warehouse. Sales data is originally stored in OLTP databases on production server. Asynchronously but fairly close to real time OLTP tables are replicated to the reporting server and then ELT processes are used to load data from reporting server to the data warehouse. The daily sales data is extracted from data warehouse into text file. This text file is moved to an FTP directory where electronic data interchange systems access it and pass to SAP.
On the SAP side a text file is used to relieve inventory for the sold items and create invoices for recording the sales.
Data warehouse is also used as convenient data source for various reports.
Please see the wiki for the full requirements:
http://www.topcoder.com/wiki/display/docs/Ilium+Cash+Reconciliation+Module+Architecture
Final Submission Guidelines
- For each member, the final submission should be uploaded to theOnline Review Tool.
- Submissions must include all deliverables as specified above.
- All questions must be asked in the contest forum