We performed a comparison between Azure Data Factory and IBM Db2 Warehouse 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."From my experience so far, the best feature is the ability to copy data to any environment. We have 100 connects and we can connect them to the system and copy the data from its respective system to any environment. That is the best feature."
"The initial setup is very quick and easy."
"Data Factory's best features include its data source connections, GUI for building data pipelines, and target loading within Azure."
"When it comes to our business requirements, this solution has worked well for us. However, we have not stretched it to the limit."
"I like its integration with SQL pools, its ability to work with Databricks, its pipelines, and the serverless architecture are the most effective features."
"What I like best about Azure Data Factory is that it allows you to create pipelines, specifically ETL pipelines. I also like that Azure Data Factory has connectors and solves most of my company's problems."
"The scalability of the product is impressive."
"The most valuable feature is the ease in which you can create an ETL pipeline."
"Some of the best features are stored procedures, parallelism, and different indexing strategies."
"The solution is stable."
"It can be mounted on the cloud, which is a huge plus. If the client, for example, starts small with on-premise deployment and then it rapidly needs to grow, we can transfer this to the cloud easily."
"The analytics engine is not bad at forecasting predictions."
"I think it scales really well and as long as you take enough time to learn a little bit about it, it works really well."
"The standout feature of IBM Db2 Warehouse, which is particularly valuable for large enterprises, is its ability to handle big data."
"Provides good security and reliability."
"There should be a way that it can do switches, so if at any point in time I want to do some hybrid mode of making any data collections or ingestions, I can just click on a button."
"There is no built-in function for automatically adding notifications concerning the progress or outline of a pipeline run."
"Azure Data Factory can improve by having support in the drivers for change data capture."
"There is no built-in pipeline exit activity when encountering an error."
"Azure Data Factory's pricing in terms of utilization could be improved."
"The solution needs to integrate more with other providers and should have a closer integration with Oracle BI."
"They require more detailed error reporting, data normalization tools, easier connectivity to other services, more data services, and greater compatibility with other commonly used schemas."
"Data Factory's cost is too high."
"There were some initial challenges with IBM Db2 Warehouse about eight months ago when I worked in this environment. When I coordinated with IBM support, they mentioned that the memory was insufficient for our needs. Our business environment required significantly more memory than the previous cluster could provide. Consequently, we have worked closely with on-site IBM technical personnel to address this issue."
"In terms of improvement, IBM Db2 Warehouse should be more scalable."
"IBM Db2 Warehouse needs to improve its interface."
"The biggest problems we have is when the backup solution is failing or slow and we run out of log space, which has happened probably a couple of times in the last four years."
"The areas of the solution that is needing the most improvement are separating compute from storage, elasticity, which means scaling up and then retracting."
"Lacks sufficient documentation and particularly in Spanish."
"There should be more material available for training and training should be free."
"The biggest challenge anyone could have with Db2 Warehouse is their references or online resources and documentation. They are very, very, very limited on the web."
Azure Data Factory is ranked 3rd in Cloud Data Warehouse with 81 reviews while IBM Db2 Warehouse is ranked 12th in Data Warehouse with 9 reviews. Azure Data Factory is rated 8.0, while IBM Db2 Warehouse is rated 7.8. 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 IBM Db2 Warehouse writes "Useful for ETL process and has good documentation ". Azure Data Factory is most compared with Informatica PowerCenter, Informatica Cloud Data Integration, Alteryx Designer, Snowflake and IBM InfoSphere DataStage, whereas IBM Db2 Warehouse is most compared with Oracle Exadata, Snowflake, Amazon Redshift, IBM Db2 Warehouse on Cloud and Apache Hadoop. See our Azure Data Factory vs. IBM Db2 Warehouse 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.