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

Teradata Enterprise Data Warehousing

Teradata is the premier analytic platform. If you need to enable real-time access to multiple terabytes/petabytes of your organization's data to help you make real-time decisions in a way that translates into real dollars in sales and strengthened customer relationships then there is no better choice. Teradata is NOT an OLTP appropriate database and it may not be the best place to process all your data but as far as enabling your Analytic enterprise Teradata is always going to provide the best ROI for medium and large enterprises and now with new cloud integration even small enterprises can have the advantages of Teradata that used to be only available to the larger enterprises.
No photo available

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
  • The Teradata Enterprise provides the best workload management bar none. There is virtually no analytic task that it can not handle. It is designed to handle mixed workloads and it shows. Tactical query related reports and applications can easily be given high priority while more processing intensive queries can be throttled and prioritized internally like a finely tuned data super highway so to prevent data traffic jams and allow the entire enterprise to be served efficiently.
  • Designed to be easily maintained. Teradata requires very little maintenance compared to other enterprise DBs. Also, the integrated Viewpoint server provides a central view of the enterprise data-warehouse and supports servers. It also has convenient direct integration with DSA backups and supports analytic data labs that can be used to empower users.
  • Teradata supports all the latest analytic open source languages and has advanced APIs that can be easily be leveraged within custom scripts and applications. The feature set integrated out of the box in Teradata is something few competitors can match. It also supports Map Reduce and other analytic functions natively in the database.
  • The new Teradata Enterprise in the Cloud on AWS makes changing node configurations to handle increased workloads a matter of hours rather than weeks type process and rather than dealing with trying to reinvent the wheel with a new infant "open source" or "new" cloud database that is missing core features that mature databases like Teradata have supported for years as a customer you get the maturity as well the cutting edge cloud capabilities in a no-compromise solution.
  • Teradata Intellicloud support provides pain-free management of the cloud environment. It handles the backups and manages EC2 instances to keep everything running smoothly.
  • The Teradata Querygrid product provides a level of interoperability between itself and competitor and open sources data sources without having to design complex ETL.
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
  • Teradata can improve by supporting more native AWS cloud features. Currently if a node goes down the EC2 instance must be restarted. It isn't something that happens frequently but more tight integration with cloud providers like AWS and Azure will allow Teradata to offer truly dynamic scaling.
  • Some Teradata features are oversold before they are ready for prime-time. Teradata is not unique in this but if something is sold as an integrated product stack it should really be integrated not something that requires an extensive development cycle to be integrated at a customer's expense. If something is supported it should've really be tested and QAed thoroughly before a customer touches it.
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
Teradata is the leader in Data Warehousing bar none based on independent experts like Gartner and our experience aligns with this.
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
  • Moving to Teradata in the Cloud-enabled a level of agility that previously didn't exist in the organization. It also enabled a level of analytic competency that was not achievable using other options on the aggressive timeline that was required. We didn't want to settle for reinventing a wheel when we had a super tuned performance capable beast readily available in Teradata. Teradata lets us focus on our business rather than spending money and effort trying to design software or database foundations features on an open source or lower performance platform.
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

Teradata Enterprise Data Warehousing

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