OpenText Analytics

18 Ratings
Score 6.7 out of 101

Oracle Business Intelligence Cloud Service

16 Ratings
Score 8.2 out of 101

Add comparison

Likelihood to Recommend

OpenText Analytics

If you do not have a large budget and are a large organization, I would steer clear of Actuate. If you are looking to do very complex washboarding, I would not use them. Your developers have to be very skilled to work with this. Plan to bring in consultants if necessary to help your process. Adhoc reporting is weak. If your pricing is user based and you expand, this could be very expensive.
Christopher Noyes profile photo

Oracle Business Intelligence Cloud Service

Well suited:Perfect for organizations where they have multiple databases and they have to damp everything in a single tool. This is helpful not only to joint databases together (shipments with POS data for example) but also for employees to learn only ONE tool to get all the data they from different sources.Less appropriate:If you need to go deep into analyzing the data beyond a table. The data visualization properties are pretty limited compared to Tableau/Power BI/Spotfire.
Gabriel Chiararia profile photo

Feature Rating Comparison

Ad-hoc Reporting

OpenText Analytics
4.5
Oracle Business Intelligence Cloud Service
Drill-down analysis
OpenText Analytics
6.0
Oracle Business Intelligence Cloud Service
Formatting capabilities
OpenText Analytics
3.0
Oracle Business Intelligence Cloud Service

Pros

  • In terms of extensibility this is the best reporting platform we have seen. You can build very sophisticated reports with different data sources, and extend the basic functionality with javscript code
  • Securing the BI system is also a strength and the system can be configured relatively easily.
  • Reports can be available on mobile devices
  • Good Javascript embedding framework does not require the site to be built in java
Christopher Noyes profile photo
  • 1: Data Integration: I love that at Whirlpool we have several different databases in the same place and we can extract and combine data easily.
  • 2: Connection with multiple systems: A lot of companies use Oracle Business Intelligence Cloud Service, so it means that they are seeing a lot of different use cases and improving the tool constantly.
  • 3: Data extraction: Extracting data is much easier than writing a SQL code. So many different types of users can take advantage of that.
Gabriel Chiararia profile photo

Cons

  • We have found a ton of bugs in there, our implementation is very complex and we use a lot of features, but we wish there were less bugs. Particularly with parameter display and validation.
  • Actuate has decided not to continue to support the birtondemand platform and it is running on older versions of their main platform.
  • Building out security extensibility is rather complex.
  • They have not had a rest interface until new versions of iHub.
Christopher Noyes profile photo
  • 1: User-friendliness: As I said, you don't need to write a SQL code to extract data, but I've seen some other tools (the previous Oracle Cloud system for example) that were easier than this new one.
  • 2: Speed: The tool is not slow, but when multiple users are trying to query information in the same database, it might get pretty slow. It's very common for people to run queries during the night since it's faster at that period once no one is using the tool
  • 3: Data visualization: The main output is basically a table, if you want to get fancy graphs or other types of output, you might want to export it to Tableau/Power BI/Spotfire.
Gabriel Chiararia profile photo

Likelihood to Renew

OpenText Analytics3.9
Based on 9 answers
This rating would be a 10 if the licensing structure were more accommodating.
Amy Broome profile photo
No score
No answers yet
No answers on this topic

Support

OpenText Analytics9.1
Based on 1 answer
Always there on the front and backend for us and the client.
Jeffrey Fischer profile photo
No score
No answers yet
No answers on this topic

Breadth of Deployment

Actuate was used by the indirect procurement team and the maintenance departments company wide across many facilities. Well over 100 concurrent users at anytime. Actuate was used across vast majority of locations with the ERP solution we had at the time.
Todd Bellamy profile photo
No answers on this topic

Alternatives Considered

Actuate has a HUGE number of features that can tie nicely into almost any ERP but it takes some time to learn and the development community was relatively small compared to the Crystal Reports alternative. Crystal was far easier to learn and had a massive support base. Probably because it is now owned by SAP.
Todd Bellamy profile photo
Better:Easy integration with different systems (internal, such as SAP; or external, such as data coming from tables from your vendors). Many companies use it and it's a good tool to learn. In my case, I learned at P&G and when I moved to Whirlpool I already learned how to use it! And I use it very often in my role.Worse:Well, if I need to do anything beyond a table, line or bar chart, I export the data and use a different tool.
Gabriel Chiararia profile photo

Collaboration and Sharing

OpenText Analytics6.1
Based on 7 answers
Having more that one developer working on Actuate reports became quite a problem because once a report was compiled it was published to the server. The published file then could not be decompiled and the design files had to be stored in a particular shared location on the server. Also, I experienced issues leaving code notes in the SQL statements of the reports when I tried to compile them
Todd Bellamy profile photo
Oracle Business Intelligence Cloud Service7.1
Based on 3 answers
I liked the fact that you can set up reports to be sent out on a daily basis. I was able to automate a few reports and save tens of thousands of dollars in third-party labor by creating automated Oracle Business Intelligence reports. You can also save and share your reports pretty easily - but it feels like an old type of software.
Gabriel Chiararia profile photo

Data Integration

OpenText Analytics7.7
Based on 7 answers
This was a feature of Actuate I almost forgot. You could connect to number of different data sources across the organization from Oracle to MySQL and just about everything in between. Also if you have multiple environments of the same system (DEV,QA,PROD) you can change the connection string each time you compile the same report to promote changes. This was easier then changing the connections in alternative software like Crystal Reports
Todd Bellamy profile photo
Oracle Business Intelligence Cloud Service7.9
Based on 3 answers
As I said before, Whirlpool connects a lot of different sources to Oracle Business Intelligence Cloud Service. I was surprised! It seems that 80%+ of the data I need is seating on this platform. I'm not sure how easy it is to set up to different data sources, I remember that at P&G they were struggling with it.
Gabriel Chiararia profile photo

Return on Investment

  • Actuate can handle 50 to 60 sub reports inside a report very well.
  • Dynamically creating the datasource, chart, graph, reports are the main advantages. We can do any level of drilling, and can create a performance matrix dashboard efficiently.
No photo available
No answers on this topic

Pricing Details

OpenText Analytics

General
Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No
Additional Pricing Details

Oracle Business Intelligence Cloud Service

General
Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No
Additional Pricing Details