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."Feature-wise, one of the most valuable ones is the data flows introduced recently in the solution."
"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."
"Allows more data between on-premises and cloud solutions"
"The solution has a good interface and the integration with GitHub is very useful."
"The most valuable features are data transformations."
"The most valuable feature is the ease in which you can create an ETL pipeline."
"ADF is another ETL tool similar to Informatica that can transform data or copy it from on-prem to the cloud or vice versa. Once we have the data, we can apply various transformations to it and schedule our pipeline according to our business needs. ADF integrates with Databricks. We can call our Databricks notebooks and schedule them via ADF."
"This solution will allow the organisation to improve its existing data offerings over time by adding predictive analytics, data sharing via APIs and other enhancements readily."
"Allows us to take volumes and process them at a very high speed."
"Vertica enabled us to close large deals. Customers with large data sets had to be migrated from PostgreSQL to Vertica due to performance."
"DBAs don’t need to add a partition every month/quarter like with other DBs."
"The solution has great capabilities. The tool that instructs the internal database forward is easy to use and is very powerful."
"The product's initial setup phase is extremely simple."
"It has improved my organization's functionality and performance."
"The most valuable feature of Vertica is the unmatchable database performance."
"I don't need any special hardware. I can use commodity hardware, which is nice to have in a commercial solution."
"There is no built-in function for automatically adding notifications concerning the progress or outline of a pipeline run."
"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 uses many resources and has issues with parallel workflows."
"Data Factory has so many features that it can be a little difficult or confusing to find some settings and configurations. I'm sure there's a way to make it a little easier to navigate."
"You cannot use a custom data delimiter, which means that you have problems receiving data in certain formats."
"We require Azure Data Factory to be able to connect to Google Analytics."
"Real-time replication is required, and this is not a simple task."
"Data Factory would be improved if it were a little more configuration-oriented and not so code-oriented and if it had more automated features."
"Vertica's native cloud support could be improved, and its installation could be made easier."
"Documentation has become much better, but can always use some improvement."
"Support is an area where it could get better."
"Performance of management of metadata layer (database catalog) needs improvement. We still have to have smaller customers on PostgreSQL; Vertica cannot manage thousands of schemata."
"The documentation of Vertica is an area with shortcomings where improvements are required."
"I would personally like to see extended developer tooling suited to Vertica – think published PowerDesigner SQL dialect support."
"Vertica offers a platform-as-a-service version, but their software-as-a-service solution is only available on AWS. They need to get a SaaS version on Azure and GCP as fast as possible."
"If you do not utilize the tuning tools like projections, encoding, partitions, and statistics, then performance and scalability will suffer."
Azure Data Factory is ranked 3rd in Cloud Data Warehouse with 81 reviews while Vertica is ranked 6th 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 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.