SQL Developer - Automation scripts

Scripting for SQL Automation of Audit Activities for client to be used by our internal auditors.
- Currently using ACL Audit Tool to perform our audit testing​
- We want move to either a tool or SQL script writer to assist us to convert our audit programme activities and operation’s business rules into scripting/tool that can be executed automatically based on scheduling feature which produce meaningful output for reporting purposes
- At the moment, we are focusing in automating financial audit processes.

Things to note:
- The proposed tool (if any) needs to be integrated with Active Directory
-It can read SQL databases
It has to be developed based on Microsoft.net Framework as our environment runs on Microsoft.
(please do not propose open source tool or software).
​

No. of users
- 7 users (5 normal users; 2 IT background users)

No. of systems to be integrated
- 9 systems ​ ranging from HR system and Financial system (all SQL Server)

(1 of the shelf, 8 are internally developed)

No. of business rules
- 150 account codes x (approx. 5 business rules)
= 750 business rules

*these are approx. number, the same business rules may applied across to the other account codes

​

Location

Petaling Jaya (1), Putrajaya (1)