Complete Data Warehouse Solution - ODW
November 01, 2017

Complete Data Warehouse Solution - ODW

Anonymous | TrustRadius Reviewer
Score 7 out of 10
Vetted Review
Verified User
Review Source

Overall Satisfaction with Oracle Data Warehouse

Oracle Data Warehouse were used for one of our clients to act as an analytics database that stores transactional data like Financial Transaction relation information, Customer Centric Information, Sales and Purchase related Information, Projects and Service related information. The information stored in the Oracle Data Warehouse would help the key business users to pull reports through data cubes which would help them in analyzing different aspects of business. So based on the data points received and the key indicators set, it would enable the business to make informed decisions to grow their business. One example would be to identify customers sales which could be seasonal in nature, so by understanding the patterns of their previous placed order the business can vouch for the customer next time when similar conducive scenario is in place.
  • Oracle Data Warehouse is scalable and reliable.
  • Seamless integration with oracle database's using synchronous and asynchronous connectivity thus giving real time data representation to the key business users.
  • Good performance and high availability of data from the Data Warehouse for analytical reporting.
  • Like any data warehouse, one needs to conduct a cost benefit analysis to see whether the IT efforts required for implementation of the data warehouse and the cost involved in maintaining the data would be adding monetary values to the organization.
  • Data Ownership could be one concern where the management needs to decide who would be having what access to the Data Warehouse. So proper configuration of the access would be required, so that there is no breach in data ownership.
  • It helped our clients to have reliable and quick data points and key indicators at their finger tips, which helped them in informed decision making.
  • The Extract, Transform and Load i.e. the ETL concept is quite seamless to implement.
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.
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.