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 data mapping and the ability to systematically derive data are nice features. It worked really well for the solution we had. It is visual, and it did the transformation as we wanted."
"One of the most valuable features of Azure Data Factory is the drag-and-drop interface. This helps with workflow management because we can just drag any tables or data sources we need. Because of how easy it is to drag and drop, we can deliver things very quickly. It's more customizable through visual effect."
"The overall performance is quite good."
"The most important feature is that it can help you do the multi-threading concepts."
"I like that it's a monolithic data platform. This is why we propose these solutions."
"The most valuable feature of Azure Data Factory is the core features that help you through the whole Azure pipeline or value chain."
"Data Factory's best features are simplicity and flexibility."
"The solution includes a feature that increases the number of processors used which makes it very powerful and adds to the scalability."
"The product's initial setup phase is extremely simple."
"The most valuable feature of Vertica is the unmatchable database performance."
"DBAs don’t need to add a partition every month/quarter like with other DBs."
"I enjoy the cybersecurity and backup features."
"Initiate on one node, and the RPM propagates automatically to all other nodes. "
"Vertica's most outstanding features are the compression rates achieved and the speed of access of high volume data."
"Vertica gives knowledgeable users and DBAs excellent tools for tuning."
"Vertica has a few features that I like. From an architecture standpoint, they have separated compute and storage. So you have low-cost object storage for primary storage and the ability to have several sub-clusters working off the same ObjectStore. So it provides workload isolation."
"Data Factory's performance during heavy data processing isn't great."
"Sometimes I need to do some coding, and I'd like to avoid that. I'd like no-code integrations."
"Azure Data Factory should be cheaper to move data to a data center abroad for calamities in case of disasters."
"I rate Azure Data Factory six out of 10 for stability. ADF is stable now, but we had problems recently with indexing on an SQL database. It's slow when dealing with a huge volume of data. It depends on whether the database is configured as general purpose or hyperscale."
"The solution can be improved by decreasing the warmup time which currently can take up to five minutes."
"One area for improvement is documentation. At present, there isn't enough documentation on how to use Azure Data Factory in certain conditions. It would be good to have documentation on the various use cases."
"When the record fails, it's tough to identify and log."
"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."
"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."
"I have found that coding support could be simplified."
"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."
"It should provide a GUI interface for data management and tuning."
"I believe the installation process could be streamlined."
"The documentation of Vertica is an area with shortcomings where improvements are required."
"Limitations in group by projections is where I would like to see an improvement."
"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 6th in Cloud Data Warehouse with 82 reviews. Azure Data Factory is rated 8.0, while Vertica is rated 8.4. 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 Microsoft Azure Synapse Analytics, 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.