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.8 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-8 of 8)

Companies can't remove reviews or game the system. Here's why.
Anonymous | TrustRadius Reviewer
October 02, 2019

Not the most affordable data warehousing solution

Score 6 out of 10
Vetted Review
Verified User
Review Source

Alternatives Considered

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.
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

Alternatives Considered

Hadoop still being a naive field, we have very few expertise with great knowledge in Hadoop. Oracle Data Warehouse does not support unstructured data, where as Hadoop does. There are a lot of functionalities which Oracle Data Warehouse provides, which makes us us not to go for Hadoop and many other tools, unless it is highly necessary. Hadoop is way difficult to learn compared to Oracle's easy User Interface.
Read Kartik Chavan'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

Alternatives Considered

Oracle Data Warehouse became immediate selection whenever we were implementing BI solutions with Dimension Modeling and Oracle based Transactional Systems, compared to other places where we used Teradata and Netezza with 3NF model structure for BI solutions. For other various businesses, where we were required to solve data/business problems with structures/unstructured data we preferred Cloudera.
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

Alternatives Considered

Oracle is a lot cheaper than traditional data warehouse appliance solutions, even if you get an expensive DBA who knows what he/she is doing. It definitely takes a lot more work to ensure it scales as your data size grows. While it won't scale past the terabyte sized data sets, the organization was nowhere near that point in terms of data velocity. It also was extremely flexible unlike most other data warehousing products since it is more OLTP in nature. This allows you to use languages like PL/SQL to do complex transformation that might not be possible in SQL. This allowed us to implement much more sophisticated solutions. Overall, it is a good product that provides a good blend of OLAP and OLTP features and performance.
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

Alternatives Considered

Our organization adopted Oracle almost 20 years ago and there were a few options at that time. Oracle was the leading database tech company at that time and it was a safe choice to us. And they have been evolved and always ahead of new technologies, high performance, and professional business support. We didn't find a good reason to replace Oracle with any other competitors.
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

Alternatives Considered

Oracle DWH is a pure warehousing tool and does not try to include outside features into itself, unlike a few other warehousing platforms. This makes Oracle DWH much simpler to set up and ready to use.
On the other hand, most other warehousing platforms can provide slightly below par performance and support for a significantly lower licensing cost.
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

Alternatives Considered

Oracle data warehouse has the capability of running both the Online Transaction Processing (OLTP) and Online Analytical Processing (OLAP) databases on the same platform. This capabilities cannot be handled by other datawarehouse like TeraData. This capability helps Oracle to provide better performance in medium to heavy work load scenarios. We normally will not have just Online Analytics Process Workloads in data warehouses hence it was the best fit for the organization.
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