Oracle Data Warehouse Reviews

210 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 7.7 out of 100

Do you work for this company? Learn how we help vendors

Overall Rating

Reviewer's Company Size

Last Updated

By Topic

Industry

Department

Experience

Job Type

Role

Filtered By:

Reviews (1-10 of 10)

Companies can't remove reviews or game the system. Here's why.
Murali Vaturi | TrustRadius Reviewer
September 18, 2019

Inside review on ODW.

Score 9 out of 10
Vetted Review
Verified User
Review Source

Likelihood to Recommend

  • To integrate multiple sources into one warehouse.
  • Rendering data
  • Ease of debug
  • When competing with BDD or any other big data tools where there is not need of a data warehouse.
Read Murali Vaturi's full review
Anonymous | TrustRadius Reviewer
October 02, 2019

Not the most affordable data warehousing solution

Score 6 out of 10
Vetted Review
Verified User
Review Source

Likelihood to Recommend

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.
Read this authenticated review
Anonymous | TrustRadius Reviewer
January 04, 2019

Oracle Data Warehouse is the 800 Pound Gorilla

Score 7 out of 10
Vetted Review
Verified User
Review Source

Likelihood to Recommend

Oracle Data Warehouse is, in my opinion, the best solution available. My hesitance to recommend it would be that it costs a fortune and other vendors would likely work well for smaller companies. For large companies that can afford the pricetag, you likely won't find anything to out-perform Oracle. I've seen POCs where the competition outshines Oracle, but I believe they are specific situations, and in general, I would give Oracle my recommendation (again, if money is not an object).
Read this authenticated review
Kartik Chavan | TrustRadius Reviewer
August 02, 2018

My Oracle DW Review

Score 7 out of 10
Vetted Review
Verified User
Review Source

Likelihood to Recommend

For any business sectors dealing with large databases, and working on Analytics to improvise their business services, solutions or products, Oracle Data Warehouse can be a great option. The only scenario where I wouldn't recommend Oracle Data Warehouse is businesses with small databases, as it might not be very cost effective. It does provide all great functionalities including Storage services, BI Analytics, Security & more.
Read Kartik Chavan's full review
Suresh Muddaveerappa | TrustRadius Reviewer
July 20, 2016

Build Your Data Warehouse Using Oracle

Score 9 out of 10
Vetted Review
Verified User
Review Source

Likelihood to Recommend

Oracle Data Warehouse is well suited for VLDBs (very large databases) and has core functionality to provide scalability and performance with data growth and as well user query load. It does provide the necessary features and functionalities for BI analytics, data consolidation, fraud analysis and detection. With Engineered Systems one can bring in database consolidation, shared flash storage, InfiniBand connectivity and much more into play. With the newer version, the multi-tenant architecture option is available. With multi-tenant, the user is now able to manage many databases as one with the use of Container and Pluggable databases.
Read Suresh Muddaveerappa's full review
Hemant Prabhakar Patil | TrustRadius Reviewer
July 26, 2016

Oracle based BI Solution with Oracle Data Warehouse

Score 9 out of 10
Vetted Review
Verified User
Review Source

Likelihood to Recommend

It's more preferred where ERP, CRM systems are built with Oracle and then it's always highly recommendable to use Oracle data warehouse and all Oracle solutions. It also does well with other source data systems from SAP, Peoplesoft, JD Edwards. For BI/Data warehouse solutions with Structured and Unstructured Data (Big Data Solutions) it's preferable to use Hadoop systems and other visually appealing tools.
Read Hemant Prabhakar Patil's full review
Seth Goldberg | TrustRadius Reviewer
July 22, 2016

Data Warehousing with a hint of OLTP

Score 7 out of 10
Vetted Review
Verified User
Review Source

Likelihood to Recommend

Scenarios where appropriate:
  • Heavy investment in other Oracle databases
  • Availability of knowledgable Oracle staff
  • Plenty of money for the database and all the add ons
  • Need for well supported platform
  • Data sets that are not ridiculously big. Once you start hitting table sizes in the hundreds of gigs, it starts getting very hard to scale
Scenarios where not appropriate:
  • Limited budget
  • Desire to use open source software
  • HUGE datasets. Until the architecture can operate in a shared nothing fashion, it will only scale to the size of the biggest box you can get. Even that may not be enough...
  • Lots of semi/unstructured data
  • Staff has limited knowledge on tuning it
Read Seth Goldberg's full review
Anonymous | TrustRadius Reviewer
August 07, 2018

Oracle Data Warehouse is a safe but good choice for in-house clinical data warehouse

Score 8 out of 10
Vetted Review
Verified User
Review Source

Likelihood to Recommend

Including other products, Oracle is very specialized in business support. Choosing Oracle Data Warehouse would be a safe choice for an enterprise-level company (more than a thousand employees). Healthcare organizations may want to consider Oracle, as they are typically conservative with privacy and security issues with patient data. Although cloud-based systems are widely being adopted in the healthcare industry (such as population research or genomics), core data sets (such as patients' sensitive medical records) may be better stored with a home-grown data center and warehouse solution.
Read this authenticated review
Anonymous | TrustRadius Reviewer
December 12, 2017

Great performance for large databases

Score 9 out of 10
Vetted Review
Verified User
Review Source

Likelihood to Recommend

For large businesses that handle very large databases, Oracle proved great performance and is probably the best warehousing option available.
For small and medium business, Oracle Data Warehouse might not be the best choice to use as a warehousing platform.
Read this authenticated review
Anonymous | TrustRadius Reviewer
November 01, 2017

Complete Data Warehouse Solution - ODW

Score 7 out of 10
Vetted Review
Verified User
Review Source

Likelihood to Recommend

Oracle Data Warehouse will be well suited for organizations which can take the maximum advantage of the capabilities that the Data Warehouse provides. It has strong analytic reporting capabilities which need to be diligently used so that the management or the key business users are able to make the maximum use of it. Maintaining the data in Oracle Data Warehouse and implementation of the DW project would require good IT manpower and costs. So enough due diligence needs to be done before implementing Oracle Data Warehouse.
Read this authenticated review

Oracle Data Warehouse Scorecard Summary

About Oracle Data Warehouse

Oracle Autonomous Data Warehouse is a cloud data warehouse service that eliminates virtually all the complexities of operating a data warehouse, securing data, and developing data-driven applications. It automates provisioning, configuring, securing, tuning, scaling, patching, backing up, and repairing of the data warehouse.
Categories:  Data Warehouse

Oracle Data Warehouse Competitors

Amazon Redshift, Microsoft SQL Server, SAP Business Warehouse (SAP BW), formerly SAP NetWeaver Business Warehouse

Oracle Data Warehouse Technical Details

Operating Systems: Unspecified
Mobile Application:No