TrustRadius: an HG Insights company

ParAccel

Score8.8 out of 10

3 Reviews and Ratings

What is ParAccel?

ParAccel was a data warehouse appliance (DWA) option, offered by Actian since the April 2013 acquisition of ParAccel as Actian Matrix, that has since been discontinued.

Categories & Use Cases

Reviews

What users are saying about ParAccel.
View all reviews

Actian/Matrix, please do not shut down your shop

Incentivized
Dipankar PradhanView profile
Data Integration Specialist in Information Technology at CARFAX (501-1000 employees employees)

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.

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.

Return on Investment

  • 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.

Other Software Used

Toad Data Point, Informatica Application ILM, SnapLogic

An Integrators view on Actian Matrix DB Platform, or Big Data Storage made simple.

Incentivized
Verified User
Professional in Information Technology (5001-10,000 employees employees)

Pros

  • Handles Various data types from multiple sources.
  • Indexing speed - using the Actian platform as a back end database greatly improved processing time.

Cons

  • 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.

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.

Other Software Used

PowerCenter, Rapid SQL, CollabNet TeamForge

ParAccel - Great software, but deal with its shortcomings

Incentivized
Verified User
Employee in Information Technology (1001-5000 employees employees)

Pros

  • Data loading is excellent
  • ParAccel support is the best I have seen so far.

Cons

  • 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

Return on Investment

  • Faster reports
  • Faster ETL
  • Bugs were annoying and [it was] tough to get the resolution sooner

Other Software Used

PostgreSQL, Amazon Elastic Compute Cloud (EC2), MongoDB, Docker, Nagios

Usability