Oracle Autonomous Data Warehouse Competitors and Alternatives

Get our free report covering Snowflake Computing, Microsoft, Amazon, and other competitors of Oracle Autonomous Data Warehouse. Updated: February 2020.
399,230 professionals have used our research since 2012.

Read reviews of Oracle Autonomous Data Warehouse competitors and alternatives

Consultant
SAP BusinessObjects Consultant at a tech company with 10,001+ employees
Feb 22 2020

What is most valuable?

BW is our bread and butter. We use it every day for reporting, for analysis, data consolidation and aggregation, drag and drop queries, etc.

What needs improvement?

There are a lot of things that could be improved especially in terms of data cleansing, data management, data lineage, etc. The solution needs to offer more flexibility in terms of formulas and the query designer. The solution has very limited options, so we have to mix and match some functionality… more»

Which solution did I use previously and why did I switch?

I cannot recall if we previously used another solution or what it was. Before SAP, the company was using a third-party tool on Oracle or some other SQL database. We have been running SAP for the last 10 years, and I joined the company in the past six years. I wasn't here when SAP was originally… more»

What other advice do I have?

Our solution is strictly on-premises due to our company policy to not place anything on the cloud. Consultants with technical experience are helpful. They need to understand the processes, as well, however, because designing is the key. Designing right from the start is the very important if you… more»
DivyaRaj
Real User
Sr. Software Developer at Tech Mahindra Limited
Jan 13 2020

What is most valuable?

Snowflake is the latest technology. It has great flexibility whenever we are loading data and performs ELT (extract, load, transform) techniques instead of ETL. This solution automatically performs micro-partitioning when the data is… more»

What needs improvement?

It is difficult in some cases to perform ETL and this is something that should be included. As it is now, I use Informatica PowerCenter to load data from on-premises to the Snowflake cloud-based data warehouse. If this could be done by… more»

What's my experience with pricing, setup cost, and licensing?

You pay based on the data that you are storing in the data warehouse and there are no maintenance costs.

Which solution did I use previously and why did I switch?

I have experience with Informatica PowerCenter and Oracle. PowerCenter uses ETL techniques instead of ELT. Oracle does not automatically perform micro-partitioning. Instead, you have to partition manually and it is a static partition. Prior… more»

What other advice do I have?

This is an awesome tool, but there is room for improvement in terms of integration. Also, in terms of management, nothing is perfect and everything can be improved. I would rate this solution an eight out of ten.
Real User
Project Manager at a tech services company with 5,001-10,000 employees
Dec 19 2019

What is most valuable?

The most valuable feature of the solution is the analytics and that it can connect with Power BI. I found it quite interesting and very compelling in terms of detail within a single stack.

What needs improvement?

I would like my team to be able to build pipelines that integrate with the Azure Data Factory. Some of the best-in-class ETL products that are available in the market, such as Informatica ETL, are far more mature than this solution.

Which solution did I use previously and why did I switch?

In addition to Azure SQL Data Warehouse, we work with the version that is on-premises. We are also working with Oracle Data Warehouse and we plan to continue using both of these solutions.

What other advice do I have?

If you are using Microsoft products, such as Office 365, then this solution is good because it can take the data from multiple sources. This is a good product, but when you compare to Oracle Data Warehouse there are differences in scalability, high availability, and implementation. I would rate this… more»
Get our free report covering Snowflake Computing, Microsoft, Amazon, and other competitors of Oracle Autonomous Data Warehouse. Updated: February 2020.
399,230 professionals have used our research since 2012.