Austin's Biweekly Status Reports

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

5/4/2015 - 5/15/2015

Completed

Awards by Funding Agency (Cognos)
New and Renewal Awards by Funding Agency (Cognos)
Proposals by Funding Agency (Cognos)
New and Renewal Proposals by Funding Agency (Cognos)
Award Totals for Last 10 Years (Cognos)
Proposal Totals for Last 10 Years (Cognos)
SPA ODS / Cognos report presentation for the OR OIT team.
Oracle to SQL Server TIMESTAMP data type compatibility issue resolved.
Error rendering macro 'jira' : Unable to locate Jira server for this macro. It may be due to Application Link configuration.

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