Inside review on ODW.
September 18, 2019

Inside review on ODW.

Murali Vaturi | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User

Overall Satisfaction with Oracle Data Warehouse

We use Oracle Data Warehouse for integrating all the dist data that gets generated from ERP systems to the warehouse and then use the normalized data for reporting purposes. We use Oracle BI reporting for the whole organisation. We deliver reports for all the verticals in our organisation starting from financials, HR, procurement, ridership and so on. There is also an other ERP that is called Maximo and the transaction data gets processed in Oracle Data Warehouse.

Reporting is one of the major requirements across the org and Oracle Data Warehouse helps us keep the history and dimensionality and scaling.
  • Rending data from all different dimensionalities
  • Sstable, does not hang up
  • Ease of use
  • Transformation of data
  • Built-in analytics
  • Seamless integration with cloud
  • Cumbersome sometimes due to the level of data transformation required to load the data ware house tables
  • 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.