What users are saying about
3 Ratings
89 Ratings
3 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 8.7 out of 101
89 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 7.6 out of 101

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

SAP BW is best for:1. Large enterprises2. Enterprises with 3+ legacy systems with entrenched users (politically difficult to merge)3. Enterprises with employees who can understand both the technical capabilities of SAP BW and the needs of the business users - ability to speak both languages, otherwise the program could be unwieldy and potentially underutilized (it's not particularly inexpensive)SAP BW is less appropriate for:1. Small enterprises2. Enterprises who have well established, same location, CRM and UFS - the integration of data analysis will be easier and less expensive with other solutions3. HANA
Jeff Looby, CPA profile photo

Pros

Actian Matrix

  • 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

SAP BW

  • Integrates, stores, and manages company data from all sources
  • Pre-configured information models are better than average
  • Security authorization protocols and flexibility
  • Integration capabilities
Jeff Looby, CPA profile photo

Cons

Actian Matrix

  • Its a new product, there are plenty of bugs to work out with regards to converting special reserve characters that might crop up in data.
  • The Matrix 2 Matrix database port tool needs some ironing out.
No photo available

SAP BW

  • Certain pruning can only take place on metadata rather than posted data
  • High runtimes for query execution
  • Results still requires fairly significant data verification time and effort
  • Infocube requires significant optimization efforts
Jeff Looby, CPA profile photo

Usability

Actian Matrix

Actian Matrix 6.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

SAP BW

SAP BW 9.0
Based on 1 answer
It basically stores all data I need in designed reports, which helps a lot with the analysis and calculation.It's quite interactive when you understand reports and know how to drill-down/swap. Fresh users might need some training. There are quite a lot of options to display data differently, or to add more filters in data as well as to extract the data in xlsx/csv/html format.
No photo available

Support

Actian Matrix

Actian Matrix 8.0
Based on 1 answer
  • Faster initial response
  • Trained professionals
  • Very helpful in resolving issues
No photo available

SAP BW

No score
No answers yet
No answers on this topic

Implementation

Actian Matrix

Actian Matrix 6.0
Based on 1 answer
Leader failover setup is the toughest and lack of proper documentation is making things tough.
No photo available

SAP BW

No score
No answers yet
No answers on this topic

Alternatives Considered

Actian Matrix

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

SAP BW

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

Actian Matrix

  • 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

SAP BW

  • 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

Add comparison