Wednesday, December 26, 2012

(OWB) Install Oracle Warehouse Builder 11.2 on Windows



As you will see the installation of Oracle Warehouse Builder 11.2 (OWB) is very simple.



Here are the installation steps:

 1. Download the Oracle Warehouse Builder 11.2 (11gR2) software from Oracle .

 2. Unzip the downloaded file.


 3. Create the Oracle Home for the OWB installation (In my case the Oracle Home is D:\OracleDataWarehouse ).


 4. From the directory where the Oracle Warehouse Builder 11.2 (11gR2) software was unzipped, run the installer.exe file.

 5. The following screen will appear:


 Click on "Next".


 6. The following screen will appear:

 Install Oracle DWB Warehouse Builder 11.2

 Click on "Next".


 7. The following screen will appear:

Install Oracle DWB Warehouse Builder 11.2

You can unclick "I wish to receive security updates via My Oracle Support".

Click on "Next".

If you receive the following message

 Install Oracle DWB Warehouse Builder 11.2   
  ... you can ignore it, by pressing on "Yes".


 8. The following screen will appear:

 Install Oracle DWB Warehouse Builder 11.2

Click on "Install".


9. The following screen will appear:

Install Oracle DWB Warehouse Builder 11.2


10. The installation of Oracle Warehouse Builder (OWB) release 11.2 is completed when the following screen will be seen:

Install Oracle DWB Warehouse Builder 11.2



Oracle Warehouse Builder's (OWB's) feature set faciliates highly productive development for data warehousing and BI solutions on Oracle, with:

 - Pluggable mappings for reusable ETL logic
 - Extensibility, scripting and automation features
 - Multiple configuration mangement for the dev/test/production life cycle
 - Built-in change management/versioning
 - Oracle Data Integrator knowledge module technology for extensible code generation options
 - Warehouse Builder 11gR2 includes knowledge module technology from Oracle Data Integrator (ODI) for non-Oracle platform support, heterogeneous connectivity and heterogeneous EL-T.

Upgrading to OWB 11gR2 and licensing Oracle Data Integrator Enterprise Edition protects any existing investments in Warehouse Builder designs, while aligning with the long-term data integration roadmap centered on Oracle Data Integrator.

All functionality is pre-installed and ready to use on all Oracle 11g databases. OWB 11gR2 is also supported on Oracle Database 10gR2 with separate installation.

The full data integration and data warehousing capabilities of Warehouse Builder require additional licensing for Oracle Data Integrator Enterprise Edition. Basic ETL continues to be covered by the Oracle Database license.