We use the solution for various tasks, including preparing data marts and generating offers. It helps extract data based on rules from the policy team and provides insights to enhance business operations. We also analyze transactions to target customers and improve business performance.
Vertica by the Hour, Red Hat
OpenTextExternal reviews
210 reviews
from
and
External reviews are not included in the AWS star rating for the product.
Processes query faster through multiple systems simultaneously, but it could support different data types
What is our primary use case?
How has it helped my organization?
The platform has improved our organization by providing faster data retrieval and cost-effective solutions compared to other databases like Oracle. The columnar storage format allows for quicker data processing and reduced costs.
What is most valuable?
The most valuable feature is the speed of data retrieval. Compared to Sybase, Vertica processes queries faster by executing them across multiple systems simultaneously.
What needs improvement?
The product could improve by adding support for a wider variety of data types and enhancing features to better compete with other databases.
For how long have I used the solution?
I have been working with Vertica for five years.
What do I think about the stability of the solution?
The product is stable. I rate the stability an eight.
What do I think about the scalability of the solution?
The product is scalable. However, there is room for improvement. I rate the scalability a seven.
How are customer service and support?
In my organization, I frequently reach out to the support team for assistance. They provide guidance when we encounter issues related to Vertica, such as problems with heavy queries or permission issues.
How would you rate customer service and support?
Positive
Which solution did I use previously and why did I switch?
I previously used Sybase but switched to Vertica for its superior speed and cost-effectiveness.
How was the initial setup?
The initial setup was straightforward. I rate the process a seven.
What about the implementation team?
We implemented the solution with the help of our in-house team.
What's my experience with pricing, setup cost, and licensing?
The solution is relatively cost-effective. Pricing and licensing are reasonable compared to other solutions.
What other advice do I have?
I rate Vertica a seven out of ten.
Used for different business analytics, but its native cloud support could be improved
What is our primary use case?
We use Vertica for different business analytics, like IPTV and viewership analytics.
What is most valuable?
Vertica is easy to use and provides really high performance, stability, and scalability.
What needs improvement?
Vertica's native cloud support could be improved, and its installation could be made easier. It's possible to deploy the solution on different hyperscalers, but it's not an easy process. Vertica is an MPP database, and sometimes, some nodes may fail. It could have a better warning system to let us know if we use all the storage space.
For how long have I used the solution?
I have been using Vertica for more than five years.
What do I think about the stability of the solution?
Vertica provides good stability.
I rate the solution a nine out of ten for stability.
What do I think about the scalability of the solution?
There are different options for scaling the solution through physical or virtual nodes or Kubernetes containers. Scaling is easy, but once we add more nodes, some actions have to be performed on the database. More than 200 users are using the solution in our organization.
How are customer service and support?
The solution's technical support is great.
Which solution did I use previously and why did I switch?
We usually work with other vendors like Netezza and Oracle, some open-source databases, big data systems, and cloud-native tools like Azure, GCP, or BigQuery. We decided to go with Vertica because we had everything on-premises, and we preferred to have a database on-premise.
What about the implementation team?
The solution's deployment takes a week or even more. We implemented the solution with the help of its support. The deployment can be done in-house, but expertise is needed.
What's my experience with pricing, setup cost, and licensing?
Vertica has a perpetual license, but they are currently trying to convert all those licenses to subscription-based licenses on a yearly basis.
What other advice do I have?
Vertica improved real-time data ingestion from sources and reporting to business users. The solution's native functions were usable for some simple use cases. However, developers prefer something else, like Python, for some complex projects. Vertica has features very similar to those of other databases like Netezza or Snowflake. The solution provides great value for its price.
Vertica's integration with third-party systems is very easy because it supports standard integrations like ODBC and JDBC. The solution's price-performance ratio is great, and it is used as a group data warehouse.
Overall, I rate the solution a seven out of ten.
Secured data shipping
What do you like best about the product?
Complete integration of data and cumulative services makes it one in all solution for data delivery and transfer on a big corporation level
What do you dislike about the product?
The affordability might not be the best feature as not small startups can afford it.
What problems is the product solving and how is that benefiting you?
Complete one in all integration makes it easy good to go solution for data management
Vertica: Powerful analytics tool
What do you like best about the product?
The vertica datawarehouse offers columnar store database structure capable of handling big data workloads
unlike other traditional databases.
This architecture coupled with other efficient parellel processing techniques
allows for exceptional performance when resolving complex OLAP problems
and rightly so that is their USP.
This comes in handy especially when you deal with near real-time stream workloads usecases.
Lastly, they have launched VerticaPylab which is a great addition for empowering ML based solutions
Also, integration to reporting services such as Tableau are easy to implement.
unlike other traditional databases.
This architecture coupled with other efficient parellel processing techniques
allows for exceptional performance when resolving complex OLAP problems
and rightly so that is their USP.
This comes in handy especially when you deal with near real-time stream workloads usecases.
Lastly, they have launched VerticaPylab which is a great addition for empowering ML based solutions
Also, integration to reporting services such as Tableau are easy to implement.
What do you dislike about the product?
In contrast to alternative tools in market, they have significantly
smaller userbase and hence getting help from online community for issues can be challenging.
After their aquisition from Micro focus to Opentext, there has been few changes in layout in documentation
as well as layout of UI , which creates additional learning curve.
After a certain threshold(of datasize), the operational costs drastically
increases which sometimes is not justifiable
smaller userbase and hence getting help from online community for issues can be challenging.
After their aquisition from Micro focus to Opentext, there has been few changes in layout in documentation
as well as layout of UI , which creates additional learning curve.
After a certain threshold(of datasize), the operational costs drastically
increases which sometimes is not justifiable
What problems is the product solving and how is that benefiting you?
The goal was to explore the capabilties of datawarehouse and finds its place
in the big list of other established datawarehouse solutions in the market
Specifically for catering the reporting dashboard department and its data requirements.
In contrast to other datawarehouses, we found that integration to reporting
services such as Tableau are highly reliable even for large datasets.
in the big list of other established datawarehouse solutions in the market
Specifically for catering the reporting dashboard department and its data requirements.
In contrast to other datawarehouses, we found that integration to reporting
services such as Tableau are highly reliable even for large datasets.
Vertica Big Data Analytics Platform
What do you like best about the product?
As a big data Engineer This Platofrm is more useful for analtics on huge data platform.
It provides the business insights more acuratively as compared to other data wareshouse.
easily to work on all the major clouds.
more advantages on machine learning analysis.
It provides the business insights more acuratively as compared to other data wareshouse.
easily to work on all the major clouds.
more advantages on machine learning analysis.
What do you dislike about the product?
its difficult to implement on legacy platform on map reduce and hadoop.
needs improvments on on premises clouds.
needs improvments on on premises clouds.
What problems is the product solving and how is that benefiting you?
More on the data warehouse it uses ..same thing and improves on the scaling on huge data analytics..
A user-friendly tool that needs to improve its documentation part
What is our primary use case?
In my company, we use Vertica as it's a tool meant to serve as database performance software and to make some selections, including some usual activities on a database revolving around options like select, insert, update, delete, and a few more.
What is most valuable?
The best thing about Vertica is that it is a supportive database performance software. Generally, the tool is used for performance and KPIs.
What needs improvement?
In my opinion, nothing needs improvement in the solution as it is a great product.
The documentation of Vertica is an area with shortcomings where improvements are required.
Vertica needs to increase its sustainability in the future.
For how long have I used the solution?
I have been using Vertica for two years. I am a user of the product.
What do I think about the stability of the solution?
The stability offered by the product depends on various factors. Honestly, in my company, we encounter some problems with Vertica, though it is something that depends on the applications for which one uses it. I consider the stability of Vertica to be okay.
What do I think about the scalability of the solution?
Around 100 people in my company use Vertica.
How was the initial setup?
The product's initial setup phase is extremely simple.
The solution is deployed on the cloud.
What's my experience with pricing, setup cost, and licensing?
Vertica is an expensive tool.
Which other solutions did I evaluate?
My company chose Vertica over other products since I think that all the other products we use are meant for the children in our college. I don't exactly know the reason why my company chose Vertica.
What other advice do I have?
I would describe Vertica as a user-friendly product. The documentation part of Vertica is almost the same as the one for MySQL, which we have in our company. The documentation part of Vertica is very friendly enough to use, but I can never say that the documentation area is better.
I don't use ChatGPT to help me with my queries since I try to deal with my issues and queries on my own. I don't want anything improved in the solution as it provides us with everything we require in our IT environment. If I know how to run a query, then the results generated by Vertica turn out to be okay.
The stability offered by Vertica is something that depends on the application and the memory of the product. If you work with Vertica in any of your projects, you will see that it works better for you with much more resources than others. You won't encounter problems with Vertica, especially if your company's architects are better at managing and creating interfaces.
I recommend Vertica to those who plan to use it since it is easy to configure and use. I don't think you would encounter any problems with Vertica. The syntax in Vertica is easy to use and user-friendly, which you can find on Google.
I rate the overall tool a seven out of ten.
Vertica is good tool if you are looking for managed analytical database with low Ops.
What do you like best about the product?
Easy to deploy both on-prem and on cloud.
What do you dislike about the product?
High concurrency could be managed better.
What problems is the product solving and how is that benefiting you?
We have a large amount of warehouse data using Vertica we can quickly convert massive amounts of data into insights.
Data Analytics with Vertica
What do you like best about the product?
The massive parallel processing power of vertica to handle big data is very amazing when compared to other database. It supports on premise Hadoop and other multi cloud.
What do you dislike about the product?
The integration of Vertica with industry leading BI platform is not straight forward. It will be good if there is a common standard connection component to achieve the same.
What problems is the product solving and how is that benefiting you?
Vertica Aim to become a leading Analytical platform is what aligns with our requirements for handling big data analytics. We have leveraged Vertica for building the data model for processing big data.
Software Engineer
What do you like best about the product?
Vertica is versatile since it supports both on-premises and cloud infrastructure. Besides, it allows engineers to see how query would be on executed and to optimize it both manually and automatically.
What do you dislike about the product?
There are standard SQL functions which Vertica has not supported yet. For instance, pivot, except, unnest, array_agg functions is not provided, causing various issues when migrating from another system like BigQuery.
What problems is the product solving and how is that benefiting you?
Vertica can run on-premises, which allows corporates control thier own infrastructure. As a result, the fees can be reduced by two-thirds of the payment for cloud infrastructure.
My Experience and review
What do you like best about the product?
The speed of the vertica system and it's capabilities
What do you dislike about the product?
No implementation languages supported in Vertica
What problems is the product solving and how is that benefiting you?
Document storage purpose we have leveraged
showing 1 - 10