Not the most affordable data warehousing solution
October 02, 2019
Not the most affordable data warehousing solution
Score 6 out of 10
Vetted Review
Verified User
Overall Satisfaction with Oracle Data Warehouse
Oracle Data Warehouse is being used across our entire organization. Although each department in our organization has its own individual use cases for maintaining a data warehouse, the overall problems that are being solved are the same. We are using Oracle Data Warehouse for business intelligence related queries, finding trends in periods of time using all the historical data, and for deep data exploration.
- Quick and easy deployment. There is no hassle in setting up software and maintaining hardware.
- Highly available and scalable. Accessing the data warehouse is easy, and it can scale up based on the data size requirements.
- Autonomous functionality. With the help of machine learning, autonomous data warehousing reduces the amount of time spent managing it.
- Customer support isn't the best out there. We usually have to wait about an hour to get some form of assistance.
- Pricing is a bit higher than many of its competitors such as AWS Redshift.
- Tweaking features requires dedicated staff. Software is fairly advanced. Would be difficult to use for newcomers.
- We had to hire dedicated staff to manage the data warehouse. Negatively impacted ROI.
- Initial price dented the company budget. It took twice as much time to make it all back.
- It is not a cloud solution, so purchasing hardware to support Oracle Data Warehouse was expensive as well.
In my personal opinion, Amazon Redshift is much better than Oracle Data Warehouse in two main ways. First, it's in the Cloud which eliminates the need to purchase and maintain dedicated hardware. Second, the pricing models for Redshift are far more flexible and affordable. However, Redshift lacks the autonomous functionality that Oracle Data Warehouse provides.