Scope:
The APPO database, on Sybase, is the master source for ASU email
addresses. The database is updated using stored procedures, direct SQL
and a thin JAVA API that calls the stored procedures. This project
would do the following:
- Migrate email addresses from APPO to EDNA
- Update existing EPO Update client
- Rewrite Java API to enforce rules currently documented only in the stored procedure
- Rewrite software that updates EPO routing tables
This project is necessary because:
- Electronic identity is being mastered in EDNA and APPO. The
synchronization between these two systems has caused issues in the past.
- The client that is used to update the EPO is dependant on the Affiliate database which is being retired.
- The database currently sits on a Sybase server, which the UTO would like to retire.
The following are consequences if the project is not done:
- UTO will have one more legacy system to support
- Synchronization will need to be maintained
- The EPO Update client will still need to be updated to not use Affiliate.
