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."It is beneficial that the solution is written with Spark as the back end."
"The most valuable feature is the ease in which you can create an ETL pipeline."
"UI is easy to navigate and I can retrieve VTL code without knowing in-depth coding languages."
"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."
"Feature-wise, one of the most valuable ones is the data flows introduced recently in the solution."
"The overall performance is quite good."
"Data Factory's best features are connectivity with different tools and focusing data ingestion using pipeline copy data."
"Easy management (it saves a lot of installation and patching time)."
"I give it a nine out of 10 because it gives the customer easy access to a complete database solution within 30 minutes."
"We primarily use it for OLTP, which has improved our costs."
"Oracle has good technical support."
"The initial setup was straightforward and quick - I was able to configure everything within an hour."
"The solution is pretty automated, which takes out the possibility of human error."
"The most valuable feature of Oracle Database Appliance is the ease of management."
"The Oracle database is able to get the data, process it, and return it to the company's CEO's and CFO's within a single day, and thus they are able to find out yesterday's P and L by today. It has drastically reduced the amount and time of processing from seven days to one day."
"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 are limitations when processing more than one GD file."
"The pricing scheme is very complex and difficult to understand."
"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."
"We are too early into the entire cycle for us to really comment on what problems we face. We're mostly using it for transformations, like ETL tasks. I think we are comfortable with the facts or the facts setting. But for other parts, it is too early to comment on."
"Data Factory could be improved in terms of data transformations by adding more metadata extractions."
"For some of the data, there were some issues with data mapping. Some of the error messages were a little bit foggy. There could be more of a quick start guide or some inline examples. The documentation could be better."
"The solution needs to be more connectable to its own services."
"Oracle's product support is an area of concern where improvements are required."
"The tool's setup can be easier."
"Oracle could improve its capacity for built-in visualization."
"Virtualization features could also be improved. A web-based GUI would be a good start."
"The product is quite complex to set up, initially. It would be ideal if it was simpler."
"I would like it if the scalability could be increased without having to change versions."
"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."
"It would be beneficial to have dedicated RAM included in the Oracle Database Appliance."
Azure Data Factory is ranked 3rd in Cloud Data Warehouse with 81 reviews while Oracle Database Appliance is ranked 6th in Data Warehouse with 39 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 Microsoft Azure Synapse Analytics, 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.