Teddy EliasSenior Manager, Systems and Network Engineering at a computer software company
We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
"I am very satisfied with the customer service/technical support."
"The most valuable features are the performance and usability."
"The most valuable feature for me is querying."
"One of the most important features is the ease of using MS SQL."
"The most valuable feature of this solution is performance."
"The data transmissions between the data models is the most valuable feature."
"The most valuable feature is the business intelligence (BI) part of it."
"We are able to monitor daily jobs, so if there is anything that needs to be done then we can do it."
"Eighty percent of the ETL operations have improved since implementing this solution."
"The performance is very good and the aggregate records are fast."
"Vertica's most outstanding features are the compression rates achieved and the speed of access of high volume data."
"Allows us to take volumes and process them at a very high speed."
"For me, It's performance, scalability, low cost, and it's integrated into enterprise and big data environments."
"Speed and resiliency are probably the best parts of this product."
"It has improved my organization's functionality and performance."
"The solution has great capabilities. The tool that instructs the internal database forward is easy to use and is very powerful."
"In the future I would love to see a slightly better automation engine, just for the data integration layer, to make it slightly easier for end-users or junior developers to get involved in incremental updating."
"More tools to help designers should be included."
"I would like to see better visualization features."
"I think that the error messages need to be made more specific."
"The reporting for certain types of data needs to be improved."
"This solution would be improved with an option for in-memory data analysis."
"If the database is large with a lot of columns then it is difficult to clean the data."
"I would like the tool to support different operating systems."
"Fact-to-fact joins on multi-billion record tables perform poorly."
"When it is about to reach the maximum storage capacity, it becomes slow."
"Support is an area where it could get better."
"Promotion/marketing must be improved, even though it is a very useful product at very good price, it is not as "popular" as it should be."
"Some of our small to medium-sized customers would like to see containerization and flexibility from the deployment standpoint."
"The geospatial functionality could be designed better."
"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."
"They could improve on customer service."
"I think the program is well-priced compared to the other offerings that are out in the market."
"Microsoft has an agreement with the government in our country, so our customers get their licensing costs from the Ministry. Whenever we work with any government, company, or government institute, which is mainly what we are doing, that license comes directly from the Ministry of Technology and Information."
"All the features that we use do not require any additional subscription or yearly fees."
"From a cost perspective, the software is less than most of its competitors."
"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."
"The price could be cheaper and it is best to negotiate the price."
The traditional structured relational data warehouse was never designed to handle the volume of exponential data growth, the variety of semi-structured and unstructured data types, or the velocity of real time data processing. Microsoft's SQL Server data warehouse solution integrates your traditional data warehouse with non-relational data and it can handle data of all sizes and types, with real-time performance.
Micro Focus Vertica is the most advanced SQL database analytics portfolio built from the very first line of code to address the most demanding Big Data analytics initiatives. Micro Focus Vertica delivers speed without compromise, scale without limits, and the broadest range of consumption models. Choose Vertica on premise, on demand, in the cloud, or on Hadoop. With support for all leading BI and visualization tools, open source technologies like Hadoop and R, and built-in analytical functions, Vertica helps you derive more value from your Enterprise Data Warehouse and data lakes and get to market faster with your analytics initiatives.
To learn more about Micro Focus Vertica Advanced Analytics, visit our website.
Microsoft Parallel Data Warehouse is ranked 6th in Data Warehouse with 11 reviews while Vertica is ranked 4th in Data Warehouse with 8 reviews. Microsoft Parallel Data Warehouse is rated 7.6, while Vertica is rated 9.0. The top reviewer of Microsoft Parallel Data Warehouse writes "Collects data through SSIS packages from different sources and puts them all in one data repository". On the other hand, the top reviewer of Vertica writes "Superior performance in speed and resilience makes this a very good warehousing solution". Microsoft Parallel Data Warehouse is most compared with Microsoft Azure Synapse Analytics, Oracle Exadata, Snowflake and SAP BW4HANA, whereas Vertica is most compared with Snowflake, Amazon Redshift, Teradata, SQL Server and Apache Hadoop. See our Microsoft Parallel Data Warehouse vs. Vertica report.
See our list of best Data Warehouse vendors.
We monitor all Data Warehouse reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.