3/6/2017 – 03/17/2017
Completed
- Demo Registrar POC Enrollment report - Complete.
- Support the POC on Enrollment report.
- Ticket created to drop the old schemas for legacy data – Done.
- Performance Issue - Loading data into KFS – complete Loaded 300,000 records in 2 min 25 secs and confirmed that it’s the ODS database issue on the poor performance.
- Informatica AWS testing - Complete
- Worked on establishing the firewall between the Grad DB and Informatica.
- Worked on establishing the firewall between the Admissions DB and Informatica.
- Worked on establishing the firewall between the OIR DB and Informatica.
- Rewriting the Financial Aid Database function (Identifying the student is a CA resident or not) in Informatica. – Development Complete.
- Testing of the POC function is on hold as the test environment does not have data in the underlying base tables.
In Progress
- Performance issue on the ODS instance.
- Continue work with Technical leads to identify the legacy data connectivity for Informatica.
- Documentation of POC Function.
Planned
- POC Demo – 3/13/2017
- Establish the connection for the known Legacy data inputs through Informatica.
- Continue to work with the remaining technical leads to identify the legacy data connectivity.
- Start the ETL Development of the known Legacy inputs.
2/20/2017 – 03/03/2017
Completed
...