MY LIFE AT THE COOPERATORS By Loui Zibdawi

WHERE DO I START? Ø My Position • Jr. Developer & Application Support Analyst Ø My Responsibilities • 20% App Support • 80% Development Ø Term • Sept 5 th , 2017 – Dec 29 th, 2017

APP SUPPORT DM Mailbox Monitoring Netezza Monitoring CDC Monitoring Role Documentation

DATA MANAGEMENT MAILBOX Mirroring Maximo Tickets Creating JIRA’s based on requests Directing mail End of month reports Netezza sandbox clean up Etc

NETEZZA MONITORING Email IBM Netezza Administrator

CDC MONITORING OVERVIEW IBM software solution that monitors data between pairs of tables in different databases. When there is a change to a table in the source database, the subscription in CDC goes down and we need to update the target database. If we find a change, then we need to run a program in Java that will compare those source and target tables and produce an SQL statement that needs to be run on the target in order to make them identical.

ROLE DOCUMENTATION

DEVELOPMENT Toolkit API Google Analytics CDC GUI Tool CDC Automation

TOOLKIT API Oracle DB 2 SQL Server Netezza Used for • • Building DDL’s Loading data into a databases Sending automated emails Encrypting and decrypting password

TOOLKIT SQL SERVER EXAMPLE List of tables Table SQL Server • Metadata • Primary Key • Distribute Clause Netezza

GOOGLE ANALYTICS Requirements Create daily process that retrieves google analytics data and loads it into Netezza Query data based on filters, dimensions and metrics Learn Google Analytics API Netezza

GOOGLE ANALYTICS EXPLAINED Google Analytics Web Interface Java Query

GOOGLE ANALYTICS EXPLAINED (LOAD FILE)

CDC GUI TOOL Before After

CDC AUTOMATION Goal Automate part of the daily process of monitoring CDC that requires finding the DDL’s and sending them to the DBA Work with DBA to automate their process as well Tools Toolkit API XML, Java

CDC AUTOMATION Summary 1. Read information in from configuration file 2. Access CDC API and gather information from it 3. Create DDL’s for existing tables 4. Create DDL’s for new tables 5. Place all files created into a load folder for the DBA’s to find