Challenge Overview
Appirio's Workday Practice would like to develop a Data Management application for assistance in Workday implementation projects. There are a set of data-related tasks which the practice is hoping to automate:
1. Producing a data dictionary for a project
2. Producing data gathering workbooks for a project
3. Validating data from data gathering workbooks.
4. Mapping data from data gathering workbooks to ILoad sheets
5. Transforming data gathering workbooks to ILoad sheets.
In the initial phase of the project, we'll be primarily focused on the first three high-level requirements.
Final Submission Guidelines
In this architecture challenge we need your help come up with a structural design for our application based on the attached requirements document but also help in validating several important architectural concerns. The deliverables for this challenge are an Application Design Specification for the overall application and Direct-to-Assembly - instructions for each of the major modules defined as components (as found here -- TopCoder and 3scale Integration.zip.) I hope to run assembly competitions based on the output of this competition.
Also would appreciate your input on the following questions:
Question #1: Are these the correct technologies for the application contemplated?
Java
Heroku
PostgresSQL
GitHub
Maven
Question #2: Is Heroku the correct platform for us since we cannot easily store files there. We'll have to work with BLOB's in and out of the PostgresSQL database. Is this feasible?
Question #3: What is the best way to keep our data secure. There will be customer data in this application and it is extremely important that this data not be compromised. Workday Consultants are accustomed to encrypted excel files but what further measures can we take to keep this application and the data within it secure.