Item: ParAccel
Rating: 6
Author: Verified User

Overall Satisfaction with ParAccel

Use Cases and Deployment Scope

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.

Pros and Cons

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

Alternatives Considered

Vertica, Teradata Database and IBM Netezza Data Warehouse Appliances

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.

Other Software Used

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

Likelihood to Recommend

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

Users and Roles

100

Support Headcount Required

Business Processes Supported

Speed
Columnar structure
Compression

Innovative Uses

Columnar storage
Compression to 10:1 ratio
Backup and restore

Future Planned Uses

Workload management

Likelihood to Renew

Evaluating ParAccel and Competitors

Products Replaced

Yes

Key Differentiators

Price
Product Features
Product Usability
Prior Experience with the Product

Evaluation Lessons Learned

I would have reviewed workload management more, especially managing the number of concurrent heavy and lighter queries.

ParAccel Implementation

Implementation Rating

Leader failover setup is the toughest and lack of proper documentation is making things tough.

Implementation Details / Implementation Partner

Implemented in-house
Professional services company

Implementation Phases

Yes

Implementation Issues

Getting OS configuration right
Less documentation made the setup tough

ParAccel Support

Support Rating

Faster initial response
Trained professionals
Very helpful in resolving issues

ParAccel Customer Support Pros and Cons

Pros	Cons
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	None