4/20/2015 - 5/1/2015
Completed
- Working through Matt for uci_spa dev/prod SystemDSN creation on production Informatica server.
- Informatica mappings to load from uci_spa DB to stage_kfs/dss_kfs staging/ODS tables.
- Meetings with Durendal to set direction for Cognos reporting on Informatica session statistics. - Replicate Informatica repository database to another DB instance
. - Develop Informatica nightly workflow to extract required data . - Cognos Framework Model for SPA ODS.
- Awards by Purpose by Funding Source Cognos Report. - Demo for Eric Taggart. Planning on attending OR team meeting on 5/7.
In Progress
- Awards by Funding Agency Cognos Report.
- Troubleshooting production Informatica repository connectivity from local machine. - Suspect firewall issue on port 6005 but JIRA ticket closed by John Lenning stating port already allowed.
- Looking into Oracle to SQL Server TIMESTAMP data type compatibility issue for KFS conversion.
Planned
- New and Renewal Awards by Funding Agency
- Proposals by Funding Agency
- New and Renewal Proposals by Funding Agency
- Award Totals for Last 10 Years