Vertica Alternatives and Competitors

What is most valuable?

The most valuable feature would be the fact that it has been running for awhile in an appliance format. The appliance format may be the best part.

How has it helped my organization?

We're looking to get away from it, so I can't really say that it improved things. It did augment some of our product delivery resources.

What needs improvement?

There won't be another release. They're converting to DB2 and that is one of the reasons we are looking at other options. In terms of features that I would like to see, one is the ability to actually… more»

Which solution did I use previously and why did I switch?

We're looking to switch away from Netezza because the platform database system that it runs on is no longer going to be in existence. It's moving to DB2. If it moves to that direction, the amount of… more»

What other advice do I have?

I rate Netezza at four out of 10. There is not too much involved to set one up from a customer perspective, but after the initial setup it is pretty awful on the customer support side of it. My advice… more»

Which other solutions did I evaluate?

Vertica was one of them. I looked at it recently. It has limiting factors on things like updates and deletes of data, where it has performance issues. That's a big problem for us.

What is most valuable?

* Computing unit is accessible via SQL: being able to turn them on or off as needed. * Snowpipe (ingesting data) * Looking back in time (being able to look at data in the past within a query) * No… more»

How has it helped my organization?

We were able to implement the entire data eco-system in less than five months, from data integration, data warehousing, ELT, producing fact and dimensional tables, and finally reports.

What needs improvement?

* Snowpipe auto-ingest should be automatic. * A better client UI or command line tool: I think SnowSQL is a little awkward.

What's my experience with pricing, setup cost, and licensing?

Snowflake computing is very affordable. Less expensive than Redshift.

Which solution did I use previously and why did I switch?

Used it at a previous company.

Which other solutions did I evaluate?

Yes. I looked at Redshift and Vertica.