What users are saying about
<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow'>Customer Verified: Read more.</a>
123 Ratings
2 Ratings

Amazon Redshift

<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow'>Customer Verified: Read more.</a>
123 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 8.3 out of 101
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

Likelihood to Recommend

Amazon Redshift

For data warehousing and analytics, Redshift can't be beat. It's price point, minimal maintenance, and OLAP query optimization make it excellent for querying and reporting for an organization with a small budget. As long as you can live without some standard database tools like constraints and stored procedures, it is an excellent database.
Seth Goldberg profile photo

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.
No photo available

Pros

Amazon Redshift

  • We can connect with multiple servers and can fetch the data easily from one server to other.
  • It supports the syntax of the bots of the SQL servers, MS SQL and Oracle SQl. This makes it pretty handy to use.
  • Here we use views instead of tables, so we can clearly see the flow of data.
Akshaya Bhardwaj profile photo

VectorWise

  • Quick response for queries involving multi-million rows
  • Low cost
No photo available

Cons

Amazon Redshift

  • It works very slow in the cloud environment.
  • No statistical inbuilt functions are available within the tool.
  • Its user interface is not very attractive.
  • Often it goes into deadlock state, which kills the running jobs.
Akshaya Bhardwaj profile photo

VectorWise

  • Concurrent user handling
  • Handling parallel ETL processes
No photo available

Usability

Amazon Redshift

Amazon Redshift 8.6
Based on 8 answers
Providing a great interface for queering the complex dataset and also provides a wide range of libraries for multi-language support. But initial setup and schema design and modification is complex compared to others.
No photo available

VectorWise

No score
No answers yet
No answers on this topic

Alternatives Considered

Amazon Redshift

Snowflake supports semi-structured data types and provided solutions to manage/process the semi-structured data. It supported sharing data between the different accounts and makes it easy in the scale and scale down process. Snowflake doesn't limit users on the database.
Jacob Biguvu profile photo

VectorWise

Oracle>DB2>MS SQL Server>GreenPlum>Vectorwise
No photo available

Return on Investment

Amazon Redshift

  • To be honest, we haven't yet seen the return, as we aren't yet operating at scale. So we haven't seen the positive impacts, only the added engineering overhead of dealing with Redshift's eccentricities.
Kyle Reichelt profile photo

VectorWise

  • We had to move out of VectorWise after using the database for 2 years. Hence no positive impacts.
No photo available

Pricing Details

Amazon Redshift

General

Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No
Additional Pricing Details

VectorWise

General

Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
Additional Pricing Details

Add comparison