Not the most affordable data warehousing solution
Anonymous | TrustRadius Reviewer
October 02, 2019

Not the most affordable data warehousing solution

Score 6 out of 10
Vetted Review
Verified User
Review Source

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.
Oracle Data Warehouse is well-suited for businesses medium-sized and up. Keep in mind to manage and utilize Oracle Data Warehouse's full potential, you will need to hire dedicated staff that is experienced in using it. Not to mention, the pricing is a bit high. It is less appropriate for smaller businesses that have smaller budgets and fewer employees.