Likelihood to Recommend The entire deployment and configuration stage was easy and it was accessible across the organization in a matter of days. Oracle Analytics Server being a cloud-based solution helped right from Input of Bulk Data to Info preparation, Data cleaning, and finally Data Modeling. Everything was visual and the Help Wizard was very intuitive.
Read full review Appropriate for general querying and some DBA work. It's the universal least-offensive solution for most environments - not best of breed, but not subject to unusual/extensive requirements. It just works. On the other hand, some functionality (e.g. data import/export, snippets) are perfunctory and minimal and seem to be either difficult or impossible to automate. If you need to streamline those operations, you'll be forced to rely on third-party solutions that mostly work on top of (instead of with) TOAD.
Read full review Pros Oracle helps with easy customization of reports. It helps with the creation of dashboards and the integration of different data sources. Oracle BI was a package used for multiple users across our organization - publishing and distributing reports was a breeze. Read full review Export data into excel. Export data into excel using a pivot table functionality. Navigation between windows is intuitive and easy to understand. Good for SQL novices and experts alike. Read full review Cons More AI but with human back up. Less mumbo jumbo so even IT guys/gals can more easily work. More statistics (math) and orientation for those not familiar with it. More live as well as virtual (live) show casing of real situations in business. Read full review The workflow is a relatively new feature. Quest is adding additional functionality and the workflows are useful now. Would be nice if the 'Automate' feature was a bit easier to use. Would be nice if some of the SQL Editor features in the traditional interface worked better in the new workflow interface (although, these are being fixed with each release). Would be nice if there were fewer releases. Read full review Likelihood to Renew Scalability and rich integration capabilities. In the future, if we go with Hyperion for the Financial Consolidation and planning purposes -BI integration with Hyperion is going to be much simpler as it has native interface connectivity and even integration capabilities with well known CRM products (Siebel) and ERP Products (Oracle EBS, Peoplesoft, SAP) is going to be easy and straight forward.
Read full review Usability For me or a staff memeber that uses it frequently, its usability is sufficient. However newbies could have a few issues but find their workflow
Read full review I find Toad Data Point easy to use for both the novice and the experienced business analyst. If all you desire is to access data and create spreadsheets...this is a snap. Toad Data Point actually has cool data analysis features built into it. The newer workflow interface makes automating steps a snap
Read full review Reliability and Availability No problems, it's that simple.
Read full review Performance Other than anomalies or expected quirks, there were never any earth-shattering delays.
Read full review Support Rating It's fast, efficient and easy to work with. Scheduling could help when planning out a day however overall it's a big plus when rolling out and supporting Oracle.
Read full review In-Person Training Oracle University offers very in-depth training.
Read full review Online Training It was a private training site.
Read full review Implementation Rating A properly implemented Endeca solution performs extremely well on the largest of datasets and it positions your organization to immediately achieve your ROI.
Read full review Alternatives Considered Oracle BI works pretty well and has been well acknowledged and appreciated by the business users and power users who develop reports and dashboards. Compared to other tools, Oracle BI object development is easier and has a quick turnout. Using Oracle BI with Essbase and Oracle Exadata db, we believe the performance rendering data is quite good. We are using
MicroStrategy as well almost equally, but for critical reporting needs considering the back end is Oracle and Oracle Financial Services Analytical Applications (OFSAA) we have chosen OBIEE.
Read full review Although Toad and
UltraEdit are both great products, from an SQL standpoint Toad is a much better editor and troubleshooter.
Read full review Scalability We have seen the results of this in our initial research and are not surprised that Oracle does this like it does soo many other things in this area, so well.
Read full review Return on Investment We've used OBIEE (or it's previous named product) for over 13 years and it's still the most used tool for BI by the business. We moved our largest business system off of Business Object into OBI so we could gain improved performance, reliability, and easier management of metadata. Read full review It is the least common denominator - not particularly optimized for our environment or workflows. Hangs or slowdowns add anywhere from 5% - 7% for projects utilizing large/complicated data setts. (This could be due to other IT-imposed constraints and not entirely due to TOAD.) Trying to perform some operations requires reading documentation and experimenting in order to figure out the TOAD-specific approaches and commands. It just works (when we understand it). Updates don't break things and things don't suddenly start behaving differently. Best of all, we don't mysteriously lose functionality. Read full review ScreenShots