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

Likelihood to Recommend

Actian Matrix (discontinued)

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.
Anonymous | TrustRadius Reviewer

SAP BW/4HANA

Some scenarios where SAP BW/4HANA is well suited are retail industry, supply chain, finance, warehouse, stocking processes, BI, [and] some finance analytics reporting. Some scenarios where SAP BW/4HANA is less appropriate [is when] relational queries are needed [and] in some small business with infrastructure limitations. Another scenario that is less appropriate is for ABAP processes requirements.
Mirian Pitti | TrustRadius Reviewer

Pros

Actian Matrix (discontinued)

  • Super fast. Aggregate query such as SUM(), Count() returns result within seconds from a table with more than billion records.
  • Excellent data compression.
  • Easy maintenance. We managed this database without having a full time DBA.
  • Support ANSI SQL and ODBC/JDBC. It's easy to connect to this database from other systems.
Dipankar Pradhan | TrustRadius Reviewer

SAP BW/4HANA

  • High speed data warehouse regardless of data volumes.
  • Excellent integration with SAP systems and Data sets.
  • Simplified data modelling due to columnar data base.
Anonymous | TrustRadius Reviewer

Cons

Actian Matrix (discontinued)

  • Some of the bugs were annoying and QA definitely needs improvement
  • Connectivity to Informatica and ETL providers
  • Workload management could be better like when you compare with Teradata
Anonymous | TrustRadius Reviewer

SAP BW/4HANA

  • Enterprise license pricing is very expensive and run-time license limits the usefulness of the tool.
  • Integration with SAP Analytics cloud for write-back to BW/4HANA. Live connection is only read from SAC.
  • Make run-time licenses more useful.
Robert Harper | TrustRadius Reviewer

Usability

Actian Matrix (discontinued)

Actian Matrix (discontinued) 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
Anonymous | TrustRadius Reviewer

SAP BW/4HANA

SAP BW/4HANA 8.5
Based on 2 answers
SAP BW/4HANA requires specialized skillsets around data warehouse modeling and the access to data, however the modeling capabilities are intuitive and have now become accessible to both SAP and non-SAP data warehouse specialists. This new model allows for Interchangeable skillsets and access to a broader pool of experts throughout the industry, as well as easier access to data.
Anonymous | TrustRadius Reviewer

Support Rating

Actian Matrix (discontinued)

Actian Matrix (discontinued) 8.0
Based on 2 answers
  • Faster initial response
  • Trained professionals
  • Very helpful in resolving issues
Anonymous | TrustRadius Reviewer

SAP BW/4HANA

SAP BW/4HANA 9.4
Based on 9 answers
SAP Max Attention and general support for SAP BW/4HANA is broadly available. Truth to be told, MaxAttention has a premium cost but brings great engineers. So this being an enterprise capability and extremely critical, we did not consider cost as the main factor since support works well. Just keep that in mind when making your selection.
Anonymous | TrustRadius Reviewer

Implementation Rating

Actian Matrix (discontinued)

Actian Matrix (discontinued) 6.0
Based on 2 answers
Leader failover setup is the toughest and lack of proper documentation is making things tough.
Anonymous | TrustRadius Reviewer

SAP BW/4HANA

No score
No answers yet
No answers on this topic

Alternatives Considered

Actian Matrix (discontinued)

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.
Anonymous | TrustRadius Reviewer

SAP BW/4HANA

SAP Analytics Cloud is complemented by SAP BW/4 HANA through connectors that work in real-time and allow the display of indicator information in interactive and user-friendly visualizations.SAP Data Services integrates with BW/4 HANA allowing to automate the loading of information in the system taking as a data source a wide variety of platforms.
Martin Lopez | TrustRadius Reviewer

Return on Investment

Actian Matrix (discontinued)

  • ROI is great, less spending on full time DBA and that money could be use to add additional node.
  • Negative - Not many developers are well aware of this tool, it takes some time to learn.
Dipankar Pradhan | TrustRadius Reviewer

SAP BW/4HANA

  • Faster turn-around to enhancements
  • End users can query structures that are not limited to multi-dimensional models.
  • Performance improvements means that business user can do more in the same time compared to traditional BW
Mark Villazon | TrustRadius Reviewer

Screenshots

Pricing Details

Actian Matrix (discontinued)

General

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

SAP BW/4HANA

General

Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Yes
Entry-level set up fee?
Optional

Add comparison