POS Reporting System

We developed the entire reporting system module. The requirement was to get the data files in form of MDB files from stores and get the data migrated into the SQL 2005 database server from where the reporting system will be using them to generate the reports.

This involved writing windows service that will poll the store manager PC for the daily MDB file and then pick up the file and upload it on to the centralized server. Once the MDB file reaches the centralized server it will be picked up by another windows service running on it that will parse and migrate the data into the corresponding SQL server 2005 database. The reporting web application would then access this migrated data and generate the various reports that are needed. All the reports are accessed based on the different user roles set in the system. There is also an admin interface to maintain and as well upload the MDB files manually incase the automated process fails.