We performed a comparison between Exasol and Vertica based on real PeerSpot user reviews.
Find out what your peers are saying about Microsoft, Oracle, SAP and others in Relational Databases Tools."The solution is hands-off; you set it up insert your data and it self tunes queries."
"We can quickly scale the solution as it works on an MPP system."
"The most valuable feature of Exasol is its speed."
"The speed is very good compared to other databases, like SQL Server or Oracle."
"We mainly chose Exasol for its performance reasons."
"Performance is a top priority, and it excels in this aspect."
"It is easy to scale."
"Its speed is great."
"Vertica is easy to use and provides really high performance, stability, and scalability."
"The most valuable feature of Vertica is the ability to receive large aggregations at a very quick pace. The use case of subclusters is very good."
"I appreciate the flexibility offered by Vertica's projections. It allows for modifying the primary projection without altering the tables, which helps to optimize queries without the need to modify the underlying data."
"Integrated R and geospatial functions are helping us improve efficiency and explore new revenue streams. "
"DBAs don’t need to add a partition every month/quarter like with other DBs."
"Initiate on one node, and the RPM propagates automatically to all other nodes. "
"The fast columnar store database structure allows our query times to be at least 10x faster than on any other database."
"I don't need any special hardware. I can use commodity hardware, which is nice to have in a commercial solution."
"Lacks a cloud-based platform."
"It would be beneficial if the updates would occur more often."
"There are limited resources available to help me resolve the issue with Exasol."
"The only area where we found it could improve was in custom role creation and security, and it was difficult to work with."
"They should improve the security features for MPP processing."
"You have to install Exasol drivers, and it's not easy to find or implement a driver into different systems."
"It's not cloud-native so many maintenance operations require downtime."
"They don't talk very well to with other products when it comes to connectivity. Integration is lacking."
"Documentation has become much better, but can always use some improvement."
"Vertica seems to scale well, except for one use case where you are on a multi-node cluster. For example, if you had a nine-node cluster, one node goes down, then the eight nodes don't scale, because the absence of the node is very apparent, which is a problem. If you have nine nodes or multiple nodes, the whole idea is that if one of those nodes goes down, then you should not see an impact on the system if you have enough capacity. Even though we have enough capacity, you can still see the impact of the one node going down."
"Metadata for database files scale okay, but metadata related to tables/columns/sequences must be stored on all nodes."
"I would personally like to see extended developer tooling suited to Vertica – think published PowerDesigner SQL dialect support."
"Suboptimal projection design causes queries to not scale linearly."
"Monitoring tools need to be lightweight. They should not take up heavy resources of the main server."
"It should provide a GUI interface for data management and tuning."
"Vertica offers a platform-as-a-service version, but their software-as-a-service solution is only available on AWS. They need to get a SaaS version on Azure and GCP as fast as possible."
Exasol is ranked 12th in Relational Databases Tools with 8 reviews while Vertica is ranked 4th in Data Warehouse with 83 reviews. Exasol is rated 8.0, while Vertica is rated 8.2. The top reviewer of Exasol writes "Fast query processing and easy-to-store all the data". On the other hand, the top reviewer of Vertica writes " A user-friendly tool that needs to improve its documentation part". Exasol is most compared with SAP HANA, SQL Server, Oracle Database In-Memory, MySQL and Oracle Database, whereas Vertica is most compared with Snowflake, SQL Server, Amazon Redshift, Teradata and Oracle Exadata.
We monitor all Relational Databases Tools reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.