Page Comparison

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

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.

Planned

Informatica session statistics auditing capability survey for COMPASS workflows (On-hold).
- Designing POCs for several different design approaches.
Informatica SRAQ.

2/13/2017 - 2/24/2017

Completed

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

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.

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

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.

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

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.

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.

...

Versions Compared