The reports are web based, and served from a Unix machine using Java Servlets. The middleware HTTP/XML server is built on the Microsoft .Net Framework and provides both data migration and data portal services. A security model had to be implemented to ensure authorized use of this application. The system is comprised of four distinct components: * Data migration from the distributed Access databases to the new consolidated database. * The new centralized database (Microsoft SQL Server 2000). * A HTTP/XML server to serve as middleware between the Web server and the Database server. * Web backend software with web server.
This paper will discuss the technology choices and implementation of each of these components.