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
17 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener'>trScore algorithm: Learn more.</a>
Score 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

Teradata Data Warehouse Appliance 2850

Teradata is most suited when needing to get data for a specific purpose. If you need to report data and display it, this application is not as well suited. It should only be used to store and access data. It does a good job of organizing the data. You can get your dataset at a place where little to no additional tweaking would be needed in other applications.
Anonymous | 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

Teradata Data Warehouse Appliance 2850

  • Can query multiple databases within one server and view all results in one window. Helps speed up analysis.
  • Teradata uses AMPs (Access Module Processors) to increase speed of data processing/queries. You must use 'COLLECT STATISTICS' properly to efficiently use the AMPs.
  • Most standard SQL practices work on Teradata. Also, Teradata formats the query in a nice colored structure.
  • Can search for tablenames or specific columnnames across the entire server. Helps when changing a specific column or table structure.
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

Teradata Data Warehouse Appliance 2850

  • Sometimes it isn’t clear the reason an error will occur in the query. More detailed responses would be helpful
  • It can be slow at times when pulling large data amounts
  • Sometimes spool space will run out when trying to run certain queries
Anonymous | 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

Teradata Data Warehouse Appliance 2850

No score
No answers yet
No answers on this topic

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

Teradata Data Warehouse Appliance 2850

No score
No answers yet
No answers on this topic

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

Teradata Data Warehouse Appliance 2850

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

Teradata Data Warehouse Appliance 2850

To be fair, I didn’t select Teradata. I do think that they are comparable. There are some things SQL server does better than Teradata and vice versa. For example, sql server will underline potential errors while you are coding. It also will auto-populate table and column names so you don’t need to have the exact name before submitting your query.
Anonymous | 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

Teradata Data Warehouse Appliance 2850

  • Enabled next-day reporting.
  • Better customer service as field technicians can see instant performance.
  • Needed to hire more employees for overnight support.
Anonymous | TrustRadius Reviewer

Pricing Details

Actian Matrix (discontinued)

General

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

Teradata Data Warehouse Appliance 2850

General

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

Add comparison