What users are saying about

Actian Matrix

3 Ratings

SAP BW

76 Ratings

Actian Matrix

3 Ratings
Score 8.6 out of 101

SAP BW

76 Ratings
Score 7.5 out of 101

Add comparison

Likelihood to Recommend

Actian Matrix

Actian matrix is not good for small data sets. If you have a limited data pool, or do not plan on having multiple users/clients accessing a data source, stick with a more traditional relational database model - Access for the truly small user base, or a DB2 or Oracle back end if your going to have multiple users, and moderate sized data. Actian is for LARGE data sets (Big Data, in the industry parlance). Millions of rows of data from multiple sources with various down stream systems accessing the database. It is for data analytics of large data groups and intense data mining.
No photo available

SAP BW

I used it for one of our customers to predict the future performance. SAP BW provides the result very seamlessly and accurately which ultimately improved the business for our client. From my point of view SAP BW best suits for the business where the data modeling and special warehouse reporting is necessary on a regular basis for getting financial, customer, sales, stakeholders etc data.
Pradeep Bele profile photo

Pros

  • Handles Various data types from multiple sources.
  • Indexing speed - using the Actian platform as a back end database greatly improved processing time.
No photo available
  • Data replication from SAP ERP or other SAP systems (like SAP CRM, SAP APO).
  • Data transformation from SAP ERP.
  • Data warehousing capabilities.
Julius Shen profile photo

Cons

  • Dashboard for Admin instead of a linux console.
  • Admin with ability to kill inactive sessions when sessions reaches to more than allowed sessions. We ended up restarting the database.
  • Ability to easily scale up database by adding extra node.
  • Better support from Actian.
Dipankar Pradhan profile photo
  • Long cycle time from data preparation to reporting.
  • Below par standard reporting user interface when using Business Explorer (BEx) reporting tool.
  • Additional SAP products required for self-service capability and dashboarding.
Julius Shen profile photo

Usability

Actian Matrix6.0
Based on 1 answer
I wish to give higher rating for the speed and efficiency in handling the queries, but only 6 because of consistent bugs we encounter
No photo available
No score
No answers yet
No answers on this topic

Support

Actian Matrix8.0
Based on 1 answer
  • Faster initial response
  • Trained professionals
  • Very helpful in resolving issues
No photo available
No score
No answers yet
No answers on this topic

Implementation

Actian Matrix6.0
Based on 1 answer
Leader failover setup is the toughest and lack of proper documentation is making things tough.
No photo available
No score
No answers yet
No answers on this topic

Alternatives Considered

Actian Matrix is our first big data analytics storage platform, and as I was not involved in the POC process to compare it to other products out on the market, unfortunately I cannot say if it is better than other Big Data storage options. I can say that it out performs products such as Oracle or UDB in regards to the volume of data it can easily index and handle.
No photo available
We have been considering using SAP BW for a long time and we have seen great support. The upgraded version availibility, is why we like SAP BW on HANA with great real-time reporting features. It is super fast and the respective department can get the results very quickly. Now we are planning to utilize BW4HANA with its optimized features. We will implement and utilize them accordingly.
Pradeep Bele profile photo

Return on Investment

  • I cannot comment on the specific numbers, all I can say is that switching to the backend greatly improved our processing speed. The more we process through our systems, the more clients we can serve. Which should bump ROI.
No photo available
  • The positive Return on Investment we receive with the software was the ability to import decades of data. We were then able to review the materials see trends we were previously unable to see without intense work.
  • The only negative impact was applying the training and changing procedures to deal with the software. This worked out, obviously, because this is not a software to be using without proper training.
Alfred Brock profile photo

Pricing Details

Actian Matrix

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

SAP BW

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