Great tool for troubleshooting with Oracle EBS
Tom Blades | TrustRadius Reviewer
January 02, 2018

Great tool for troubleshooting with Oracle EBS

Score 9 out of 10
Vetted Review
Verified User
Review Source

Overall Satisfaction with Toad for Oracle

Toad for Oracle is being used in our department here at Experian for querying the database and troubleshooting issues with the Oracle application which are reported to us.

Toad is a crucial tool for our department as we have limited front-end access, and therefore we have a controlled platform to query tables/packages where differing levels of rights and access is granted for HR/Finance respectively.
  • Quick querying of data and debugging of issues which is particularly made easier with the stored procedures function and has a very friendly user-interface.
  • The use of a stored TNSnames file for accessing the different environments makes it very simple to connect to different databases.
  • Creating and editing packages is very simple and allows you to toggle different views of the package which is very handy when they are of such a large size.
  • Version control on stored procedures - currently not something which is available
  • To allow scheduled reporting remotely without the need to be physically logged into the software
  • Without Toad, we would not be able to perform our role supporting the Oracle application for HR/Payroll and Finance in such a secure and controlled manner. We are able to carry out our daily functions and provide a clear audit trail.
  • Development work can be carried out very easily with the built in functionality, allowing us to deliver frequent change to the system for the business requirements.
Toad has a very user-friendly GUI and perfectly compliments supporting the Oracle application. With the built in functionality and levels of security we can confidently use this software for our daily needs, which far more outweighed other comparable products for us.
Toad is well suited to our data-centric organization as we have segregation of duties for HR/Finance and we have restricted access to particular tables. Rights given to perform write functions to DEV and Read-Only for UAT/PROD makes this a very secure tool for our business to prevent data corruption.

Toad for Oracle Feature Ratings

Version control tools
2
Test data generation
10
Performance optimization tools
3
Schema maintenance
3
Database change management
8
User management
9
Database security
9
Database status reporting
6
Change management
4