ParAccel - Great software, but deal with its shortcomings
July 19, 2016

ParAccel - Great software, but deal with its shortcomings

Anonymous | TrustRadius Reviewer
Score 6 out of 10
Vetted Review
Verified User

Overall Satisfaction with ParAccel

I used it in MicroStrategy Cloud. It is used as one of the big data solutions provider for all the performance tier customers. Apart from MicroStrategy Cloud, it was also used with MicroStrategy wisdom and MicroStrategy Social softwares. It definitely solved the slower queries that were pestering in SQL Server and Oracle. It is the best in loading the data into the database.
  • Data loading is excellent
  • ParAccel support is the best I have seen so far.
  • 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
  • Faster reports
  • Faster ETL
  • Bugs were annoying and [it was] tough to get the resolution sooner
My comparison with Vertica: ParAccel stays at top because we do not know the projections ahead of time (which is a major performance tuning technique in Vertica)

My comparison with Netezza/Teradata: Definitely, ParAccel is economical, but if you can afford it, go for other providers as they are stable.
PostgreSQL, Amazon Elastic Compute Cloud (EC2), MongoDB, Docker, Nagios
It is one of the best fit for data analytics, but if the database is smaller than 500GB then it is less appropriate.

Using ParAccel

  • Speed
  • Columnar structure
  • Compression
  • Columnar storage
  • Compression to 10:1 ratio
  • Backup and restore
  • Workload management

Evaluating ParAccel and Competitors

  • Price
  • Product Features
  • Product Usability
  • Prior Experience with the Product
I would have reviewed workload management more, especially managing the number of concurrent heavy and lighter queries.

ParAccel Implementation

Leader failover setup is the toughest and lack of proper documentation is making things tough.
  • Implemented in-house
  • Professional services company
  • Getting OS configuration right
  • Less documentation made the setup tough

ParAccel Support

  • Faster initial response
  • Trained professionals
  • Very helpful in resolving issues
Quick Resolution
Good followup
Knowledgeable team
Problems get solved
Kept well informed
No escalation required
Immediate help available
Support cares about my success
Quick Initial Response
Yes - Yes, a hot fix was deployed very fast just to address my bug. Very impressive!!!
For the leader failover setup, a particular version of Corosync was giving an issue. Support directly jumped in and solved it for me.

Using ParAccel

I wish to give higher rating for the speed and efficiency in handling the queries, but only 6 because of consistent bugs we encounter.
Like to use
Feel confident using
Requires technical support
Lots to learn
  • Table creation
  • Understanding columnar nature of storage
  • Backup
  • Incremental restore
  • Data Compression
  • Workload management