For the role of DBA, we outsource to a qualified 3rd party for maintenance of our Oracle based ERP system.
We purchased the Discoverer v.10g BI tool at the same time and setup included creation of some Discoverer reports (or views; i’m not always clear which is which)
Not one of our team has advanced beyond basic beginner status with any of the Discoverer capabilities.
One of our team has accepted the report writing role and uses TOAD to create views and port the data over to excel for further manipulation and formatting. This same person claims TOAD far exceeds Discoverer capabilities. My DBA states they are two completely different tools.
Is there anyone here that could provide a simple description of the differences between these two resources?
Do both tools have a valid role for differing purposes, or, do they accomplish the same result by different means?
Thanks in advance for your input.
Amy