3/13/2017 - 3/24/2017
Completed
- Complete SPA reports inventory analysis complete for SPA Award dimensional model.
- Final pricing for Informatica Advanced Edition complete.
- $36,600 for edition upgrade. Down from initial $50k pricing.
- Performance testing requested by Ellucian of Informatica for SIS to locally hosted Oracle DB complete.
- No performance issues when writing to KFSDEV.
- Severe performance issues on Ellucian cloud hosted servers.
- Bio Science dept Talend dashboard demo with Office of Research.
- New development SPA database migration completed.
- All Informatica/Cognos connections as well as ODBC DSNs updated to new host.
- Firewall rules now in place for all informatica servers and workstation.
- Onboarding prep work for student intern/Anthony Nguyen complete.
- Service-now incidents completed:
In Progress
- Informatica KSAMS roles with elevated privileges creation.
- 2 new roles created.
- Existing privileges migration
- Users (complete)
- Folders (complete)
- Connection (in progress)
- Current User role users need to be transitioned to new Developer role.
- Removal of current User role needs to be requested after PRD deployment is complete.
- SPA awards dimensional model design
- Dimensional modeling
- Informatica mapping design
- Cognos Framework model design.
- KFS nightly workflow scheduling and monitoring migration to Zena and Operations group.
- Workflow execution testing through SSH from Zena host successful on both etl-dev and etl0.
- Currently waiting for WSG to grant Informatica server access to qaoper.
Planned
- New production SPA database migration (On-hold due to issues with other OR application).
- Informatica session statistics auditing capability survey for COMPASS workflows (On-hold).
- Designing POCs for several different design approaches.
- Clinical trials Cognos report for OR (On-hold)
- Need additional fields in the proposal ODS table.
- ETL and Cognos framework package needs to be adjusted.
- Informatica SRAQ.
2/27/2017 - 3/10/2017
Completed
- Informatica Developer Training (3/6-3/9).
- Half-year Activity by School and Year Cognos report design completed and published.
- New development SPA database migration.
- All Informatica/Cognos connections updated and tested.
- Aiding the Middleware team in configuring/troubleshooting Informatica connectivity to LDAP update only servers.
- Connectivity failures on port 700 and 701 identified as firewall and resolved.
- JIRA's 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-1621 - Service-now incidents completed:
In Progress
- Working on new Informatica KSAMS roles with elevated privileges
- 2 new roles created.
- Current User role users need to be transitioned to new Developer role.
- Removal of current User role needs to be requested after PRD deployment is complete.
- Negotiating pricing for Informatica Advanced Edition as well as core capacity addition.
- New production SPA database migration.
- All Informatica/Cognos connections as well as ODBC DSNs need to be updated.
- Firewall rules for production need to be adjusted.
- SPA awards dimensional model design
- Dimensional modeling
- Informatica mapping design
- Cognos Framework model design.
- KC proposal dimension daily loading mapping design.
- Clinical trials Cognos report for OR (On-hold)
- Need additional fields in the proposal ODS table.
- ETL and Cognos framework package needs to be adjusted.
- Zena Agent install on etl-dev.
- Mike Story currently testing workflow execution from Zena host.
...
- Additional fact table for KC Negotiation star completed.
- Informatica workflow updated.
- Cognos framework package updated with new star schema grouping updated.
- OR data warehouse related tables migrated to Solar for OIR to access.
- Common award dimension feasibility analysis.
- SPA/KFS GAP analysis.
- Accounting will have Janine create a separate award dimension.
- Will revisit at a later date.
- Aiding the Middleware team in configuring/troubleshooting Informatica LDAP loading workflows.
- Connectivity issue to ldap-dev resolved. Issue related to TLS setting in addition to port setting on the Informatica connection object.
- JIRA's 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-1611 - Service-now incidents completed:
In Progress
- SPA awards dimensional model design
- Dimensional modeling
- Informatica mapping design
- Cognos Framework model design.
- Informatica session statistics auditing capability survey for COMPASS workflows.
- Designing POCs for several different design approaches.
- KC proposal dimension daily loading mapping design.
- Clinical trials Cognos report for OR (On hold)
- Need additional fields in the proposal ODS table.
- ETL and Cognos framework package needs to be adjusted.
- New OR dev and prod database migration.
- All Informatica/Cognos connections need to be changed.
- Firewall rules for production.
- Connectivity testing for production.
- Zena Agent install on etl-dev.
- Waiting on firewall exceptions to be completed by the security team.
...
- New awards by purpose Cognos report complete.
- Code review for all PURAP TEM objects for production deployment.
- UCLA Informatica object import for UCPath.
- Shared folders created for all source, target, and transformations.
- Informatica developer training prep work complete.
- Confirmed for 3/6-3/9 @AIRB1020
- Presentation slides prep work for OIR DW information session.
- JIRA's 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-1596 - Service-now incidents completed:
In Progress
- Additional fact table creation for KC Negotiation star.
- Aiding the Middleware team in configuring/troubleshooting Informatica LDAP loading workflows.
- Also migrating/testing connectivity to new ldap-dev server.
- Clinical trials Cognos report for OR (On hold)
- Need additional fields in the proposal ODS table.
- ETL and Cognos framework package needs to be adjusted.
- New OR dev and prod database migration.
- All Informatica/Cognos connections need to be changed.
- Firewall rules for production.
- Connectivity testing for production.
- Zena Agent install on etl-dev.
- Waiting on firewall exceptions to be completed by the security team.
...
- UCLC Training
- Sexual Harassment Prevention
- Cyber Security Awareness
- Awards by purpose Cognos report for 2015-2017 fiscal years
- Awards by sponsor by school Cognos report for Q1 2017.
- Code Review for OIR Compass ETL.
- Daily GL dev nightly loading changed back to KFSDAY2.
- ETL data flow overview meeting for OIR reporting team.
- SISDEV connectivity from Informatica.
- stunnel setup complete.
- ODBC source setup and testing complete on etl-dev.
- JIRA's 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-1573 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-1579 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-1580 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-1587 - Service-now incidents completed:
In Progress
- UCLA Informatica object import UCPath.
- Need to create shared folders.
- Informatica developer training proposal prep work.
- AIRB training room requested for (3/6-3/9)
- Received adjusted price quote for Level 1 Developer course.
- Received customization confirmation from Informatica University.
- Clinical trials Cognos report for OR (On hold)
- Need additional fields in the proposal ODS table.
- ETL and Cognos framework package needs to be adjusted.
- New OR dev and prod database migration.
- All Informatica/Cognos connections need to be changed.
- Firewall rules for production.
- Connectivity testing for production.
- TEM data mart development code review and deployment prep work.
- Zena Agent install on etl-dev.
- Waiting on firewall exceptions to be completed by the security team.
...