Gamber-Johnson Universal Vertical Base mounting component - for notebook - black
$106.00
$59.84
Mfg # DS-138
CDW # 1020317
| UNSPSC 43212002
Know your gear
- Heavy gauge steel construction for long-term durability
- Black powdercoat finish for maximum corrosion resistance
- Ideal for mounting communication equipment to engine cover, consoles and dog houses
Add to Compare
Enhance your purchase
Gamber-Johnson Universal Vertical Base - mounting component is rated
4.50 out of
5 by
17.
Rated 5 out of
5 by
JelsonGhigonetto from
Enhanced capabilities, good customer service, large data scalability and stable
What is our primary use case?
The solution is a BI solution that includes machine learning. Our company is involved in the distribution of water and we use it to capturing data for several points and to discover where there might have been a loss of drinkable water.
There is a problem with the water distribution because the company that I'm working for has an index of 32% of water loss during the process of the distribution. These losses can be from a different source. It can be from leakage, it can be an error or on the meter read which can have many issues, sometimes the problem occurs in different hours depending on the pressure of the water network. We need to use artificial intelligence to collect millions of the data points to detect where the problem might be coming from.
What is most valuable?
The solution has great capabilities. The tool that instructs the internal database forward is easy to use and is very powerful.
What needs improvement?
The product could be less expensive and could benefit from a better marketing strategy.
In a future release, I would like to have one application to help create intelligent models.
For how long have I used the solution?
We have been testing and developing the solution for two years.
What do I think about the stability of the solution?
We did not have any technical problem with the solution.
What do I think about the scalability of the solution?
The solution has great scalability. We started with one terabyte of compressed data, this is a lot of data and we never had problems with the scalability. You can have hundreds of terabytes with the solution if you want, it all depends on your needs.
How are customer service and technical support?
The customer service is very good. They could improve on their expertise and knowledge of bigger projects and their support for them. Some of their information about collecting data I was not satisfied with their help. They could improve on customer service a bit.
I rate the technical support an eight out of ten.
Which solution did I use previously and why did I switch?
We currently use IDOL as well as Vertica.
How was the initial setup?
The product is not easy to set up because you need a lot of training. It has less to do about the product itself, but the knowledge on how to use it. For example, the spreadsheet product Excel, If you don't know mathematics, you will have difficulty to make big Excel model and that's the same with the Vertica. It's just only a tool and depending on your capabilities to design what you need.
What about the implementation team?
We are the developers of a solution and it is a very sophisticated project. It's something that we spent two years to develop. We already tested it and we are only waiting for the customer to try it and then purchase it. It has taken some time to implement the solution to the way we wanted for our company.
What's my experience with pricing, setup cost, and licensing?
It's difficult today to compete with open-source solutions. In these areas, there is a lot of competition and the price of this solution is a bit pricy.
Which other solutions did I evaluate?
We use another product called IDOL and use them both together as our solution. Sometimes you use both or sometimes you use each one separately. The two products are machine learning products but with different uses. IDOL has a more developed application and is much bigger than in Vertica.
What other advice do I have?
This solution is used by several big companies such as Bank of America, Uber, and Facebook. Where you need a BI with intelligence. We use the solution because it is very good, you can make interconnections with anything to collect the data, any type of data. I have tried other products and they did not fit as well as this one did, I recommend Vertica.
I rate Vertica a nine out of ten.
Which deployment model are you using for this solution?
On-premises
Disclaimer: My company has a business relationship with this vendor other than being a customer:Partner
Date published: 2020-12-31T00:00:00-05:00
Rated 5 out of
5 by
Teddy Elias from
Improved my organization's functionality and performance
How has it helped my organization?
It has improved my organization's functionality and performance.
What is most valuable?
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.
What needs improvement?
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.
For how long have I used the solution?
I have been using Vertica since 2009.
What do I think about the stability of the solution?
When you're on-prem, you're always worried about losing your nodes. It was hard to restore especially when you have big data.
What do I think about the scalability of the solution?
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.
How are customer service and technical support?
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.
Which solution did I use previously and why did I switch?
We previously used Oracle and we decided to go for big data.
How was the initial setup?
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.
What other advice do I have?
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.
Which deployment model are you using for this solution?
Public Cloud
Disclaimer: I am a real user, and this review is based on my own experience and opinions.
Date published: 2020-11-29T00:00:00-05:00
Rated 5 out of
5 by
MunkhsaikhanBayar from
Scalable big data analytics platform that is reasonably priced compared to other solutions
What is our primary use case?
Our primary use case for this solution is data analytics.
What is most valuable?
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.
What needs improvement?
The integration of this solution with ODI could be improved.
For how long have I used the solution?
I have used this solution for 1 year.
What do I think about the stability of the solution?
This is a stable solution with a fast compression system.
What do I think about the scalability of the solution?
This is a scalable solution.
How are customer service and support?
The technical support for this solution is really good. The support team are friendly and provide assistance quickly.
How would you rate customer service and support?
Positive
How was the initial setup?
The initial setup is straightforward.
What's my experience with pricing, setup cost, and licensing?
The pricing for this solution is very reasonable compared to other vendors.
What other advice do I have?
I would rate this solution a ten out of ten.
Which deployment model are you using for this solution?
On-premises
Disclaimer: My company has a business relationship with this vendor other than being a customer:partner
Date published: 2022-04-15T00:00:00-04:00
Rated 5 out of
5 by
Jelson-Ghigonetto from
Powerful tool, excellent revision options, with easy depolyment
What is our primary use case?
The primary use case is machine learning and currently, I am working on IOT projects.
How has it helped my organization?
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.
What is most valuable?
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.
What needs improvement?
The biggest problem is the cost of cloud deployment.
For how long have I used the solution?
I have worked with Vertica for the past five years.
How was the initial setup?
The initial setup is straightforward and easy deployment.
What other advice do I have?
I would rate Vertica an eight out of ten.
Which deployment model are you using for this solution?
Hybrid Cloud
If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?
Other
Disclaimer: My company has a business relationship with this vendor other than being a customer:Partner
Date published: 2022-11-20T00:00:00-05:00
Rated 5 out of
5 by
ERICK RAMIREZ from
Data analytics solution where data can be coded and compressed and does not require additional infrastructure
What is our primary use case?
This solution is used as part of our data warehouse solution. We have some customer indexing content in this Vertica product. Vertica is a relational database that is used as part of our data warehouse implementation.
What is most valuable?
Vertica is a great product because customers can compress and code data. The infrastructure that data warehouse solutions need is a commodity server so that customers don't have to invest in infrastructure. Vertica is a column oriented database so the response of queries is very fast.
What needs improvement?
In a future release, we would like to have artificial intelligence capabilities like neural networks. Customers are demanding this type of analytics.
For how long have I used the solution?
We have been using this solution for six years.
What do I think about the stability of the solution?
This is a stable solution.
What do I think about the scalability of the solution?
This is a scalable solution.
How are customer service and support?
The customer service for this solution is good.
How would you rate customer service and support?
Neutral
How was the initial setup?
The initial setup is straightforward.
What other advice do I have?
It is important for those considering this solution to have some experience in database management solutions because Vertica is a relational database. Knowledge regarding SQL and any other database related skills is very important in order to implement or use this product correctly.
I would rate this solution a nine out of ten.
Disclaimer: My company has a business relationship with this vendor other than being a customer:Partner
Date published: 2022-11-13T00:00:00-05:00
Rated 5 out of
5 by
reviewer1754802 from
Most important feature is the fast database, but also has a lot of machine learning functions and integrations
What is our primary use case?
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.
What is most valuable?
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.
What needs improvement?
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.
For how long have I used the solution?
I have been using this solution for four years.
How are customer service and support?
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.
What's my experience with pricing, setup cost, and licensing?
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.
What other advice do I have?
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.
Which deployment model are you using for this solution?
On-premises
Disclaimer: I am a real user, and this review is based on my own experience and opinions.
Date published: 2022-01-18T00:00:00-05:00
Rated 5 out of
5 by
Santosh Kurakula from
Extremely fast query performance, effective real-time API integrations, and highly qualified support
What is our primary use case?
We are using Vertica for our data warehouse. We run all the ETL and then store the information for the reports which are given to the business team for use for analytical purposes.
What is most valuable?
Vertica is a columnar database where the query performance is extremely fast and it can be used for real-time integrations for API and other applications. The solution requires zero maintenance which is helpful.
What needs improvement?
They could improve the integration and some of the features in the cloud version.
For how long have I used the solution?
I have been using Vertica for approximately six years.
What do I think about the stability of the solution?
The solution is highly stable.
We have approximately 15 users using this solution in my organization.
What do I think about the scalability of the solution?
Vertica is scalable.
How are customer service and technical support?
The support is extremely good, they respond immediately and are highly qualified. We interact with them once in a while to have new features explained, sessions understanding, and if we have an issue. We have a good relationship with them.
How was the initial setup?
The installation is not simple, if you go through the documents that are provided you should manage to do it. However, having some technical knowledge would be recommended.
The time it took to do the implementation was approximately 45 minutes. There is additional software or features that we needed to deploy as part of the migration.
What about the implementation team?
We did the implementation ourselves with a five-person technical team. However, the first time we did the implementation we had support from the Vertica team. They helped us by providing recommendations and best implementation practices.
What's my experience with pricing, setup cost, and licensing?
The pricing could improve, it is a little expensive.
Which other solutions did I evaluate?
I have evaluated Postgres.
What other advice do I have?
I would recommend this solution to others if it fits their use case. If someone is looking for a data warehouse solution with a fast query process Vertica is a good choice. However, it is different than a relational database. If the choice was between Postgres and Vertica, I would recommend Vertica.
I rate Vertica nine out of ten.
Which deployment model are you using for this solution?
Hybrid Cloud
Disclaimer: I am a real user, and this review is based on my own experience and opinions.
Date published: 2021-09-23T00:00:00-04:00
Rated 5 out of
5 by
Bijal Sanghavi from
Useful large aggregations, beneficial subclusters, but scalability could improve
What is our primary use case?
I am using Vertica for aggregations and dashboards.
What is most valuable?
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.
For how long have I used the solution?
I have been using Vertica for three and a half years.
What do I think about the stability of the solution?
Over the last few months with the new release of Vertica, there have been stability problems. The performance should improve.
What do I think about the scalability of the solution?
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.
How are customer service and support?
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.
Which solution did I use previously and why did I switch?
I have not used another similar solution to Vertica.
What about the implementation team?
We had assistance from Vertica with the implementation of the solution.
What other advice do I have?
I would advise others to try the solution out.
I rate Vertica a seven out of ten.
Which deployment model are you using for this solution?
Public Cloud
If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?
Amazon Web Services (AWS)
Disclaimer: I am a real user, and this review is based on my own experience and opinions.
Date published: 2022-06-29T00:00:00-04:00
Rated 5 out of
5 by
reviewer1547958 from
Great performance, stable and easy to use database
What is our primary use case?
We hold financed data on the Vertica database, and clients use the data for reporting and other purposes.
How has it helped my organization?
Vertica provides benefits to our customers and helps with their performance.
What is most valuable?
The most valuable feature is Vertica's performance and the ease of using the database. Also, it is great for partnering with data.
What needs improvement?
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.
For how long have I used the solution?
We have been using this solution for two years and are using the latest version.
What do I think about the stability of the solution?
It is a stable solution.
What do I think about the scalability of the 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.
What other advice do I have?
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.
Which deployment model are you using for this solution?
Public Cloud
If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?
Amazon Web Services (AWS)
Disclaimer: My company has a business relationship with this vendor other than being a customer:Partner
Date published: 2022-07-20T00:00:00-04:00
Rated 5 out of
5 by
reviewer1605324 from
A scalable unified analytics platform with good performance
What is our primary use case?
Our use case is a typical data warehouse. We just use the data warehouse for reporting and the storage of data. Our users are the staff team who do the reporting and data analysis.
What is most valuable?
The feature I like best is performance. We use Red Tool and Red Job for the data warehouse and reporting. It's perfect. Performance is good, and it can return ad hoc queries very quickly. Of course, it's a cluster, so it's easy to scale.
What needs improvement?
It's hard to make it slow for a small data volume. For large volumes, it's hard to make it work. It's also hard to make it faster, and to make it scale.
For how long have I used the solution?
I have been using Vertica for about five years.
What do I think about the stability of the solution?
It's a stable solution.
What do I think about the scalability of the solution?
Vertica is a scalable solution.
How are customer service and technical support?
Technical support is good, and they react quickly.
How was the initial setup?
The initial setup is okay. You will need some knowledge and some training. I'd say learning takes a couple of months. We use one person to maintain the database side. With the DevOps team, everyone has a different role. But for our database, it's just one person.
What's my experience with pricing, setup cost, and licensing?
The price is reasonable. We use a pay per license model. Firstly, you need to buy a license. After that, you mainly pay the annual support fee of around 20% or 25%. I think their prices are quite reasonable.
What other advice do I have?
We tried to use data lake kind of stuff for machine learning, but for the key functionality of the data warehouse, it's great. Personally, I feel they are over-marketing the machine learning feature and for something like the semi-structured data. But for the data warehouse, it's truly a good solution. I want to recommend it highly.
I would tell potential users that it's hard to make it slow for small data volumes. For large volumes, it's hard to make it work, make it faster, and make it scale. Depending on your workload and your use case, you need to first purchase the Red Tool. After that, you need to follow the best practices to have an efficient design.
On a scale from one to ten, I would give Vertica a nine.
Which deployment model are you using for this solution?
On-premises
Disclaimer: I am a real user, and this review is based on my own experience and opinions.
Date published: 2021-06-24T00:00:00-04:00
Rated 5 out of
5 by
Souhar El Mostafa from
User-friendly, stable, and scalable
What is our primary use case?
We use the solution in our data warehouse.
What is most valuable?
The solution is quick, has good compression data, and is not expensive.
Vertica is user-friendly.
What needs improvement?
The integration with AI has room for improvement. There is room for better machine learning.
For how long have I used the solution?
I have been using the solution for 16 years.
What do I think about the stability of the solution?
The solution is stable.
What do I think about the scalability of the solution?
The solution is easy to scale.
We have seven people using the solution.
How are customer service and support?
The technical support is good.
How was the initial setup?
The initial setup is straightforward. The deployment took four days.
What about the implementation team?
The implementation was completed by a vendor.
What's my experience with pricing, setup cost, and licensing?
The price is reasonable. The solution is free and we pay for the storage.
What other advice do I have?
I give the solution a nine out of ten.
Which deployment model are you using for this solution?
On-premises
Disclaimer: I am a real user, and this review is based on my own experience and opinions.
Date published: 2023-03-22T00:00:00-04:00
Rated 5 out of
5 by
Amol Adhav from
High performance database, low maintenance, and simple setup
What is our primary use case?
We are using Vertica for dashboards, storing, retrieving, and processing data.
What is most valuable?
The most valuable feature of Vertica is the unmatchable database performance at a fraction of cost compared to other similar databases.
What needs improvement?
Vertica can improve automation and documentation.
For how long have I used the solution?
I have been using Vertica for approximately seven years.
What do I think about the stability of the solution?
Vertica is stable. They have made improvements in this area but can still improve.
What do I think about the scalability of the solution?
The scalability of Vertica is good.
We have approximately 100 users using this solution.
How are customer service and support?
The support from Vertica is good, they are knowledgeable. However, sometimes there are some challenges when escalating our issue.
Which solution did I use previously and why did I switch?
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.
How was the initial setup?
The initial setup of Vertica is straightforward.
What's my experience with pricing, setup cost, and licensing?
The price of Vertica is less expensive than some competitors, such as Teradata.
What other advice do I have?
We require one person for maintenance for the 100 users we have.
I rate Vertica an eight out of ten.
Disclaimer: I am a real user, and this review is based on my own experience and opinions.
Date published: 2022-11-01T00:00:00-04:00
Rated 5 out of
5 by
Sima Alexandru from
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.
Disclaimer: I am a real user, and this review is based on my own experience and opinions.
Date published: 2023-11-16T00:00:00-05:00
Rated 5 out of
5 by
Marko Stajcer from
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.
Disclaimer: I am a real user, and this review is based on my own experience and opinions.
Date published: 2024-04-25T00:00:00-04:00
Rated 5 out of
5 by
reviewer2323428 from
Offers columnar storage and swapped partition features with impressive stability
What is our primary use case?
Our company uses one of the latest containerized versions of Vertica. When the curated processes are completed, our company uses Vertica at the end of all pipelines. In our organization, we usually store the curated datasets in parquet files, but we offer Vertica storage access for data consumers to manipulate and query the data easily. Our company also stores data in the Vertica database for analytics.
What is most valuable?
In one of our organization's prior investigation reports on Vertica, it was highlighted that the solution was executed quite quickly due to its columnar storage underground, which is the most valuable feature for our company.
What needs improvement?
Vertica is fast enough in data copying processes. The data digestion process is quickly completed using a certain copy command. The solution gets accelerated in processes if the queries are properly designed.
I have previously worked with Microsoft Secret Server and Deep Secure. I was familiar with the system's assets and transaction habits, so when I switched to Vertica, I had some expectations in terms of features from the other systems, which didn't quite match. The transactional operations and rollback were missing in Vertica, which I am trying to implement using the AUTOCOMMIT setting, but I am unsure whether the features will work according to my expectations.
For how long have I used the solution?
I have been using Vertica for three months.
What do I think about the stability of the solution?
I would rate the stability a nine out of ten.
What do I think about the scalability of the solution?
In our company, we have faced difficulties in scaling the solution for certain use cases. The solution didn't scale as expected in some cases, for which our company team witnessed performance issues. But in our company, we had doubts in the aforementioned cases if it was a query optimization or scaling problem. There are around 100 Vertica users in our organization. I would rate the scalability a seven out of ten.
How are customer service and support?
I would rate the technical support an eight out of ten.
How would you rate customer service and support?
Positive
Which solution did I use previously and why did I switch?
I have previously used Redshift, MySQL, PostgreSQL and Microsoft Secret Server.
How was the initial setup?
When I was dealing with an onboarding task for the solution to implement a specific data pipeline with Vertica, I had to ideally and precisely configure the infrastructure and data architecture so that Vertica worked well enough in integration with Spark. If you have multiple systems and you want to establish communication between them, some drivers need to be provided, and some installations need to be made using JAR files.
For the deployment of Vertica, no client agents are required because it only involves passing the secret code to Vertica and executing the solution using Airflow DAGs, Vertica operators, Vertica hook and Spark solution, which work satisfyingly together. After processing datasets in our company, we store them in Vertica directly using Spark and Spark connector for Vertica. Our company uses Spark as a computational engine. Our company's operational team mainly takes care of Vertica's maintenance.
What's my experience with pricing, setup cost, and licensing?
It's an expensive product. I would rate the pricing a five out of ten.
What other advice do I have?
In one of the projects in our company, we dealt with a huge amount of customer data, and the configuration of this data was quite specific as it arrived from multiple business units. Our customers can have contact with different business units, and each unit is a company in itself. The same customer might pass, for example, one shopping mall of a business unit and might shift to another unit and identify themselves in both business units depending upon the identification process of how the data is collected.
The aforementioned project required identifying a unique user or customer with contacts with multiple business units and commercial centers. Our company processed a huge amount of the mentioned data type with the help of data science and machine learning models. Using the clustering process and leveraging the identified cluster users stored in the Vertica database, we executed some basic analytics on transactions involving customer spend, frequency of visits to a commercial center, and types of product selection.
I found the swapped partition of tables option to be extremely useful for our company which allowed me to perform some quick operations that would be otherwise impossible to guarantee the rollback in operations involving all assets. I would overall rate the solution an eight out of ten. I am unsure if my company would stick with Vertica in the future and it also depends on the vendor's promises on Vertica's scaling capacity.
If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?
Amazon Web Services (AWS)
Disclaimer: I am a real user, and this review is based on my own experience and opinions.
Date published: 2024-06-30T00:00:00-04:00
Rated 5 out of
5 by
T Venkatesh from
Processes query faster through multiple systems simultaneously, but it could support different data types
What is our primary use case?
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.
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.
Disclaimer: I am a real user, and this review is based on my own experience and opinions.customer
Date published: 2024-08-18T00:00:00-04:00
Rated 5 out of
5 by
ERICK RAMIREZ from
Allows for a large amount of data to be stored with minimal physical space
What is our primary use case?
We use the solution for the warehouse. We implement machine-learning solutions such as clustering or classification models.
How has it helped my organization?
We can implement advanced solutions with very interesting capabilities to review whether the customer returns the tool and the licensing cost.
What is most valuable?
Vertica uses advanced Azure technologies to compress raw data using indexing, allowing a large amount of data to be stored with minimal physical space. Advanced algorithms are employed in data compression.
What needs improvement?
Pricing could be more competitive.
For how long have I used the solution?
I have been using Vertica for three years. We are using the V23 of the solution.
What do I think about the stability of the solution?
I rate the solution’s stability an eight out of ten.
What do I think about the scalability of the solution?
100-200 users are using this solution.
I rate the solution’s scalability a nine out of ten.
How are customer service and support?
Support is good.
How would you rate customer service and support?
Positive
How was the initial setup?
The initial setup is straightforward. The deployment process includes creating a solar package to deploy this package on-premise or in a cloud environment. The solar package has all the configurations and components we need to implement as part of customer solutions. There are various software components requiring a specific configuration. So, we package this solar component and deploy it in the customer environment.
I rate the initial setup an eight out of ten, where one is difficult and ten is easy.
What's my experience with pricing, setup cost, and licensing?
I rate the product’s pricing a seven out of ten, where one is cheap and ten is expensive.
What other advice do I have?
You can implement a cluster of servers, and we should guarantee high availability in a disaster recovery scenario. You can use Vertica in a production environment with distributed workflows and workloads. Vertica is available and has parallel processing and other capabilities.
You can implement a cluster of servers to guarantee high availability and massive parallel processing. It's a very sophisticated solution.
Vertica can be used to implement machine learning models such as classification, clustering, and aggregation models to support various use cases depending on customer needs. We have already implemented some machine learning models to detect anomalies. Some employees have distinct patterns in their working behaviors.
It is another feature-intelligent solution from OpenTex. It can implement or process structural data such as images, videos, text documents, and semi-structured data.
I recommend using this kind of solution because you can index your data and use a balancing algorithm to manage and retrieve data efficiently. Customers don't need a very large infrastructure to implement this type of solution. You can use it to implement advanced machine learning models, classification, and clustering. It also supports advanced artificial intelligence solutions.
Overall, I rate the solution a nine out of ten.
Which deployment model are you using for this solution?
Hybrid Cloud
Disclaimer: My company has a business relationship with this vendor other than being a customer:reseller
Date published: 2024-06-28T00:00:00-04:00