Best Tool Set for Ad-Hoc Database Management
September 10, 2020

Best Tool Set for Ad-Hoc Database Management

Shashank Pathak | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User

Overall Satisfaction with Oracle Business Intelligence Discoverer (discontinued)

We are using Oracle Business Intelligence discoverer for generating ad hoc reporting, data analysis, web publishing and reporting for particular clients' Oracle database environment. Basically it is having many features which we have used to solve the database queries and many more like admin activities, end user layer management, relational and OLAp queries shoot, catalog management, etc.
  • Find data that you know.
  • Drilling up and down through data.
  • Share data with other people.
  • View data in a familiar spreadsheet-style.
  • Control access to data.
  • Manage summary data.
  • Administer batch scheduling.
  • End User Layer management.
We have chosen for particular tasks or according to requirements of clients, we are also use this because we are well familiar about this tactics and features too.
It is well suited for Oracle database environment requirements, but it is not very appropriate for those who are working on different types of database environments.

Oracle Discoverer (discontinued) Feature Ratings

Pixel Perfect reports
9
Customizable dashboards
8
Report Formatting Templates
9
Drill-down analysis
7
Formatting capabilities
8
Integration with R or other statistical packages
8
Report sharing and collaboration
9
Publish to Web
8
Publish to PDF
9
Report Versioning
8
Report Delivery Scheduling
8
Delivery to Remote Servers
8
Pre-built visualization formats (heatmaps, scatter plots etc.)
9
Location Analytics / Geographic Visualization
8
Predictive Analytics
8
Multi-User Support (named login)
8
Role-Based Security Model
8
Multiple Access Permission Levels (Create, Read, Delete)
9
Single Sign-On (SSO)
9
Responsive Design for Web Access
8
Mobile Application
8
Dashboard / Report / Visualization Interactivity on Mobile
8
REST API
8
Javascript API
7
iFrames
8
Java API
8
Themeable User Interface (UI)
8
Customizable Platform (Open Source)
9