We performed a comparison between Azure Data Factory and Oracle Database Appliance 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."I am one hundred percent happy with the stability."
"Data Factory's best features are connectivity with different tools and focusing data ingestion using pipeline copy data."
"The most important feature is that it can help you do the multi-threading concepts."
"The most valuable feature of Azure Data Factory is that it has a good combination of flexibility, fine-tuning, automation, and good monitoring."
"We have found the bulk load feature very valuable."
"I like that it's a monolithic data platform. This is why we propose these solutions."
"The most valuable feature is the ease in which you can create an ETL pipeline."
"The user interface is very good. It makes me feel very comfortable when I am using the tool."
"Easy management (it saves a lot of installation and patching time)."
"NVM Express (NVMe) solid-state drives: This technology brings outstanding I/O performance for midsize databases. We have tested it by doing POCs on customer sites and the results were quite satisfying."
"The most valuable feature of Oracle Database Appliance is the ease of management."
"The solution is pretty automated, which takes out the possibility of human error."
"The product is very light."
"The product’s valuable feature is its capability to pre-configure and pre-install the settings."
"Oracle Database Appliance is a stable solution. We have clients that have been running it for 10 years."
"The performance due to the all-flash of ODA is very nice."
"A room for improvement in Azure Data Factory is its speed. Parallelization also needs improvement."
"Areas for improvement in Azure Data Factory include connectivity and integration. When you use integration runtime, whenever there's a failure, the backup process in Azure Data Factory takes time, so this is another area for improvement."
"The Microsoft documentation is too complicated."
"Data Factory could be improved by eliminating the need for a physical data area. We have to extract data using Data Factory, then create a staging database for it with Azure SQL, which is very, very expensive. Another improvement would be lowering the licensing cost."
"If the user interface was more user friendly and there was better error feedback, it would be helpful."
"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."
"Lacks a decent UI that would give us a view of the kinds of requests that come in."
"The pricing scheme is very complex and difficult to understand."
"The product is quite complex to set up, initially. It would be ideal if it was simpler."
"Virtualization features could also be improved. A web-based GUI would be a good start."
"The product's pricing is too high. We plan to migrate to another database in three to four years."
"The setup is a bit complex."
"Even though the solution can handle a lot of data, it's just too expensive currently."
"The license cost could be cheaper, especially for long-term contracts."
"The solution's initial setup is not easy."
"The feature that I would like to see improve is the interface. It is really not good. I almost have to work on script by script in it. There is always some issue with the user interface."
Azure Data Factory is ranked 3rd in Cloud Data Warehouse with 81 reviews while Oracle Database Appliance is ranked 6th in Data Warehouse with 40 reviews. Azure Data Factory is rated 8.0, while Oracle Database Appliance is rated 8.0. 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 Oracle Database Appliance writes "Simplifies database management tasks and provides high availability and disaster recovery". Azure Data Factory is most compared with Informatica PowerCenter, Informatica Cloud Data Integration, Alteryx Designer, Snowflake and IBM InfoSphere DataStage, whereas Oracle Database Appliance is most compared with Oracle Exadata, VMware Tanzu Greenplum, Dremio, Actian Ingres and SAP BW4HANA. See our Azure Data Factory vs. Oracle Database Appliance 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.