46/201/2015 - 56/112/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.Code review and Informatica usage tutorial with Durendal for UC_ACCOUNT_T dev to prod deployment.
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-486 - Worked with Matt to rename the production Informatica repository to resolve dev/prod duplicate name issues.
- Duplicate name won't cause any errors but will make it more difficult to deploy objects between repositories.
- System DSN and Informatica connection object created for KC dev and prod databases.
- KC table source definition import and relationships set.
- Office of Research report SQL query review.
In Progress
- Profiling KC database schema and data.
- Setting up Informatica Analyst tool to aid in data profiling.
- Getting familiar with the usage.
- Troubleshooting profile run error.
- Compiling a KC data specification document.
- Sandbox access to KC application.
- Aiding with troubleshooting/testing of Talend/Informatica conversion.
Planned
- Continue to profile KC database schema and data.
- Initial ODS table build in in our dev DB environment.
- ETL design to populate initial ODS.
5/18/2015 - 5/29/2015
Completed
...
- 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
- .
- Matt was able to retain the fully qualified domain name in the Informatica admin console so no significant adjustments were necessary from the client.
- Informatica overview powerpoint design and presentation for OIT audience.
- Setup MySQL Workbench and MySQL drivers to help with Informatica connectivity.
- System DSN and connection objects creation for the MySQL databases.
- Informatica mapping creation for repopulation of MySQL UC_ACCOUNT_T table.
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-721 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-737 - Setup Oracle SQL Developer and connections to KC dev/prod databases.
In Progress
- Reviewing KC proposal report SQL queries.
- Profiling KC database schema and data.
- Compiling a KC data specification document.
- Sandbox access to KC application.
- Aiding with troubleshooting/testing of Talend/Informatica conversion.
Planned
- Continue to profile KC database schema and data.
- Initial ODS table build in in our dev DB environment.
5/4/2015 - 5/15/2015
Completed
...
- Review KC proposal report SQL queries.
- Access to KC sandbox environment as well as KC database access.
54/1820/2015 - 5/291/2015
Completed
- Troubleshooting production Informatica repository connectivity from local machine.
- Matt was able to retain the fully qualified domain name in the Informatica admin console so no significant adjustments were necessary from the client.
- Informatica overview powerpoint design and presentation for OIT audience.
- Setup MySQL Workbench and MySQL drivers to help with Informatica connectivity.
- System DSN and connection objects creation for the MySQL databases.
- Informatica mapping creation for repopulation of MySQL UC_ACCOUNT_T table.
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-721 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-737 - Setup Oracle SQL Developer and connections to KC dev/prod databases.
In Progress
- Reviewing KC proposal report SQL queries.
- Profiling KC database schema and data.
- Compiling a KC data specification document.
- Sandbox access to KC application.
- Aiding with troubleshooting/testing of Talend/Informatica conversion.
Planned
- Continue to profile KC database schema and data.
- Initial ODS table build in in our dev DB environment.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