10/1/2017 – 10/31/2017
Completed
- Automation of the ETL process for Legacy data the ones which are complete.
- Student Mapping Complete.
- Additional columns added to AR Bliss Tech specifications.
- Re-established the access to SISSHARE registrar database.
- SZRADAP Extension script sent for review with Tom Braun.
In Progress
- Summer Archive tables created in ODS.
- ETL development for legacy summer tables.
- Working with mapping of legacy registrar data into Composite table (STUDENT_COURSE) columns.
- DCE Course Information - I&C SCI X426.53 Data Structures, Data Mining and Big Data with Python class began.
Planned
- Continue to work with the remaining technical leads to identify the legacy data connectivity.
- Start the ETL Development of the known Legacy inputs.
9/1/2017 – 09/29/2017
Completed
- Summer ETL Access established.
- Grad Aid Staging development put on hold as the source data development is in progress.
- Grad Aid Change to column names completed.
- Automation of the ETL process for Legacy data the ones which are complete.
In Progress
- Testing of ETL connectivity for summer Database.
- Extension on a table (SZRADAP)from Base line into ODS.
- Student Mapping.
- Time to degree report.
Planned
- Continue to work with the remaining technical leads to identify the legacy data connectivity.
- Start the ETL Development of the known Legacy inputs.
6/16/2017 – 08/31/2017
Completed
- Issue on ODI Application resolved.
- Grad Aid Staging development.
- Grad Aid (PPS Data & Quarterly Info) composite completed.
- Individual Access to Summer Database.
- UG Admission Legacy data.
- Financial Aid Legacy data.
- Grad Division Legacy data for tables requested by Rachel.
- Ethnicity Data.
- KFS Data.
- Soap UI Installed.
- KSAMS Webservice mapping complete.
- AR Bliss Tech specs.
- Automation of the ETL process for Legacy data the ones which are complete.
In Progress
- Establish the ETL connectivity for Summer database.
- Testing for KSAMS Webservice.
- ODI Work on Composite tables for remaining Grad Aid.
- Extension on a table (SZRADAP)from Base line into ODS.
Planned
- Continue to work with the remaining technical leads to identify the legacy data connectivity.
- Start the ETL Development of the known Legacy inputs.
5/19/2017 – 06/15/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/1/2017 – 05/18/2017
Completed
- Grad Division - GRADM Staging Tables design and creation.
- Grad Division - GRADM Staging ETL Development.
- Grad Division - GROGS Staging Tables design and creation.
- Grad Division - GROGS Staging ETL Development.
- Grad Division - GRENR Staging Tables design and creation.
- Grad Division - GRENR Staging ETL Development.
- Performance Issue – Resolved.
- After the Native Oracle driver and SGA memory bump up.
- Grad Division - GRADM Staging source to target mapping specs.
- Grad Division - GROGS Staging source to target mapping specs.
- Grad Division - GRENR Staging source to target mapping specs.
- ODS Admin KT - Tom Braun
- ODI Admin KT - Chris Chadbourne.
In Progress
- Grad Aid Staging development testing.
- Establish the ETL connectivity for OIR and UG Admissions database.
Planned
- Continue to work with the remaining technical leads to identify the legacy data connectivity.
- Start the ETL Development of the known Legacy inputs.
4/17/2017 – 04/28/2017
Completed
...