# OpenText Vertica Reviews **Vendor:** OpenText **Category:** [Data Warehouse Solutions](https://www.g2.com/categories/data-warehouse) **Average Rating:** 4.3/5.0 **Total Reviews:** 216 ## About OpenText Vertica Vertica is the unified analytics platform, based on a massively scalable architecture with a broad set of analytical functions spanning event and time series, pattern matching, geospatial, and built-in machine learning capability. Vertica enables data analytics teams to easily apply these powerful functions to large and demanding analytical workloads, arming them and their customers with predictive business insights. Vertica provides a unified analytics platform across major public clouds and on-premises data centers, and integrates data in cloud object storage and HDFS without forcing any data movement. Available as a SaaS option, or as a customer-managed platform, Vertica helps teams combine growing data siloes for a more complete view of available data. Vertica features separation of compute and storage, so teams can spin up storage and compute resources as needed, then spin down afterwards to reduce costs. ## OpenText Vertica Reviews ### 1. I have almost 2 years of experience in data warehousing and ETL. **Rating:** 4.0/5.0 stars **Reviewed by:** Abhishek K. | Software Engineer, Information Technology and Services, Enterprise (> 1000 emp.) **Reviewed Date:** July 14, 2022 **What do you like best about OpenText Vertica?** It is best suitable for analytics and Big Data. I could process million of rows on real time basis. **What do you dislike about OpenText Vertica?** It is not flexible with Cloud-native platforms. It doesn't provide scalability to greater extent. **Recommendations to others considering OpenText Vertica:** It is best tool for data warehousing and solving Big Data solutions. Also, It provides fastest ETL transactions and on-time data delivery. **What problems is OpenText Vertica solving and how is that benefiting you?** Vertica is solving all my ETL problems and providing better Data warehousing solutions. Also, It is helping my organisation to store larger amount of data. **Official Response from Paige Roberts:** > Thanks for taking the time to write a review! Much appreciated, Paige ### 2. Streamlining work flow with OpenText Vertica **Rating:** 4.0/5.0 stars **Reviewed by:** mandi N. | Senior Java Developer, Enterprise (> 1000 emp.) **Reviewed Date:** February 17, 2024 **What do you like best about OpenText Vertica?** OpenText Vertica is flexible to do multiple tasks at a time and handles heavy loads of data processing with complex queries. The data lakes integrates multiple data sources enhancing the data analytics. The facility to add more clusters helps in handling huge tasks, better suits for large organizations. **What do you dislike about OpenText Vertica?** Implementing and integrating OpenText Vertica is quite complex. It requires good level of knowledge to work on tasks. Expensive in maintaining the system infrastructure hence doesn't fit for small businesses. The training documents and customer support could have been better. **What problems is OpenText Vertica solving and how is that benefiting you?** OpenText Vertica is very much helpful in building OLAP systems and data warehousing.Works efficiently in processing complex data with better data analytics. Improving the analytical capabilities and machine learning can extract valuable insights from large datasets. Brininging in more subscription plans with useful features covered in basic plans can benefit the users. **Official Response from Trish Schnupp:** > Thanks so much for the review, Mandi! We appreciate your feedback! ### 3. Vertica: Powerful analytics tool **Rating:** 3.5/5.0 stars **Reviewed by:** Pranshu G. | Software Developer, Information Technology and Services, Enterprise (> 1000 emp.) **Reviewed Date:** January 26, 2024 **What do you like best about OpenText Vertica?** 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. **What do you dislike about OpenText Vertica?** 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 **What problems is OpenText Vertica 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. **Official Response from Paige Roberts:** > Thank you for the review! We really appreciate you taking the time. Cheers, Paige ### 4. Smart Data Lakehouse for a traditional DBA to learn **Rating:** 4.5/5.0 stars **Reviewed by:** Gerry X. | Sr. Database Engineer (DBA), Mid-Market (51-1000 emp.) **Reviewed Date:** January 23, 2024 **What do you like best about OpenText Vertica?** The flexibility and cost-efficiency of a data lake with the contextual and high-speed querying capabilities of a data warehouse. Resharding the database as needed Rollback snapshots. **What do you dislike about OpenText Vertica?** No dislike. But to learn this new kind "Lakehouse" takes a little more time for a "traditional" DBA **What problems is OpenText Vertica solving and how is that benefiting you?** Our traditional Data Warehouse always have had performance issue due to the over large size. Plus, the new un-structured feature added in, making it very difficult to processing on a lot of things (including daily ETL). We are trying to engage a lot of new tools on the market, OpenText Vertica, the Datalake seems like resolves some of our problems. We are still on exploring new features... ### 5. A powerful Analytics Solution **Rating:** 5.0/5.0 stars **Reviewed by:** Tripti S. | System Engineer, Small-Business (50 or fewer emp.) **Reviewed Date:** February 12, 2024 **What do you like best about OpenText Vertica?** What I like best about it is that this platform offers wide range of bulit -in- analytical functions. It provides comprehensive security features. It is very easy to use and highly scalable. It is also known for its exceptional performance. It handle complex analytical quries on large datasets. **What do you dislike about OpenText Vertica?** What I dislike about OpenText Vertica is that it is it can be high cost for large-scale deployments or organizations with extensive data needs. It is complex to setup and configure for especially those users who are not familer with columnar databades. **What problems is OpenText Vertica solving and how is that benefiting you?** OpenText Vertica solves several critical problems related to data analytics and management and it benefiting organizations in several ways. It handle large volumes of data efficiently which makes it an ideal solution for organizations who are dealing with high datasets. **Official Response from Trish Schnupp:** > Thanks so much for the review, Tripti! We greatly appreciate your feedback! ### 6. OpenText Vertica review **Rating:** 4.0/5.0 stars **Reviewed by:** Saurabh K. | Analyst - Data Scientist, Small-Business (50 or fewer emp.) **Reviewed Date:** February 10, 2024 **What do you like best about OpenText Vertica?** * Vertica is very fast. It works seemlessly with very large amount of data, it compresses the data very well. * Vertica offers powerful built-in analytical tools for complexdata analysis. I have used this tool for marketing analysis. * It is very easy to scale, we needed to scale up the nodes and it was done easily. **What do you dislike about OpenText Vertica?** * For those who are not familiar with terminal usage, for them it's GUI feels outdated. * Vertica struggles with petabyte-scale data, facing scalability challenges. * It is a bit expensive for large data. **What problems is OpenText Vertica solving and how is that benefiting you?** Vertica is crucial for analyzing vast data volumes across business contexts. I have used it for internal data analysis, marketing outcomes and creating data marts for organisational insights. It efficiently handles large data ingestion, enhancing productivity. **Official Response from Trish Schnupp:** > Your feedback is greatly appreciated, Saurabh! Thank you so much for taking the time to leave us a review! ### 7. A good analytical tool fir big data analysis **Rating:** 4.0/5.0 stars **Reviewed by:** Ulka K. | Data Engineering Anayst, Small-Business (50 or fewer emp.) **Reviewed Date:** January 26, 2024 **What do you like best about OpenText Vertica?** It is extremely fast than other databases perhaps due to the columnar databse struture. It can be deployed on almost all cloud platform as well along with mainframe. Multiple node failure is very low. **What do you dislike about OpenText Vertica?** The documentation is not comprehensive and it could be imporved upon. the SaaS solution is only available in AWS and not fro Azure and GCP. **What problems is OpenText Vertica solving and how is that benefiting you?** The most important issue these days is the hosting and analyzing trillion of data especially in analytical companies. Vertica is an extremey useful and affordable database making query processing a lot faster than most other databases. **Official Response from Paige Roberts:** > Thank you for the review! Appreciate you taking the time. Cheers, Paige ### 8. Analytics tool for Datalake **Rating:** 4.5/5.0 stars **Reviewed by:** Hitanshu G. | Senior Analyst - Contracts and Sales Operations, Mid-Market (51-1000 emp.) **Reviewed Date:** January 27, 2024 **What do you like best about OpenText Vertica?** On behalf of various data engineers I can say that opentext vertics is a solution for datawarehousing and running alaysis on huge datasets with productivity and speed. All and all this comes up as a effective solution to quickly get results with respect to thousands of rows of data. **What do you dislike about OpenText Vertica?** While it is suitable for your entire data (lake) this is a complex solution to analyze small data sets and the results might not be satisfactory. **What problems is OpenText Vertica solving and how is that benefiting you?** Running analysis, predictive, and other modelling using huge or in casis entire data sets. ### 9. Review for OpenText Vertica **Rating:** 4.0/5.0 stars **Reviewed by:** Kaishmeen S. | Business Development Research Associate , Mid-Market (51-1000 emp.) **Reviewed Date:** February 26, 2024 **What do you like best about OpenText Vertica?** Opentext Vertica is a great platform to use for large data sets for data analysis and garher business insights **What do you dislike about OpenText Vertica?** OpenText has a lot of features to explore and it sometime lags while importing huge data set. Also, the pricepoint is a but on a higher side **What problems is OpenText Vertica solving and how is that benefiting you?** Processing data for me has become smooth and made the work on the job lot easier. With the useful insights I was able to present the data impactfully. **Official Response from Trish Schnupp:** > Thank you for the review, we appreciate your feedback! ### 10. I would like to elaborate more about this product and it's technical overview **Rating:** 4.5/5.0 stars **Reviewed by:** Surendar P. | Senior Software Engineer, Information Technology and Services, Mid-Market (51-1000 emp.) **Reviewed Date:** January 25, 2024 **What do you like best about OpenText Vertica?** I love mostly about its scaling part and peak performance. This product provides both multi cloud and hybrid cloud as well. And it's unified interface and easiness to use. **What do you dislike about OpenText Vertica?** Nothing much as of now I am loving this product **What problems is OpenText Vertica solving and how is that benefiting you?** Helping to store different format of data into this data Lake House. **Official Response from Paige Roberts:** > Really appreciate you taking the time to write a review. Thank you! Cheers, Paige ### 11. Innovation at its best **Rating:** 4.0/5.0 stars **Reviewed by:** Akash K. | QA Engineer 3, Hospitality, Enterprise (> 1000 emp.) **Reviewed Date:** July 13, 2022 **What do you like best about OpenText Vertica?** Using open text vertica is amazing only for its one unique feature called Workload routing. **What do you dislike about OpenText Vertica?** Restore points is a very good feature but a little complex to use. **What problems is OpenText Vertica solving and how is that benefiting you?** Currently open text vertica is helping us transform huge amounts of data in environments to generate analytics for the business on the fly. **Official Response from Paige Roberts:** > Thank you for taking the time to right a review! Cheers, Paige ### 12. Super Powerful Real-Time Data Analytics Creation Solution. **Rating:** 5.0/5.0 stars **Reviewed by:** Juddy K. | Data Scientist, Small-Business (50 or fewer emp.) **Reviewed Date:** February 01, 2024 **What do you like best about OpenText Vertica?** -Implementing the software was super easy process. -Data connectivity is effective. -Multiple development operations data management is amazing. -Quick on clean and real time data analysis ceation with the software. -Data protection and services Automation is excellent. **What do you dislike about OpenText Vertica?** -None at all since the learning is easy through their training guidance and helpful technical support. **What problems is OpenText Vertica solving and how is that benefiting you?** -Master on complex development projects data modeling and data management. -The analytics are easy to provide. -Big data transfer across third party tools. -Service Automation. -Data weahousing. ### 13. Productive on Complex Marketing Data Management. **Rating:** 4.5/5.0 stars **Reviewed by:** Gianna M. | Project Coordinator, Small-Business (50 or fewer emp.) **Reviewed Date:** January 24, 2024 **What do you like best about OpenText Vertica?** -The configuration on first implementation is easy and through the data analysis features, creating real time data analytics and migration of various data securely with the solution is more reliable and i love the Automation ability on this tool. **What do you dislike about OpenText Vertica?** I absolutely have no issues with the product and the initial learning curve is short and easy to understand. **What problems is OpenText Vertica solving and how is that benefiting you?** -Helpful on business data management and also reports distribution through various departments and the data analysis via the platform is productive. **Official Response from Paige Roberts:** > Thank you for the review! Appreciate you taking the time. Cheers, Paige ### 14. Review for Open Text Vertica **Rating:** 4.0/5.0 stars **Reviewed by:** Anish B. | Financial Analyst, Enterprise (> 1000 emp.) **Reviewed Date:** January 27, 2024 **What do you like best about OpenText Vertica?** 1) Its high performance in handling large scale data differentiate it from competitors. 2) The columnar storage and parallel processing architecture help the enterprise to grow **What do you dislike about OpenText Vertica?** Its learnning curve for new user makes it difiicult to understand and it involves high costs in in lisencing and hardware requirements **What problems is OpenText Vertica solving and how is that benefiting you?** It helps in handling and anayzing the large volume of data in real time . It helps in efficiently looking into large scale of data **Official Response from Paige Roberts:** > Thank you so much for taking the time to review! Appreciate the feedback. Cheers, Paige ### 15. Great tool for Ananlytics and Management **Rating:** 4.5/5.0 stars **Reviewed by:** Samridhi G. | Senior Account Manager, Small-Business (50 or fewer emp.) **Reviewed Date:** February 19, 2024 **What do you like best about OpenText Vertica?** That it has broad set of analytical functions which reduces the operations part. Also , due to those features , it is very easy to implement and integrate in the business. **What do you dislike about OpenText Vertica?** That it is still limited to few features that other tools have. **What problems is OpenText Vertica solving and how is that benefiting you?** It is solving to deploy the lesser number of people in operations and data analytics part. ### 16. Great tool for business **Rating:** 4.5/5.0 stars **Reviewed by:** Keshav Saraogi b. | Member, Small-Business (50 or fewer emp.) **Reviewed Date:** February 25, 2024 **What do you like best about OpenText Vertica?** The best thing about opentect vertica is that it provides great insight towards technology and solutions. **What do you dislike about OpenText Vertica?** Being a new user, a lot of these features confused me a little bit to choose one. **What problems is OpenText Vertica solving and how is that benefiting you?** Having huge data piling up opentext vertica helped me radicate that problem and helped me to process that data with ease. **Official Response from Trish Schnupp:** > Thank you for the review! We appreciate your feedback! ### 17. Review for OpenText Vertica **Rating:** 4.0/5.0 stars **Reviewed by:** Ankit S. | Bank Teller, Mid-Market (51-1000 emp.) **Reviewed Date:** February 24, 2024 **What do you like best about OpenText Vertica?** OpenText helps in analyzing big data set easily and with high accuracy and gives valuable insights **What do you dislike about OpenText Vertica?** The pricing is on a higher side and has too many features that might get overwhelming. **What problems is OpenText Vertica solving and how is that benefiting you?** It is helpful in providing insights quickly which helped in presenting then to clients and coversion rate has substantially increased **Official Response from Trish Schnupp:** > Thank you for your feedback, we appreciate your review! ### 18. Good tool for BDA **Rating:** 4.5/5.0 stars **Reviewed by:** Vanshika G. | Associate Account manager- Brand Solutions, Mid-Market (51-1000 emp.) **Reviewed Date:** February 05, 2024 **What do you like best about OpenText Vertica?** It is fast and a better platform for data engineers. This has multi cloud as well as hybrid cloud. It is flexible and a cost efficient tool. **What do you dislike about OpenText Vertica?** It is not useful to process small scale data and the results with small data would not be accurate/correct. **What problems is OpenText Vertica solving and how is that benefiting you?** It is helping me manage my large scale data. And helps with proper analytical report. **Official Response from Trish Schnupp:** > Thank you for the feedback! We appreciate your review! ### 19. Improved efficiency 2x times **Rating:** 4.5/5.0 stars **Reviewed by:** Vanshika T. | Mid-Market (51-1000 emp.) **Reviewed Date:** February 01, 2024 **What do you like best about OpenText Vertica?** The best thing about OpenText Vertica is its ability to update its database in real time. The speed and accuracy of the software is just exceptional. **What do you dislike about OpenText Vertica?** Sometimes, it is difficult to delete/remove entries from the database. **What problems is OpenText Vertica solving and how is that benefiting you?** We use OpenText Vertica to leverage and maintain our tremendous database, and using ML techniques to make forecasts on future policy changes, product launches etc. ### 20. Great but complex **Rating:** 4.0/5.0 stars **Reviewed by:** Musadiq P. | Software Design Engineer - I, Mid-Market (51-1000 emp.) **Reviewed Date:** January 24, 2024 **What do you like best about OpenText Vertica?** It's great performance in large data analytics, quick query processing, scalability, and advanced analytics capabilities. **What do you dislike about OpenText Vertica?** Could not find downloads for mac m1. Also It is a bit complex to setup and manage, and the costs are a bit high. **What problems is OpenText Vertica solving and how is that benefiting you?** It enhances the efficiency of large-scale data analytics and warehousing and hence provides faster query performance, handles massive data volumes, and supports advanced analytics. **Official Response from Paige Roberts:** > Thank you for taking the time to write a review! Cheers, Paige ### 21. Review for OpenText Vertica **Rating:** 4.0/5.0 stars **Reviewed by:** Kabir C. | Small-Business (50 or fewer emp.) **Reviewed Date:** February 03, 2024 **What do you like best about OpenText Vertica?** The best feature is how it helps integrating platforms and providing data analysis and business insights for the consumers. **What do you dislike about OpenText Vertica?** There are a lot many services offered and it takes time to understand them at first. **What problems is OpenText Vertica solving and how is that benefiting you?** OpenText is helping to get insights for customer and analysis of data has become lot easier and is in an understandable form **Official Response from Trish Schnupp:** > Thank you for taking the time to leave us a review! We appreciate your feedback! ### 22. Secured data shipping **Rating:** 3.5/5.0 stars **Reviewed by:** Amulya S. | Head of Marketing, Mid-Market (51-1000 emp.) **Reviewed Date:** January 28, 2024 **What do you like best about OpenText Vertica?** 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 OpenText Vertica?** The affordability might not be the best feature as not small startups can afford it. **What problems is OpenText Vertica solving and how is that benefiting you?** Complete one in all integration makes it easy good to go solution for data management **Official Response from Paige Roberts:** > Thank you for the review! Cheers, Paige ### 23. Review for Opentext Vertica **Rating:** 4.0/5.0 stars **Reviewed by:** Ishan S. | Audit Associate, Small-Business (50 or fewer emp.) **Reviewed Date:** January 31, 2024 **What do you like best about OpenText Vertica?** OpenText Vertica is really helpful to analyze data and providing business insights and analytics **What do you dislike about OpenText Vertica?** The products and services provided are a bit complicated to understand in the begining **What problems is OpenText Vertica solving and how is that benefiting you?** The data processing becomes really smooth and integration is seamless which makes the work easier. ### 24. it was amazing **Rating:** 4.5/5.0 stars **Reviewed by:** Basharat H. | Data Engineer, Mid-Market (51-1000 emp.) **Reviewed Date:** April 12, 2023 **What do you like best about OpenText Vertica?** Vertica is known for its versatility, speed, and investigation capacities. It is intended to deal with a lot of information and perform complex questions continuously. Vertica likewise has a columnar stockpiling design, which takes into consideration quicker information recovery and pressure. Vertica upholds a large number of information types, including organized, semi-organized, and unstructured information. It likewise offers worked in AI capacities, permitting clients to perform progressed examination and prescient demonstrating straightforwardly in the data set. Moreover, Vertica has an easy to understand interface and gives progressed investigation works, for example, geospatial examination, text search, and time-series investigation. In general, Vertica is a strong data set administration framework that is great for information driven associations hoping to dissect a lot of information rapidly and productively. **What do you dislike about OpenText Vertica?** One possible test with Vertica is that it might require particular abilities and information to set up and keep up with. Vertica is a complicated framework that requires cautious preparation and enhancement to accomplish ideal execution. Associations might have to put resources into preparing or recruit particular assets to actually deal with the information base. Another thought is that Vertica may not be the most ideal decision for associations that don't have huge informational collections or don't demand constant information examination. While Vertica is intended to deal with a lot of information, more modest informational indexes may not legitimize the interest in a particular data set administration framework. At long last, similar to any innovation, Vertica isn't safe to possible bugs or execution issues. Clients might experience issues with information exactness or inquiry execution, which can require endlessly investigating endeavors to determine. Generally, while Vertica offers many advantages, clients ought to painstakingly consider their association's particular requirements and assets prior to choosing this data set administration framework. **What problems is OpenText Vertica solving and how is that benefiting you?** Business Insight and Examination: Vertica is frequently utilized for information warehousing, business knowledge, and investigation. Its capacity to deal with enormous volumes of organized and unstructured information rapidly and productively makes it an ideal stage for these utilization cases. Ongoing Information Handling: Vertica's columnar stockpiling design and appropriated engineering go with it an amazing decision for constant information handling, for example, handling and dissecting information produced by IoT gadgets or continuous information streams. AI: Vertica incorporates worked in AI abilities that empower clients to perform progressed examination and prescient demonstrating straightforwardly inside the data set. Information Science: Vertica can be utilized for information science undertakings like exploratory information examination, information perception, and factual investigation. **Official Response from Paige Roberts:** > Thanks for taking the time to write a thorough review! Much appreciated, Paige ### 25. Review on vertica **Rating:** 5.0/5.0 stars **Reviewed by:** Shubhan P. | Technical implementation specialist, Mid-Market (51-1000 emp.) **Reviewed Date:** November 21, 2023 **What do you like best about OpenText Vertica?** I personally like theflexibility of vertica's projections of tables.It allows us to modifyprimary projection without altering the tables. **What do you dislike about OpenText Vertica?** I think the database setup is quite simple but the documentations could be improved a little bit.For example if 3 nodes are runnind and 1 node is down the other two nodes dont scale up. **What problems is OpenText Vertica solving and how is that benefiting you?** Its solving the client side ease of usage. Clients can easily compress and code the data based on their need. **Official Response from Paige Roberts:** > Thank you for writing the review. We really appreciate you taking the time. Cheers, Paige ### 26. Excel your Excellency **Rating:** 4.0/5.0 stars **Reviewed by:** Kuldeep S. | SDE 2, Mid-Market (51-1000 emp.) **Reviewed Date:** November 16, 2023 **What do you like best about OpenText Vertica?** OpenText Veryica excels in understanding context, generating coherent responses, and aiding various natural language processing tasks. Its strengths lie in its versatility, adaptability, and the ability to provide contextually relevant information based on input. Users benefit from its capacity to handle diverse language-related queries and tasks effectively. **What do you dislike about OpenText Vertica?** As of now there is nothing. I will feel free to mention if I will have anything. **What problems is OpenText Vertica solving and how is that benefiting you?** It is very effective and efficient. **Official Response from Paige Roberts:** > Thank you for taking the time to review! Much appreciated. Cheers, Paige ### 27. Good in handling High Performance **Rating:** 4.0/5.0 stars **Reviewed by:** Sushant K. | Data Analyst, Small-Business (50 or fewer emp.) **Reviewed Date:** February 07, 2024 **What do you like best about OpenText Vertica?** Handled high performance very efficiently. **What do you dislike about OpenText Vertica?** quite Expensive and sometime it lags in performance. **What problems is OpenText Vertica solving and how is that benefiting you?** I have used it to solve the high performance data. ### 28. Data analyst enthusiast with skills in data processing and warehousing **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Information Services | Small-Business (50 or fewer emp.) **Reviewed Date:** February 10, 2024 **What do you like best about OpenText Vertica?** It has fastest query processing engine with ease to use UI. Scaleable in terms of storage and clsutering. **What do you dislike about OpenText Vertica?** It is Expensive with large data size and it faces difficulty to process greater than 100tb data size. **What problems is OpenText Vertica solving and how is that benefiting you?** It is better than Google Bigquery in terms of fastest processing and fells secure than liveramp safehaven analytical platform. **Official Response from Trish Schnupp:** > Thank you for taking the time to leave us a review! We value your feedback! ### 29. Vertica consistently shines in performance **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Computer Software | Mid-Market (51-1000 emp.) **Reviewed Date:** January 23, 2024 **What do you like best about OpenText Vertica?** Despite its power, Vertica's interface is praised for being intuitive and user-friendly, even for beginners. This lowers the barrier to entry and allows wider access to data-driven insights within organizations. **What do you dislike about OpenText Vertica?** None as of now. Still new to explore more. **What problems is OpenText Vertica solving and how is that benefiting you?** Efficiently import and analyze large datasets for meaningful insights. Overcome the challenges of slow processing with large datasets, ensuring quick and reliable analytics. **Official Response from Paige Roberts:** > Thank you for the review! Cheers, Paige ### 30. Unified analytics platform **Rating:** 4.5/5.0 stars **Reviewed by:** Raghwendra S. | SDE 4, Enterprise (> 1000 emp.) **Reviewed Date:** November 30, 2023 **What do you like best about OpenText Vertica?** It allows us to work with multi cloud seamlessly and works good with scale **What do you dislike about OpenText Vertica?** Per TB licensing is not very user friendly and difficult to work with **What problems is OpenText Vertica solving and how is that benefiting you?** OpenText Vertica allowed us to setup a multi cloud data warehouse solution for one of the client **Official Response from Paige Roberts:** > Thank you so much for taking the time to review. Check with your sales rep, by the way. We also offer per node and other pricing options. Cheers, Paige ### 31. OpenText Vertica Review **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Civil Engineering | Enterprise (> 1000 emp.) **Reviewed Date:** January 23, 2024 **What do you like best about OpenText Vertica?** OpenText™ Vertica™ is best tool for High performance analytics works,handling large volumes of data , efficient storage capabilities, efficient query handling cabalities **What do you dislike about OpenText Vertica?** No such shortcomings witness so far. It is best tool for analytics. **What problems is OpenText Vertica solving and how is that benefiting you?** OpenText™ Vertica™ is helping in many ways which are high volume data handling, business insight making, data driven analytics. **Official Response from Paige Roberts:** > Thank you for the review! Much appreciated. Cheers, Paige ### 32. Vertica Big Data Analytics Platform **Rating:** 3.0/5.0 stars **Reviewed by:** Verified User in Broadcast Media | Small-Business (50 or fewer emp.) **Reviewed Date:** November 16, 2023 **What do you like best about OpenText Vertica?** 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. **What do you dislike about OpenText Vertica?** its difficult to implement on legacy platform on map reduce and hadoop. needs improvments on on premises clouds. **What problems is OpenText Vertica 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.. **Official Response from Paige Roberts:** > Thank you for taking the time to write a review. Always appreciated. Cheers, Paige ### 33. Simple setup and stable deployment **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Warehousing | Enterprise (> 1000 emp.) **Reviewed Date:** January 23, 2024 **What do you like best about OpenText Vertica?** Product does as adviced, Very simple to setup and deployment. **What do you dislike about OpenText Vertica?** Implementation of advance hadoop feature is not easy. **What problems is OpenText Vertica solving and how is that benefiting you?** We implemented flows for or real-time and backfill batch processing for or daily job to process data and update or fact and dim tables in warehouse ### 34. Good Analytical Database **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Telecommunications | Mid-Market (51-1000 emp.) **Reviewed Date:** July 05, 2023 **What do you like best about OpenText Vertica?** Vertica offers you a very good set of tools to perform analysis on the data.The processing power and the flexibility is one the major points why Vertica is best in class. **What do you dislike about OpenText Vertica?** Historically Vertica has been supported in Enterprise mode, which comes with a lot of limitations. This is being fixed with the introduction of EON mode on public cloud and private infrastructure but the change has been slow. Although we are getting there. **What problems is OpenText Vertica solving and how is that benefiting you?** Ingest and analyze large amount of data. Interface with BI tools to create visualizations of the data and show the value of the solution offered by my company to our customers. **Official Response from Paige Roberts:** > Thank you for the review! Cheers, Paige ### 35. Speed up with this **Rating:** 4.0/5.0 stars **Reviewed by:** Suru S. | Data Science Trainee, Mid-Market (51-1000 emp.) **Reviewed Date:** February 06, 2023 **What do you like best about OpenText Vertica?** Can perform any type of analytics, in our use-case we use Time Series, Pattern Matching by ingesting data gathering from different data sources available performing parallel processing within a short span of time as it is quick. Either get the work done on-premise or on cloud or a mixture of both would do too. Being in the BigData industry, it supports even Parquet and ORC data formats too which is a small but a useful advantage too. **What do you dislike about OpenText Vertica?** A little difficult to setup when shifting from physical on-prem to cloud infra. Apart from that the Vertica Accelerator if available on other Cloud platforms would be nice as it is only limited to AWS, where organizations using other platforms would not be able to take advantage of it. **What problems is OpenText Vertica solving and how is that benefiting you?** A Data Warehousing solution that mitigates the problem of slow processing with large data, helps in modeling data, driving organizations to carry out good decisions regarding the business at a low cost. **Official Response from Paige Roberts:** > Thanks for taking the time to write a review! Much appreciated, Paige ### 36. Finally an Analytic Database management tool for Enterprise Segment **Rating:** 4.5/5.0 stars **Reviewed by:** Arpit J. | Salesforce Solution Architect, Enterprise (> 1000 emp.) **Reviewed Date:** December 21, 2022 **What do you like best about OpenText Vertica?** The best part about this enterprise Analytical Database management tool is the speed. We literally have more than a thousand million rows of data kept there and it is still the fastest tool I came across. Also, we migrtated from the On-Premise to On-Cloud version of it. Also it supports multiple languages which makes it easy for accessing the data. **What do you dislike about OpenText Vertica?** The only thing I dislike about this tool was the lack of support in migration from On Premise to On Cloud. We had to take help from External consulting team due to the lack of trainings and tutorials available. **What problems is OpenText Vertica solving and how is that benefiting you?** We are keeping the whole customer order data in this tool to analyze the purchasing patterns and devising our Incentive compensation and marketing strategies accordingly. We are also using this for statistical analysis and pattern matching. **Official Response from Paige Roberts:** > Hi Arpit, Thanks so much for the great review! Much appreciated, Paige ### 37. Nice DW solution although not the best **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Computer Software | Mid-Market (51-1000 emp.) **Reviewed Date:** May 25, 2023 **What do you like best about OpenText Vertica?** It is a pretty stable Datawarehouse solution and really manageable in some aspects as many other similar solutions it allows for scale of thousands and thousands of records **What do you dislike about OpenText Vertica?** It has a lot of flaws like sometimes queries would take ages if you are not constantly purging your tables (in case you do a lot of deletes over that table) something I haven't experienced in other solutions like Redshift **What problems is OpenText Vertica solving and how is that benefiting you?** A data warehouse of a large-scale reporting data warehouse that provided a centralized data solution for many data consumer applications and principal storage of fact processed information **Official Response from Paige Roberts:** > Thanks so much for taking the time to write a review. I'll pass on your feedback to the product managers. Cheers, Paige ### 38. Use of vertica as a date warehouse **Rating:** 5.0/5.0 stars **Reviewed by:** Ahmed F. | Mid-Market (51-1000 emp.) **Reviewed Date:** February 15, 2023 **What do you like best about OpenText Vertica?** Very useful functions in vertica and lots of ways to optimize queries. The documentation of vertica is very extensive. Being a columnar database, it's very effective in analytical uses. **What do you dislike about OpenText Vertica?** Sometimes performs poorly because of some builtin features like non existence of nvarchar or varchar2 datatype, no qualify function etc **What problems is OpenText Vertica solving and how is that benefiting you?** Replication of temenos 24 banking application **Official Response from Paige Roberts:** > Thank you for the review! Cheers, Paige ### 39. Vertica is a columnar database management system designed for large-scale data analytics **Rating:** 4.0/5.0 stars **Reviewed by:** jeetendra g. | Cofounder and CTO , Enterprise (> 1000 emp.) **Reviewed Date:** February 10, 2023 **What do you like best about OpenText Vertica?** if you are having very large data volumes and high-speed data ingestion need for your data lake vertica is best solution. Vertica uses advanced compression techniques to reduce the amount of storage space needed for data, improving overall efficiency **What do you dislike about OpenText Vertica?** Vertica is optimized for large-scale data analytics, but may not be suitable for smaller data sets or use cases that do not require high performance. **What problems is OpenText Vertica solving and how is that benefiting you?** Vertica is designed to provide fast query performance, even for complex analytics, by using columnar storage and in-memory processing. All our datalake usecases was solved using vertica. **Official Response from Paige Roberts:** > Thank you for the nice review, Jeetendra! Cheers, Paige ### 40. Flexible and scalable **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Computer Software | Small-Business (50 or fewer emp.) **Reviewed Date:** January 30, 2023 **What do you like best about OpenText Vertica?** its ability to process large amounts of data quickly and efficiently, making it an ideal solution for organizations that need to process data in real-time. It provides robust security features, including encryption, access controls, and auditing, to ensure that data is protected and secure. **What do you dislike about OpenText Vertica?** It is complex to install and maintain, which can make it challenging without extensive technical expertise. Vertica can be a relatively expensive solution, especially for organizations with limited budgets. **What problems is OpenText Vertica solving and how is that benefiting you?** Vertica's real-time analytics capabilities can lead to improved business outcomes, such as better-informed decisions, improved operational efficiency, and reduced costs. **Official Response from Paige Roberts:** > Thanks for the review! Cheers, Paige ### 41. Software Engineer **Rating:** 3.5/5.0 stars **Reviewed by:** Verified User in Financial Services | Enterprise (> 1000 emp.) **Reviewed Date:** November 11, 2022 **What do you like best about OpenText Vertica?** 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 OpenText Vertica?** 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 OpenText Vertica 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. **Official Response from Paige Roberts:** > Thanks for the great review! Really appreciate you taking the time. Cheers, Paige ### 42. A very satisfied programmer ,curious on how you guys achieve this **Rating:** 4.0/5.0 stars **Reviewed by:** AKSHAY R. | Software Engineer II, Mid-Market (51-1000 emp.) **Reviewed Date:** July 02, 2022 **What do you like best about OpenText Vertica?** Performance. We can process millions of records and the aggregation operation is also super fast. Also, the insert operation is not taking that much time. The usage of CTEs which actually her stands in analogous to temp table operation is also very useful. **What do you dislike about OpenText Vertica?** A native development environment and absence of parameters and absence of stored procedures. It would be better if you could provide all these and along with some profiler service. Plus the performance is very poor if we use UNION ALL operation that too with the same data set. **Recommendations to others considering OpenText Vertica:** Absence of parameters and stored procedures leads to extensive use of dynamic queries, which should be handled by the backend **What problems is OpenText Vertica solving and how is that benefiting you?** First of all it's super fast. I don't know how you guys do that and I couldn't see any perfect documentation on this as well. The aggregation operation is so fast that we are planning for data streaming rather than ETL and we hope the same performance will be there as well. We are processing millions of records within milliseconds using Vertica, and there is no considerable variation in performance even when we use "OR" conditions in filter, which is one of the bottlenecks in conventional RDBMSs **Official Response from Paige Roberts:** > Thanks so much for taking the time to write a review. We really appreciate it. As an FYI, I'm not sure what version you're using, but the latest versions have stored procedures. They're pretty basic for the moment, but getting more feature rich all the time. You might also look at flattened tables as an option if you need a UNION ALL, but need it to be more performant. Not sure if it will help, but worth a look: https://www.vertica.com/docs/latest/HTML/Content/Authoring/AnalyzingData/FlattenedTables/FlattenedTables.htm Good luck with your work! Paige ### 43. 4 years of experience with using vertica for our BI tool Lumenore. **Rating:** 4.5/5.0 stars **Reviewed by:** kapil m. | Senior Software Engineer, Mid-Market (51-1000 emp.) **Reviewed Date:** July 02, 2022 **What do you like best about OpenText Vertica?** All the syntax and function naming speaks for themself on top of that good documentation always comes to the rescue they also have very active and huge community for helping in case. **What do you dislike about OpenText Vertica?** no multi-line insert statement is kinda stopping us sometimes need some tweaking around to find the exact solution which will work perfectly It is inherent problem when you comes to columunar DB. **Recommendations to others considering OpenText Vertica:** best for data storage and bi tools **What problems is OpenText Vertica solving and how is that benefiting you?** we need to store a huge amount of data in the database and query some of it at a time. while querying few column from big database it takes constant amount of time when using vertica **Official Response from Paige Roberts:** > Thank you for the great review! Lumenore is such a cool product. Love the NLP interface. Cheers, Paige ### 44. Excellent **Rating:** 5.0/5.0 stars **Reviewed by:** Mazher S. | DevOps Technical Lead, Small-Business (50 or fewer emp.) **Reviewed Date:** February 07, 2023 **What do you like best about OpenText Vertica?** Everything about vertica It's a very good loved it very much **What do you dislike about OpenText Vertica?** Nothing is there to dislike I mean it's good **What problems is OpenText Vertica solving and how is that benefiting you?** Big data processing problem it's solving **Official Response from Paige Roberts:** > Thank you for the review! Cheers, Paige ### 45. If you have large amount of data this vertica is the tool for you! **Rating:** 4.0/5.0 stars **Reviewed by:** Nan G. | Software engineer, Enterprise (> 1000 emp.) **Reviewed Date:** November 19, 2022 **What do you like best about OpenText Vertica?** Quickly ingest a large amount of data from various sources and low cost compared to other analytical databases. **What do you dislike about OpenText Vertica?** Documentation is poor and has few resources to seek for help other than their official doc site. **What problems is OpenText Vertica solving and how is that benefiting you?** We have a massive amount of data from various sources that need to be processed; Vertica makes it easy to ingest this large amount of data. **Official Response from Paige Roberts:** > Thanks for the review! Really appreciate you taking the time. Cheers, Paige ### 46. I have worked for more than 4 years in ETL and data warehousing using Teradata and vertica **Rating:** 5.0/5.0 stars **Reviewed by:** Akshaykumar J. | Senior Software Engineer, Enterprise (> 1000 emp.) **Reviewed Date:** July 14, 2022 **What do you like best about OpenText Vertica?** There is no need to create data structures again. It enables to integrate millions of rows to be delivered in real time basis.It also provides advanced analytics features that are not there in Teradata or other platforms. **What do you dislike about OpenText Vertica?** I think vertica should be flexible with cloud providers like Azure, AWS and Google Cloud Platform like Snowflake does. The storage cost and query execution should be more secure using service accounts. **Recommendations to others considering OpenText Vertica:** It is a very good tool for data warehousing and big data. **What problems is OpenText Vertica solving and how is that benefiting you?** Vertica is helping me to fetch millions of rows in real time basis. Vertica has faster processing speed although it uses around 90% of space. i thinythey have designed vertica by keeping business needs in mind. **Official Response from Paige Roberts:** > Thank you for the outstanding review! Just FYI, Vertica is available on all the major clouds, Azure, AWS, Google and Alibaba. If you're using the SaaS version, Vertica Accelerator, it is only available on Amazon for now, but stay tuned. We're expanding to the other clouds asap. Thanks again for the great review. Cheers, Paige ### 47. Vertica -One stop shop for variety of Analytical Functions! **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Enterprise (> 1000 emp.) **Reviewed Date:** November 15, 2022 **What do you like best about OpenText Vertica?** More than a typical data warehousing solution, Vertica offers solutions for most complex analytical workloads and predictive analytics capabilities and works with most cloud service providers, including AWS, GCP and Azure. **What do you dislike about OpenText Vertica?** Product documentation and learning platform for developers and consultants can be improved so that people who want to learn Vertica can find it easy. Certification offerings to validate consultant knowledge would also help. **What problems is OpenText Vertica solving and how is that benefiting you?** Vertica enables organizations on their journey of Analytics supremacy by helping with greater deployment flexibility, advanced machine learning scenarios, and predictive analytics, all on cloud or on-premise as needed. **Official Response from Paige Roberts:** > Thanks for the review! Check out https://academy.vertica.com/ the Vertica Academy for free on-demand training and certification. Cheers, Paige ### 48. Data Analytics with Vertica **Rating:** 3.5/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Small-Business (50 or fewer emp.) **Reviewed Date:** November 15, 2022 **What do you like best about OpenText Vertica?** 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 OpenText Vertica?** 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 OpenText Vertica 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. **Official Response from Paige Roberts:** > Thanks for the review! Appreciate you taking the time. Cheers, Paige ### 49. Constantly improving And adapting **Rating:** 3.5/5.0 stars **Reviewed by:** Verified User in Computer Games | Mid-Market (51-1000 emp.) **Reviewed Date:** January 16, 2022 **What do you like best about OpenText Vertica?** One thing that stood out is the ease of use and having my data accessible and being able to integrate various tools like Tableau Server to help visualize and analyze the data with ease. **What do you dislike about OpenText Vertica?** I was bothered by the fact that I'm not able to migrate the data from one cluster to another as whole schemas instead of exporting the data into an S3 bucket using select statements and then importing that data into the destination cluster which caused multiple issues with some timestamp values in some tables, But I managed to work around this issue by changing the Data partitioning mode to node partitioning. **Recommendations to others considering OpenText Vertica:** Do you want Vertica? Get a team to manage and administer it. **What problems is OpenText Vertica solving and how is that benefiting you?** Vertica is playing a huge role in the collection, storage and analysis of data that are pouring in from multiple sources. the company is accessing its data instantly and we can put plans in action to address issues before they appear thanks to the data stored in Vertica which is allowing us to monitor and predict trends **Official Response from Paige Roberts:** > Thank you for taking the time to review! We're certainly doing our best to constantly improve. I'll pass on your comments on cluster to cluster data transfer difficulty to our engineers. Thanks again, Paige ### 50. Great experience **Rating:** 5.0/5.0 stars **Reviewed by:** VENKATA SATYA SAI SIDDHARTHA K. | Data engineer, Mid-Market (51-1000 emp.) **Reviewed Date:** July 09, 2022 **What do you like best about OpenText Vertica?** User interface and the last one is the best in the call I can't find it on my phone so I don't know the number of sleepless nights I had beacuse of harsh mails sent to me by the intial and **What do you dislike about OpenText Vertica?** Services to use for the support and understanding during my work with the insights you might have already know about this project in under targeted delivery timelines **Recommendations to others considering OpenText Vertica:** Get some time on introspection Will take care of other partitions **What problems is OpenText Vertica solving and how is that benefiting you?** Data Analyst position requires the ability to be successful in the field Not entirely sure where this aritiffical hype will end up with the insights you might have already ## OpenText Vertica Discussions - [What offerings are there to run it in AWS cloud?](https://www.g2.com/discussions/what-offerings-are-there-to-run-it-in-aws-cloud) - 1 comment, 1 upvote - [need to check](https://www.g2.com/discussions/36279-need-to-check) - 1 comment, 1 upvote - [More and more technical documentation should be available for](https://www.g2.com/discussions/34471-more-and-more-technical-documentation-should-be-available-for) - 1 comment, 1 upvote - [How do I learn advanced methods and tuning of queries for free by vertica official](https://www.g2.com/discussions/34344-how-do-i-learn-advanced-methods-and-tuning-of-queries-for-free-by-vertica-official) - 1 comment, 1 upvote - [Is it hard to learn to be a Vertica user? Admin?](https://www.g2.com/discussions/user-friendly) - 2 comments, 1 upvote - [View OpenText Vertica pricing details and edition comparison](https://www.g2.com/products/opentext-vertica/reviews?section=pricing&secure%5Bexpires_at%5D=2026-05-19+03%3A48%3A02+-0500&secure%5Bsession_id%5D=61a8e85c-65f8-4cf2-ac15-9b258a2f2bbd&secure%5Btoken%5D=d82357263d75519bd9dd01b861187215a0bc785f91a0f2da89621f6f6ee99f77&format=llm_user) ## OpenText Vertica Features **Data Management** - Data Integration - Data Compression - Data Quality - Built-In Data Analytics - In-Database Machine Learning - Data Lake Analytics **Storage** - Data Model - Data Types **Database** - Real-Time Data Collection - Data Distribution - Data Lake **Integration** - AI/ ML Integration - BI Tool Integration - Data lake Integration **Availability** - Auto Sharding - Auto Recovery - Data Replication **Integrations** - Hadoop Integration - Spark Integration **Deployment** - On-Premise - Cloud **Performance** - Integrated Cache **Platform** - Machine Scaling - Data Preparation - Spark Integration **Performance ** - Scalability **Security** - Role-Based Authorization - Authentication - Audit Logs - Encryption **Processing** - Cloud Processing - Workload Processing **Security** - Data Governance - Data Security **Support** - Multi-Model - Operating Systems **Generative AI** - AI Text Generation - AI Text Summarization **Building Reports** - Data Transformation - Data Modeling - WYSIWYG Report Design - Integration APIs **Platform** - Mobile User Support - Customization - User, Role, and Access Management - Internationalization - Sandbox / Test Environments - Performance and Reliability - Breadth of Partner Applications ## Top OpenText Vertica Alternatives - [Google Cloud BigQuery](https://www.g2.com/products/google-cloud-bigquery/reviews) - 4.5/5.0 (1,157 reviews) - [Snowflake](https://www.g2.com/products/snowflake/reviews) - 4.6/5.0 (687 reviews) - [Amazon Redshift](https://www.g2.com/products/amazon-redshift/reviews) - 4.3/5.0 (368 reviews)