TrustRadius
Run Away from VectorWise if implementing Enterprise Data WatehouseVectorWise was tested and the quick response for SQL involving massive data was one of the attractive features. The cost was also low as compared to the commercial databases. But after implementing multiple projects in VectorWise we learned it handles parallel ETL loads and high concurrent user poorly. Most of the time with users logged in to BI tools on top of VectorWise the database became dormant and we had to restart the server. ETL loads when run for a single project would run fine, but with multiple project ETL starting in parallel, the databse would respond very poorly. After close to two years we decided to move away from VectorWise and decommissioned VectorWise. VectorWise was a bad candidate to be the enterprise data warehouse database. For a data mart or ODS it may be a suitable candidate.,Quick response for queries involving multi-million rows Low cost,Concurrent user handling Handling parallel ETL processes,4,We had to move out of VectorWise after using the database for 2 years. Hence no positive impacts.,,Tableau Desktop, Tableau Server, Talend Integration Suite
Unspecified
VectorWise
2 Ratings
Score 4.9 out of 101
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>TRScore

VectorWise Reviews

VectorWise
2 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 4.9 out of 101
Show Filters 
Hide Filters 
Filter 2 vetted VectorWise reviews and ratings
Clear all filters
Overall Rating
Reviewer's Company Size
Last Updated
By Topic
Industry
Department
Experience
Job Type
Role
Reviews (1-1 of 1)
  Vendors can't alter or remove reviews. Here's why.
No photo available
December 05, 2015

Review: "Run Away from VectorWise if implementing Enterprise Data Watehouse"

Score 4 out of 10
Vetted Review
Verified User
Review Source
VectorWise was tested and the quick response for SQL involving massive data was one of the attractive features. The cost was also low as compared to the commercial databases. But after implementing multiple projects in VectorWise we learned it handles parallel ETL loads and high concurrent user poorly. Most of the time with users logged in to BI tools on top of VectorWise the database became dormant and we had to restart the server. ETL loads when run for a single project would run fine, but with multiple project ETL starting in parallel, the databse would respond very poorly. After close to two years we decided to move away from VectorWise and decommissioned VectorWise. VectorWise was a bad candidate to be the enterprise data warehouse database. For a data mart or ODS it may be a suitable candidate.
  • Quick response for queries involving multi-million rows
  • Low cost
  • Concurrent user handling
  • Handling parallel ETL processes
VectorWise is suitable to be a departmental data mart database or an operational data store (ODS). It is not suitable for enterprise data warehouse database.
Read this authenticated review

VectorWise Scorecard Summary

About VectorWise

Categories:  Data Warehouse