6/16/2017 – 08/31/2017
Completed
- Access to Registrar Oracle Database.
- MySQL 32 bit version installed to support the creation of ODBC Data sources.
- Informatica connectivity for UG Admission Database.
- Informatica connectivity for OIR.
- Automation of the ETL process by using the parameters.
- Load the PPS data into ODS.
- Created the links for the ETL documentation in the Wiki.
- Created the list of Registrar composite tables that needed for reporting.
- ODS Admin KT - Tom Braun
- ODI Admin KT - Chris Chadbourne.
In Progress
- Grad Aid Staging development testing.
- Rework on the development for the staging table names from STG_ to ARCHIVE_.
- Establish the ETL connectivity for Summer database.
Planned
- Continue to work with the remaining technical leads to identify the legacy data connectivity.
- Ethnicity data rollup between the UCOP and IPEDS.
- Start the ETL Development of the known Legacy inputs.
- ODI work on Grad Aid tables.
5/19/2017 – 06/15/2017
Completed
...