What users are saying about
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
8 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 8.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 HANA Express Edition

Well suited:Existing Business Intelligence solutions running on other relational databases that do not make use of in-memory and columnar store technologies. Environments where developers want to run a copy of the database on their laptop.Less suited:Existing Business Intelligence solutions running on other relational databases do not make use of in-memory and columnar store technologies.
No photo available

Pros

  • 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 profile photo
  • Very fast query response times due to in-memory architecture
  • Virtualized data architecture via connectivity to other databases and data sources
  • Column store and Efficient compression of data
  • Integration with R server from the database
No photo available

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
  • No first line support from SAP
No photo available

Likelihood to Renew

Actian Matrix6.0
Based on 1 answer
No answer on this topic is available.
SAP HANA Express Edition7.9
Based on 3 answers
It is free for production use and provides all of the features that we need.
No photo available

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
SAP HANA Express is free for production use with most of the features available in the full HANA tech stack. It also provided better integration with the SAP Bussiness Objects suite than the others.
No photo available

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
  • Data Analysts are able to complete their analysis much faster (4 hours vs 4 - 5 days)
  • Resource intensive summarization processes could be decommissioned as the data can be stored at the lowest grain. This saves on resource/licensing costs and gives the business near real-time access to their data.
No photo available

Pricing Details

Actian Matrix

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

SAP HANA Express Edition

General
Free Trial
Free/Freemium Version
Yes
Premium Consulting/Integration Services
Yes
Entry-level set up fee?
Optional
400 euro*
1.  per additional 32 GB memory increase
Additional Pricing Details
64GB USD 428.00/month; 96GB USD 856.00/month; 128GB USD 1,284.00/month.