When to use Oracle Warehouse Builder
April 14, 2018
When to use Oracle Warehouse Builder
Score 9 out of 10
Vetted Review
Verified User
Overall Satisfaction with Oracle Warehouse Builder
We're using Oracle Warehouse Builder to offload data from Oracle databases, to transform and to load into operational reporting environment (operational data store) which is an another Oracle Database.
Oracle Warehouse Builder helps us to add meaning into operational raw data and to perform initial transformations for business users' requirements.
Oracle Warehouse Builder helps us to add meaning into operational raw data and to perform initial transformations for business users' requirements.
- Easy transformation.
- Easy implementation from Oracle to Oracle systems.
- Ease of usage and easy to learn.
- Starting component of metadata management.
- User experience.
- Supporting newer technologies.
- Ease of operation.
- Oracle Warehouse Builder is coming out of the box with Oracle Database Release 11G and it is free to use.
- Oracle Warehouse Builder Enterprise Edition can be bought to extend its capabilities.
- Oracle Warehouse Builder is coming to the end of life, so you need to be careful about selecting.
Depending on investment, I would prefer Oracle Data Integrator, since it complies with all versions of all types of databases including Big Data, Hadoop and NoSQL environment as well as the cloud and is the strategic heterogenous data integration product of Oracle, as it is declared in statement of direction.