ADU Presentations

Functional Support using SQL Tools 

11-07-2016 10:14 PM

1. In the functional support team at Griffith University, we widely use Oracle SQL Developer tool. This part of the presentation will go through how the Griffith Student Systems functional team has configured SQL Developer preferences to achieve maximum productivity. We also use this tool for real time monitoring of important events using Graphs and Reports. We have also set up a tips and tricks web page with videos and screenshots which are now used across all functional teams which include Finance, HR and Frontline support. This tips and tricks page is also now being utilised by our development resources.

2. Griffith has built custom records and pages that allow us to plug in multiple SQL Statements that are used to check Data Quality and configuration. Then a custom App Engine is used to run these SQL Statements to produce daily reports that provide an output which states issues that need to be fixed. These reports are emailed to selected individuals for action.

Statistics
0 Favorited
17 Views
1 Files
0 Shares
14 Downloads
Attachment(s)
pdf file
Functional Support using SQL Tools.pdf   2.63 MB   1 version
Uploaded - 09-18-2020

Related Entries and Links

No Related Resource entered.