2 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 4.9 out of 100
14 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 9 out of 100

Likelihood to Recommend

Actian Vector (formerly 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.
Anonymous | TrustRadius Reviewer

Azure Synapse Analytics (Azure SQL Data Warehouse)

It is very well suited for big data analytics. Predictive modeling, optimization, and other large scale analysis benefit from using a properly defined SQL Data Warehouse. It is also suited for simple business intelligence such as building historical and active dashboards
Anonymous | TrustRadius Reviewer

Pros

Actian Vector (formerly VectorWise)

  • Quick response for queries involving multi-million rows
  • Low cost
Anonymous | TrustRadius Reviewer

Azure Synapse Analytics (Azure SQL Data Warehouse)

  • It is very cost-effective
  • Development time needed was much less in comparison to other systems
  • Played very nicely with our ETL and OLAP reporting tools
Samir Patel, PMP | TrustRadius Reviewer

Cons

Actian Vector (formerly VectorWise)

  • Concurrent user handling
  • Handling parallel ETL processes
Anonymous | TrustRadius Reviewer

Azure Synapse Analytics (Azure SQL Data Warehouse)

  • Automated query tuning.
  • Better indexing methods.
Anonymous | TrustRadius Reviewer

Support Rating

Actian Vector (formerly VectorWise)

No score
No answers yet
No answers on this topic

Azure Synapse Analytics (Azure SQL Data Warehouse)

Azure Synapse Analytics (Azure SQL Data Warehouse) 9.0
Based on 2 answers
I like their Support team
Anonymous | TrustRadius Reviewer

Alternatives Considered

Actian Vector (formerly VectorWise)

Oracle>DB2>MS SQL Server>GreenPlum>Vectorwise
Anonymous | TrustRadius Reviewer

Azure Synapse Analytics (Azure SQL Data Warehouse)

SQL Data Warehousing is much easier to manage if you already have SQL Server experience and analysts who are familiar with its interface. We are currently piloting using NoSQL and Hadoop type databases but it is difficult to get set up properly. Additionally, we have to re-train our users to learn how to create python scripts and use spark to query the data
Anonymous | TrustRadius Reviewer

Return on Investment

Actian Vector (formerly VectorWise)

  • We had to move out of VectorWise after using the database for 2 years. Hence no positive impacts.
Anonymous | TrustRadius Reviewer

Azure Synapse Analytics (Azure SQL Data Warehouse)

  • We have had an improvement in our overall processing time
  • Cost was much lower than most of its competitors
  • Our reporting needs have grown and housing the data here has been great
Samir Patel, PMP | TrustRadius Reviewer

Pricing Details

Actian Vector (formerly VectorWise)

General

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

Azure Synapse Analytics (Azure SQL Data Warehouse)

General

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

Add comparison