FAQ Oracle Warehouse Builder FAQ

10g Release

General
What versions of Oracle database can I use with Warehouse Builder 10g?

Can I use Warehouse Builder 9.2 with Oracle 10g database?

What platforms will Warehouse Builder 10g be available on?

Where can I download Warehouse Builder 10g?

 

New Features

What new features are introduced in Warehouse Builder 10g?

Does Warehouse Builder 10g leverage any new Oracle 10g database features?

When is the next feature bearing version of Warehouse Builder going to be released?
 
Installation
How should I install Warehouse Builder 10g?

What CD pack is Warehouse Builder 10g located in?

 
Migration

Why should I upgrade to Warehouse Builder 10g ?

I already have an existing data warehouse built with Warehouse Builder. How do I migrate to Warehouse Builder 10g?

 
Licensing

What does it cost to upgrade to Warehouse Builder 10g?

What license do I need to use Warehouse Builder 10g?

 
What versions of Oracle database can I use with Warehouse Builder 10g?
For the target database, users can use Oracle 8.1.7, 9.2 and 10g with Warehouse Builder 10g.  As a source, Warehouse Builder 10g supports:
  • 7.3.4 or higher if your target is a 8.1.7 database
  • 8.0 or higher if your target is a 9.2 database
  • 8.1.7.4 or higher if your target is a 10g database
Top of Page
 
Can I use Warehouse Builder 9.2 with Oracle 10g database?
You can only use Oracle 10g database with Warehouse Builder 9.2 to store the design or run-time repositories. Because OWB 9.2 does not have a 10g location, you can not use an Oracle 10g source or target. If you are sourcing from or targeting Oracle 10g database you must use OWB 10g.
Top of Page
 
What platforms will Warehouse Builder 10g be available on?
Warehouse Builder 10g will be available on all platforms that Oracle Database 10g is available on, with the the exceptions of HP OpenVMS and IBM zOS (OS/390).  Specifically, Warehouse Builder 10g will be available on the following platforms:
  • Windows (32 bit and 64 bit)
  • Sun Solaris (64 bit)
  • Sun Solaris (x86)
  • HP-UX
  • HP-Tru64
  • HP-UX (Itanium64)
  • Linux (x86)
  • Linux (Itanium64)
  • AIX 5L
  • z/Linux

Starting with Warehouse Builder 10g Release 1, Warehouse Builder will not be available on Sun Solaris (SPARC) 32-bit operating system, and will only support a database running on the Sun Solaris (SPARC) 32-bit operating system as a remote source. Customers that wish to continue to use a database running on this operating system in conjuction with any other Warehouse Builder functionality, must remain on Warehouse Builder 9.2 (or earlier).

Top of Page
 
Where can I download Warehouse Builder 10g?
Warehouse Builder 10g is available for download from Oracle Technology Network
http://otn.oracle.com/software/products/warehouse/index.html
Top of Page
 
What new features are introduced in Warehouse Builder 10g?

The primary function of Warehouse Builder 10g is to support the Oracle Database 10g .  Other changes in this release are:

  • Simplified installation - there are no longer Design-Time and Server-Side installation options.
  • Warehouse Builder now provides a script that configures the Warehouse Builder Runtime Service for remote execution of Warehouse Builder's mappings on Oracle Enterprise Manager nodes.

More details on these changes are in Release Notes http://otn.oracle.com/documentation/warehouse.html

Significant number of new features will be offered in the next release of Warehouse Builder which is currently scheduled to be available in November 2004.

Top of Page
 
Does Warehouse Builder 10g leverage any new Oracle 10g database features?
While Warehouse Builder 10g supports Oracle Database 10g as a target database, it only implicitly leverages the new database features. The next release of Warehouse Builder will explicitly leverage many new Oracle Database 10g features.
Top of Page
 
When is the next feature bearing version of Warehouse Builder going to be released?
Warehouse Builder will offer significant number of new features in the next release of Warehouse Builder which is currently scheduled to be available in November 2004.
Top of Page
 
How should I install Warehouse Builder 10g?
Warehouse Builder 10g should be installed in its own Oracle home. For detailed installation instructions, please see Warehouse Builder Install and Configuration Guide http://otn.oracle.com/documentation/warehouse.html.
Top of Page
 
What CD pack is Warehouse Builder 10g located in?
Warehouse Builder 10g is a stand alone CD in the Oracle Developer Suite 10g (9.0.4) CD pack.  This CD pack can be ordered through the OracleStore http://www.oracle.com/products/buy/
Top of Page
 
Why should I upgrade to Warehouse Builder 10g?

Warehouse Builder users will want to upgrade to Warehouse Builder 10g for the following reasons:

  • To be able to use the Oracle 10g database as a source or target
  • Warehouse Builder 10g is available on more platforms than any previous version. For details see this question "What platforms will Warehouse Builder 10g be available on?"
  • For a brand new install, it is easier to get the most stable environment by installing Warehouse Builder 10g rather than installing OWB 9.2.0.2.8 followed by 9.2.0.4.0 patchset  
  • Warehouse Builder patch 9.2.0.4 will be the last patch for Warehouse Builder 9.2, so users are encouraged to migrate to Warehouse Builder 10g to receive the future product updates
Top of Page
 
I already have an existing data warehouse built with Warehouse Builder. How do I migrate to Warehouse Builder 10g?
For Warehouse Builder 3i, 9.0.2 and 9.0.3 users, you will need to upgrade your design and runtime environments. For Warehouse Builder 9.0.4 and 9.2 users, you can perform an in-place migration using a script to upgrade both your design time and runtime repositories. See the Warehouse Builder Install and Configuration Guide  http://otn.oracle.com/documentation/warehouse.html, Chapter 3: "Upgrading to 10g Release 1 (10.1) and Migrating Data", for details. Note that additional steps are required if you perform a database upgrade as well as a Warehouse Builder upgrade.
Top of Page
 
What does it cost to upgrade to Warehouse Builder 10g?
Warehouse Builder users who have maintained their Oracle Developer Suite software update license are eligible to upgrade to Warehouse Builder 10g without any additional charges. Other users need to purchase an Oracle Developer Suite license. For questions about licensing, please contact your Account Manager.
Top of Page
 
What license do I need to use Warehouse Builder 10g?
Users need an Oracle Developer Suite license and an Oracle database Enterprise Edition license to run Warehouse Builder 10g.
Top of Page