...
- Review KC proposal report SQL queries.
- Access to KC sandbox environment as well as KC database access.
5/18/2015 - 5/29/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.