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 OIRIssue on ODI Application resolved.
- 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.
...