2/1/2016 - 2/12/2016
Completed
- Technical specs documentation completed for initial set of published SPA annual reports.
- Production deployments completed:
Jira Legacy server OIT JIRA columns key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution serverId 252346bd-c418-34af-94a0-0709b2108812 key KFSDW-1101 Jira Legacy server OIT JIRA columns key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution serverId 252346bd-c418-34af-94a0-0709b2108812 key KFSDW-1108
- Cognos Workspace Advanced demo for OR.
- New data elements around Prime Sponsor and Research Agreements requested to be added to existing SPA framework.
- Looking into where the data can be sourced from and how to add to the ODS.
- Cognos data source connectivity issue to the SPA system troubleshooting.
- Issue resolved after adding firewall egress rule to allow from the Cognos servers to SPA host machine.
- Informatica client setup/KSAMS role request for Andrew Do complete.
In Progress
- Technical specs documentation for completed SPA Cognos reports.
- In the process of adding all requested SPA system tables to existing Cognos framework model.
- Informatica SRAQ.
Planned
- Direct database connectivity setup to Tick@Lab "export" database and Cognos framework model creation.
1/18/2016 - 1/29/2016
Completed
- Mapping template for ODS loading workflow conversion completed for Bryce.
- Talend to Informatica KSAMS web services conversion is ready for deployment and test running on dev.
- Production deployments completed:
Jira Legacy server OIT JIRA columns key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution serverId 252346bd-c418-34af-94a0-0709b2108812 key KFSDW-1077
- Meetings with Raj regarding new requests from the OR team.
- Informatica version control deployment on the dev repository.
- Informatica tutorial sessions.
...