OpenText Analytics Database (Vertica) Reviews

We use the solution in our data warehouse.

The solution is quick, has good compression data, and is not expensive.

Vertica is user-friendly.

The integration with AI has room for improvement. There is room for better machine learning.

I have been using the solution for 16 years.

The solution is stable.

The solution is easy to scale.

We have seven people using the solution.

The technical support is good.

The initial setup is straightforward. The deployment took four days.

The implementation was completed by a vendor.

The price is reasonable. The solution is free and we pay for the storage.

I give the solution a nine out of ten.

We are using Vertica for dashboards, storing, retrieving, and processing data.

The most valuable feature of Vertica is the unmatchable database performance at a fraction of cost compared to other similar databases.

Vertica can improve automation and documentation.

I have been using Vertica for approximately seven years.

Vertica is stable. They have made improvements in this area but can still improve.

The scalability of Vertica is good.

We have approximately 100 users using this solution.

The support from Vertica is good, they are knowledgeable. However, sometimes there are some challenges when escalating our issue.

I have previously used Teradata long time ago. The price of Teradata was very high and hardware is vendor specific. Vertica can operate on comodity hardware and therefore easily scalable.

The initial setup of Vertica is straightforward.

The price of Vertica is less expensive than some competitors, such as Teradata.

We require one person for maintenance for the 100 users we have.

I rate Vertica an eight out of ten.

It has improved my organization's functionality and performance. 

You don't have any more dependency on the local store. In order to build the on-prem process for Vertica, you need to make a lot of changes and be picky about choosing your hardware for it. On Eon, you just put it on S3, so you're not paying a penny for the stores anymore. That's the good thing about Eon. 

We are looking for a cheaper deployment for the solution. Although we did a lot of benchmarks, like Redshift. We tried Redshift, it didn't work. It didn't work out for us as well.

I have been using Vertica since 2009.

When you're on-prem, you're always worried about losing your nodes. It was hard to restore especially when you have big data.

Scalability has been amazing. We have seen a lot of improvement. We have developers and we have a production demo. We have hosted clusters for customers, we have deployed customer scope. I can scribe them by petabytes. I can scale them by the number of users. It depends on the customers. For one project we can have 15 to 20 consecutive users, but they deal with petabytes of storage.

Their support is really bad. Maybe Micro Focus has changed but they were not good before. They weren't really responsive. We've never had good support.

I would rate it a three out of ten. I met with them two months ago. They asked why we didn't renew our support. They wasted a lot of our money. We've had really bad experiences with Vertica.

We previously used Oracle and we decided to go for big data. 

The initial setup was straightforward for me, it's not complex at all. You need to be at least a bit of a database administrator and really get certified on Vertica in order to use it. 

My advice to someone considering Vertica is to go for it. 

Nothing is missing. I would rate it a ten out of ten.

The only issues are support and the price. 

Primary use case is advanced analytics over huge amounts of data. Vertica provides high speed access to high volumes.

Previous to Vertica, some analysis could not be made because of the amount of data needed. Vertica allowed us to take those volumes and process them at a very high speed.

Vertica's most outstanding features are the compression rates achieved and the speed of access of high volume data.

• Support is an area where it could get better. 
• Promotion/marketing must be improved, even though it is a very useful product at very good price, it is not as "popular" as it should be.

One to three years.

Just some issues with clustering, but they were not Vertica's issues.

None.

It could be improved.

Positive

I used Hadoop as the first approach. However, Vertica provided the best of both worlds (huge amounts of data and speed of access for analytics).

Once you got your cluster setup and nodes properly working, it is very simple to set up Vertica.

We did the implementation ourselves.

Huge. We are doing analytics that previously we could not.

We evaluated Exasol, but it came out to be too expensive for the use case.

Do a good volumetric analysis to manage the storage needed.

The primary use case is machine learning and currently, I am working on IOT projects.

With Vertica, I am able to make changes using other Vertica features and I do not have to start the project over. The Vertica tool is very powerful but you cannot purchase the product based on individual features. 

I am highly trained on Vertica and I am resistant to using other products because I do not have experience with those products. Some of the most valuable features are cybersecurity and backup.

The biggest problem is the cost of cloud deployment.

I have worked with Vertica for the past five years.

The initial setup is straightforward and easy deployment.

I would rate Vertica an eight out of ten.

We hold financed data on the Vertica database, and clients use the data for reporting and other purposes.

Vertica provides benefits to our customers and helps with their performance.

The most valuable feature is Vertica's performance and the ease of using the database. Also, it is great for partnering with data.

We faced some challenges when trying to use the temporary tables feature. First, we installed Vertica on the AWS cloud and tried to read the data from Bitbucket to Vertica. We were able to read the data, but when we were trying to transform the data and load it into Vertica physical tables, we experienced performance issues.

Regarding additional features, we are unsure if Vertica has updated its features, but we've experienced difficulty in integrating with third-party tools. Clients use multiple technologies and value that integration. Sharing data with third parties should also be improved.

We have been using this solution for two years and are using the latest version.

It is a stable solution.

It is a scalable solution. Initially, we had issues with the scalability, but with the new version, Vertica resolved the issues.

Regarding how many users are using this solution, I do not have a specific number, but our organization is large. So, for example, in a unit with about fifteen clients, two to three clients use Vertica.

I rate this solution a seven out of ten.

Snowflake claims to have many more features than Vertica, but we cannot compare both solutions as we have not used Snowflake. However, if Vertica integrates the use of third-party tools, it would be great and more competitive.

I am using Vertica for aggregations and dashboards.

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 have been using Vertica for three and a half years.

Over the last few months with the new release of Vertica, there have been stability problems. The performance should improve.

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.

We have approximately 25 people using this solution in my company. Most of the users are developers. We have been increasing usage of the solution.

The technical support from Vertica is good, but the fixes take a long time if there is a problem.

I rate the support of Vertica a three out of five.

I have not used another similar solution to Vertica.

We had assistance from Vertica with the implementation of the solution.

I would advise others to try the solution out.

I rate Vertica a seven out of ten.

Our primary use case for this solution is data analytics.

The hardware usage and speed has been the most valuable feature of this solution. It is very fast and has saved us a lot of money.

The integration of this solution with ODI could be improved. 

I have used this solution for 1 year.

This is a stable solution with a fast compression system.

This is a scalable solution. 

The technical support for this solution is really good. The support team are friendly and provide assistance quickly. 

Positive

The initial setup is straightforward. 

The pricing for this solution is very reasonable compared to other vendors.

I would rate this solution a ten out of ten. 

I'm a Vertica specialist, and I'm certified by Micro Focus. The solution is deployed on-premise, but we have another installation on the cloud for another client.

It's the fastest database I have ever tested. That's the most important feature of Vertica. It has a lot of contents and machine learning functions. Today we have a lot of options for deploying. It has a lot of integrations.

I think they need an easy client so that you can write queries easily, but it's not necessarily a weak point. I think some users would need them.

In other versions of Vertica, there is a lack of integrations in some machine learning models. But today, the latest version has it all. I don't think they need too much improvement in that area. For me, it's great considering the use case I work with.

I have been using this solution for four years.

I haven't really had the opportunity to talk with them, but that's because the database just works. I don't really need technical support for maintaining and running the database. The documentation is very clear too.

The pricing depends on the license model because there are several. It depends on the client, but it's cheaper than other solutions. I think it's cheap for all the functionality and robustness. It's not very expensive to deploy.

I would rate this solution 8 out of 10. 

People should be careful with the way they are loading their data because Vertica is very fast at copying data. There are some operations that are slower than Oracle or SQL Server, but normally you wouldn't use that.

I use Vertica for traditional data warehouse reporting and some advanced analytics as well as real-time data processing or real-time analytics. I sell Vertica, so my clients' use cases vary. There are several types of users, and each company is going to have different requirements. And the number of users is not necessarily a great measure of usage if you're doing clickstream-type data on a website with massive numbers of queries coming in very quickly. But in other cases, you have people hammering it for reporting and various kinds of business use cases.

Vertica has a few features that I like. From an architecture standpoint, they have separated compute and storage. So you have low-cost object storage for primary storage and the ability to have several sub-clusters working off the same ObjectStore. So it provides workload isolation. Vertica handles analytics and large queries extremely well — very high performance —and on top of all of these features, Vertica has a very low total cost ownership.

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. I know that's in their roadmap, but I can't wait.

I've been using Vertica for almost three years.

Vertica is rock-solid.

Vertica is massively scalable. My customers' workloads vary. While the number of users is not necessarily the ideal performance measure, the user bases range from a few dozen in smaller setups to thousands in the largest setups. And some of my customers have several hundred users on the platform concurrently.

I deal directly with Vertica's engineers, so I don't have much experience with their frontline tech support. However, the more senior tech support on the backline is just world-class. These guys are amazing. And they are exceedingly committed to their customers. I've seen them do crazy stuff to support a customer.

Setting up Vertica is pretty straightforward. There's nothing super fancy about deploying Vertica. Depending on what you're doing, deployment can take anywhere from 10 to 15 minutes to several hours. It's quick if you want to use the automatic tools, which work very well. And if you want to do your own thing or do it on-prem, then it's going to take you a little bit longer. And you don't need large teams to administer it afterward.

I rate Vertica 10 out of 10. Anyone thinking about using Vertica should try to understand more than its basic functionality. They should look at its more powerful features like advanced, predictive, and real-time analytics. And just to add, that in the world of data warehousing, it's more accurate to say "near real-time" rather than "real-time" analytics.