These 2 developments should give us a lot of opportunity to share and make both campuses more productive in the reporting environment. We are also investigating the possibility of a joint pilot project to test Informatica. It also documents the entire process and reporting tools can access this information. This is a very powerful tool and will make maintenance to PS much easier to implement for the warehouse. Patches and fixes are currently being applied to various instances on the development platform.
Backup procedures are in place and are being tested.
The proposed production environment was presented to a panel of people that included DoIT, UW System, UW Oshkosh, Peoplesoft and Dr Munson. The proposed environment was reviewed and well received. Suggestions were made regarding the data warehouse instance, networking and storage. Vickie will be following up on the suggestions to see if they are relevant to our environment. Analysis is being done to determine what will be needed for the production environment for hardware and maintenance in addition to the database server, storage and application servers.