OAC: Proven solution for your analytics needs!
Shifa Nazumudeen | TrustRadius Reviewer
October 10, 2019

OAC: Proven solution for your analytics needs!

Score 9 out of 10
Vetted Review
Verified User
Review Source

Overall Satisfaction with Oracle Analytics Cloud

Our Organization is in Oracle Saas Cloud for ERP. Oracle Analytics Cloud is the reporting and integration solution that sits on top of Oracle Autonomous Data Warehouse for our data warehousing needs from the fusion ERP cloud. We are piloting OAC for just one department within our organization. Our goal is to make it an enterprise-wide solution for our summarized reporting needs.
  • 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.
  • OAC should allow writing back into Oracle Saas Cloud.
  • OAC Canvas view has some limitations in terms of choosing colors for the chart objects and other objects.
  • It doesn't allow the drill to detail options like that available in classic view for drilling to analysis from canvas view.
We are primarily an Oracle shop. OAC jives well with our business needs and is the most sought after solution if your organization is a major Oracle shop. OAC provides connectors out of the box and makes data analysis a breeze even if it has to be from totally disparate sources. AI and machine learning capabilities are a good forward-looking strategy and is a definite win for the product and its roadmap.
Right now I use Data Sync to extract data from Oracle Fusion Saas Cloud to load into OAC. The issue here is that now we implemented single sign-on, we cannot use data sync to extract files from the UCM content management server. This is one of the biggest challenges for us right now. Otherwise, the out of the box connectors are super helpful and make our experience of connecting disparate sources a breeze.
This is one of the biggest advantages of OAC. Data can be sent across various communication channels like Slack seamlessly. If we use Day by Day App then we can easily track the metrics we want per location by business unit and to gather actionable insights. OAC inherits all the capabilities of OBIEE plus the powerful integration piece. Security is maintained separately but it will be a huge plus if we can automatically inherit the Saas security model within OAC if possible.
Yes - I am part of the OAC group. I would like to be part of the Oracle Machine Learning and predictive analytics groups if there's one. I am also working to get into the Analytics and Data Summit to meet some of the best people in the industry in the Analytics Space. I would also be interested in being part of Oracle Fusion ERP Cloud space.
Oracle Analytics Cloud is well suited for an environment where the data warehouse is well defined with star schema structures. It may not work if the data structure is not well defined in terms of complex reporting. OAC's Day By Day app is a clear win and a cool addition to executives whether it is integration with Slack or for identifying issues in realtime.

Oracle Analytics Cloud Feature Ratings

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