1. Home
  2. Data Warehouse Software
  3. Oracle Autonomous Data Warehouse Reviews
  4. User Review of Oracle Autonomous Data Warehouse
Must Use Tool for any Datawarehouse Business Intelligence Developer
April 10, 2021

Must Use Tool for any Datawarehouse Business Intelligence Developer

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

Overall Satisfaction with Oracle Data Warehouse

It is used in multiple departments to build in-house analytics tools where we use Oracle as our main database.
The current purpose of using Oracle in our team is just for storing less data but highly index database for frequent data fetch which enable our operation to resolve customer tickets/complaint within SLA. Our current system is small which may we scale in the future (10-20 million records in main and we also create SCD type 1,2 and 3 ETL flow using Oracle).
  • To work in SQL and PL SQL and create high index database. Its user base is very huge so it is used in most of the company which helps in building profile.
  • Easy integration in application development, I have used in python currently.
  • Developers must know the backend as well so that they can build a scalable product.
  • If you learn SQL using Oracle, which cover most of the syntax, then you will be proficient in SQL and can easily work on other tools too (for ex, MySQL and PostgreSQL).
  • In Oracle Data Warehouse I used to build Type 1 and Type 2 Load frequently, where I did not face any issue, so nothing to improve from a product functionality point of view.
  • If UI is more interactive as in Informatica, then maybe more users can start using this
  • Blog link must be there on one site for solving user issues.
  • Positive: Make development faster and small high index is are requirement which we achieve in Oracle Database.
  • Positive: High user community so most of the situations are answered on internet, so no issue while development or integration.
  • Negative: Not freeware, maybe a startup or small company should not use this.
Reason to select Oracle Data Warehouse are mentioned below:
1. If some of your old process are already setup using Oracle Data Warehouse
2. High user community, which make solving doubt using internet very easy
3. Current requirement of small and highly index database is matching with the Oracle product
4. Any Tech Team API integration is very easy in Oracle Data Warehouse
5. No additional KT required to new joiners

Do you think Oracle Autonomous Data Warehouse delivers good value for the price?

Yes

Are you happy with Oracle Autonomous Data Warehouse's feature set?

Yes

Did Oracle Autonomous Data Warehouse live up to sales and marketing promises?

I wasn't involved with the selection/purchase process

Did implementation of Oracle Autonomous Data Warehouse go as expected?

Yes

Would you buy Oracle Autonomous Data Warehouse again?

Yes

Create a whole review system that requires work table, stage table, and History table and OLAP table. In Oracle Data warehouse this is very easy, fast, and with a high user base you can get many solutions implemented by looking online. Building complete end-to-end data pipeline and updating old tables is very easy. Integration with other applications or loading data using an external API is very hassle free task.

We build a small review system where work table loaded using API and then cluster other processing stuff done on the work table and data saved to stage table and final SCD type 1 load to base table. This is ultimately used by the Operations team for solving end-user queries.