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