Run Away from VectorWise if implementing Enterprise Data Watehouse
Anonymous | TrustRadius Reviewer
December 05, 2015

Run Away from VectorWise if implementing Enterprise Data Watehouse

Score 4 out of 10
Vetted Review
Verified User
Review Source

Overall Satisfaction with VectorWise

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
  • We had to move out of VectorWise after using the database for 2 years. Hence no positive impacts.
Oracle>DB2>MS SQL Server>GreenPlum>Vectorwise
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.