We performed a comparison between Azure Data Factory and Oracle Autonomous Data 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."We have found the bulk load feature very valuable."
"The user interface is very good. It makes me feel very comfortable when I am using the tool."
"I can do everything I want with SSIS and Azure Data Factory."
"The data copy template is a valuable feature."
"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."
"Powerful but easy-to-use and intuitive."
"For me, it was that there are dedicated connectors for different targets or sources, different data sources. For example, there is direct connector to Salesforce, Oracle Service Cloud, etcetera, and that was really helpful."
"I like how you can create your own pipeline in your space and reuse those creations. You can collaborate with other people who want to use your code."
"Self-patching and runs machine-learning across its logs all the time"
"The solution integrates well with Power BI."
"The analytics have been very good. We've found them to be quite useful."
"Oracle Autonomous Data Warehouse is used globally to deliver extreme performance on large Financial data sets."
"One advantage is that if you already have an Oracle Database, it easily integrates with that."
"I loved the simplicity of loading the data and simply relying on the self-tuning capabilities of ADW."
"The performance and scalability are awesome."
"With Oracle Autonomous Data Warehouse, things are much simpler. Creating a structure, initializing the servers, extending the servers, those are all things that are very, very easy. That's the main reason we use it."
"User-friendliness and user effectiveness are unquestionably important, and it may be a good option here to improve the user experience. However, I believe that more and more sophisticated monitoring would be beneficial."
"I would like to see this time travel feature in Snowflake added to Azure Data Factory."
"There's no Oracle connector if you want to do transformation using data flow activity, so Azure Data Factory needs more connectors for data flow transformation."
"Some of the optimization techniques are not scalable."
"The solution should offer better integration with Azure machine learning. We should be able to embed the cognitive services from Microsoft, for example as a web API. It should allow us to embed Azure machine learning in a more user-friendly way."
"The thing we missed most was data update, but this is now available as of two weeks ago."
"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."
"Lacks in-built streaming data processing."
"It is very important the integration with other platforms be made to be as easy as it is with an on-premises deployment."
"There is a need for more storage to be allocated, but over a period of time, it becomes impossible to reduce it after using it."
"I would like to see Application Express and Oracle R Enterprise fully supported, and I would like to see Oracle Data Mining supported as a front end."
"My main suggestion for Oracle is the configuration and key values that come for JSON files. When we create a table, especially if you see in our RedShift or some other stuff, if I create a table on top of a JSON file with multiple array columns or superset columns, those column values create some difficulty in Oracle."
"An improvement for us would be the inclusion of support for an internal IP, so we could use it directly with the VCN in Oracle Cloud."
"I would like to see an on-premise solution in the future."
"It doesn't work well when you have unstructured data or you need online analytics. It is not as nice as Hadoop in these aspects."
"A lot of the tools that were previously there have now been taken away."
More Oracle Autonomous Data Warehouse Pricing and Cost Advice →
Azure Data Factory is ranked 3rd in Cloud Data Warehouse with 81 reviews while Oracle Autonomous Data Warehouse is ranked 10th in Cloud Data Warehouse with 16 reviews. Azure Data Factory is rated 8.0, while Oracle Autonomous Data Warehouse is rated 8.6. 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 Autonomous Data Warehouse writes "A tool for data warehousing that offers scalability, stability, and ease of setup". Azure Data Factory is most compared with Informatica PowerCenter, Informatica Cloud Data Integration, Alteryx Designer, Snowflake and IBM InfoSphere DataStage, whereas Oracle Autonomous Data Warehouse is most compared with Oracle Exadata, Snowflake, Microsoft Azure Synapse Analytics, BigQuery and Vertica. See our Azure Data Factory vs. Oracle Autonomous Data 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.