Oracle Analytics Cloud vs. Toad Data Point

Oracle Data Visualization is very effective if used in an enterprise context with huge volumes of data coming from different systems. It supports dashboard and reporting capabilities and is easy to scale. It also allows you to leverage machine learning capabilities to extract hidden data trends. Visualization capabilities are powerful but not so various if compared to other solutions on the market. If you want to present a dashboard to an executive audience and you want to make your dashboards beautiful you must adapt them through PowerPoint.

Incentivized

Toad Data Point is the clear tool of choice if the end-user is interested in reports that are relatively simple to build using SQL code and export to Excel. It is less useful if the analyst also needs to run statistical models on the data and visualize the data for those functions I usually use RStudio or Jupyter Notebook which incorporates those features much more seamlessly.

Incentivized

• Available without of the box connectors for Salesforce and oracle Saas Cloud. This is a huge plus for our business since we don't need another middleware solution just for this sake.
• We are able to connect to our on-prem SQL Server database where we have our RMA database and other applications seamlessly without writing custom APIs.
• OAC writes directly into ADW which is another advantage for loading Excel files into ADW after dataflow transformations.
• OAC allows replication of the database from fusion ERP and lets us create subject areas using the data modeler.

Incentivized

• Ease of building SQL/accessing data, using the Query Builder.
• The new workflow feature mimics products like Hyperion and is centered on how business analysts are used to working with their data.
• The dimensional views are definitely a hidden gem. This feature allows you to display similar data in multiple windows, then filter on specifics. ALL windows will then reflect the same data. An example here would be salaries organized by dept then salaries organized by job type. As you filter, both analyses will reflect the filtered data.
• You can easily create spreadsheets and pivot table spreadsheets.
• You can email the results to the team/you can save the results in the intelligence central repository so others can access it.
• You can automate all of these things.

Incentivized

• Reports that output data to portable and mobile devices should be in a better and more appropriate form and improved.
• In the beginning, the initial settings take some time, which I think requires a smart wizard to set up and get started.
• Must add mores diagrams and graphs

• The program can error out when reconnecting to a database from a timeout but that is easily fixed by restarting the program.
• If you aren't familiar with database tools the UI can be overwhelming to some.

Incentivized

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

Incentivized

Oracle Analytics Support team is very proactive and I have never had a situation where I had to wait for more than a day or two to get my issues resolved. This is a very big help for us and we appreciate Oracle and its team for guaranteeing that experience.

Incentivized

Oracle Business Intelligence Cloud Service (OBICS) does well in terms of handling data, creating joins, managing database relationships, and data integration from multiple sources. However, the visualisation features on Oracle Business Intelligence Cloud Service (OBICS) are limited when compared to other business intelligence tools like Looker or Tableau. Again, the choice of tool depends on your specific requirements. Both provide different features and both are good at what they offer.

Incentivized

Toad give me more flexibility. Being able to utilize FTP to send data and receive files from external systems is wonderful. Using the automation tool to run different database, file, and system activities has made my day-to-day functions easy. Being able to schedule tasks right from the software has also made thing easy.

Incentivized

• ROI is better than average; the product pays for itself in the long run
• Ease of use, which is very important in today's busy environments.
• Can be costly based on the amount of user licensing, which is a flat cost per user.

Incentivized