CAP Application Migration
Currently the Rdb Replication database is easily accessible from any system on the campus network. While this is functional and has made it easy for users get their work done it also creates an environment that is less secure and very open to non-authorized users. Campuses have been implementing CAP (Consolidated Access Point) Servers for the purpose of creating a method of secure access to the preferred Oracle REPL database. Now that the CAP servers are in place and functional they need to be brought into an operational mode. This requires the migration of applications and queries to the CAP servers. These applications and queries will then be run directly on the CAP servers only by users that have authorized access.
CAP Workshop - Wednesday, September 26
CAP II Application Migration Tracking Tool
CAP Guidance Document (.pdf) Updated 9/15/07- subject to regular update
CAP Users Guide Example - HCTC (.doc)CAP Users Guide Example - SCSU (.pdf)
Operational Data Tables and Views (.xls) Description - A list of all the Operational Data tables on Oracle. The tables listed under OBJECT NAME with an OBJECT TYPE of 'TABLE'and have 'ISRS' in TABLE SCHEMA are the same as in the former Rdb 'Replicated' tables. Those with 'ISRSVAL' in TABLE SCHEMA are validation tables which are the same as in the former Rdb 'Replicated' validation tables. Tables with the OBJECT TYPE of 'VIEW' are the same as in the former Rdb 'Replicated' views. These tables and views are continuously updated as the data changes in ISRS production.
Converting MS Access to Oracle (.pdf) Description - This document gives details on how to convert existing MS Access databases from ISRS Rdb replicated tables to Operational Data.
