We performed a comparison between Azure Data Factory and Vertica based on real PeerSpot user reviews.
Find out in this report how the two Cloud Data Warehouse solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."The overall performance is quite good."
"I am one hundred percent happy with the stability."
"The most valuable feature of Azure Data Factory is the core features that help you through the whole Azure pipeline or value chain."
"I think it makes it very easy to understand what data flow is and so on. You can leverage the user interface to do the different data flows, and it's great. I like it a lot."
"The data factory agent is quite good and programming or defining the value of jobs, processes, and activities is easy."
"The most valuable features are data transformations."
"I like the basic features like the data-based pipelines."
"I enjoy the ease of use for the backend JSON generator, the deployment solution, and the template management."
"The feature of the product that is most important is the speed. I needed a columnar database, and its speed is what it's built to do, and so that's what really does differentiate Vertica from its competitors."
"I enjoy the cybersecurity and backup features."
"Eighty percent of the ETL operations have improved since implementing this solution."
"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."
"DBAs don’t need to add a partition every month/quarter like with other DBs."
"Bulk loads, batch loads, and micro-batch loads have made it possible for our organization to process near real-time ingestions and faster analytics."
"It has improved my organization's functionality and performance."
"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."
"You cannot use a custom data delimiter, which means that you have problems receiving data in certain formats."
"Azure Data Factory can improve the transformation features. You have to do a lot of transformation activities. This is something that is just not fully covered. Additionally, the integration could improve for other tools, such as Azure Data Catalog."
"Azure Data Factory could benefit from improvements in its monitoring capabilities to provide a more robust feature set. Enhancing the ease of deployment to higher environments within Azure DevOps would be beneficial, as the current process often requires extensive scripting and pipeline development. It is also known for the flexibility of the data flow feature, particularly in supporting more dynamic data-driven architectures. These enhancements would contribute to a more seamless and efficient workflow within GitLab."
"Azure Data Factory's pricing in terms of utilization could be improved."
"Data Factory's performance during heavy data processing isn't great."
"A room for improvement in Azure Data Factory is its speed. Parallelization also needs improvement."
"The product could provide more ways to import and export data."
"The support and the documentation can be improved."
"Some of our small to medium-sized customers would like to see containerization and flexibility from the deployment standpoint."
"It should provide a GUI interface for data management and tuning."
"Limitations in group by projections is where I would like to see an improvement."
"One feature, which has really benefited us, is the scalability offered by Vertica as it has enabled Pythian's clients to manage data with agility."
"The integration of this solution with ODI could be improved."
"When it is about to reach the maximum storage capacity, it becomes slow."
"They could improve the integration and some of the features in the cloud version."
"The integration with AI has room for improvement."
Azure Data Factory is ranked 3rd in Cloud Data Warehouse with 81 reviews while Vertica is ranked 7th in Cloud Data Warehouse with 83 reviews. Azure Data Factory is rated 8.0, while Vertica is rated 8.2. The top reviewer of Azure Data Factory writes "The data factory agent is quite good but pricing needs to be more transparent". On the other hand, the top reviewer of Vertica writes " A user-friendly tool that needs to improve its documentation part". Azure Data Factory is most compared with Informatica PowerCenter, Informatica Cloud Data Integration, Alteryx Designer, Snowflake and IBM InfoSphere DataStage, whereas Vertica is most compared with Snowflake, SQL Server, Amazon Redshift, Teradata and Oracle Exadata. See our Azure Data Factory vs. Vertica report.
See our list of best Cloud Data Warehouse vendors.
We monitor all Cloud 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.