FAQ - Oracle Warehouse Builder 10g Release 2

New Features
· What is new in Warehouse Builder 10g Release 2?
· What are the key feature areas in Warehouse Builder 10g Release 2?
· What features are part of the ETL Core Features?
· Where can I get a complete list of Core ETL features?
· What features are part of the Enterprise ETL Option?
· What features are part of the Data Quality Option?
· What features are part of the Connectors?
· Is metadata generation and deployment to OracleBI Discoverer 10g supported?
· Is metadata generation and deployment to OracleBI Beans 10g supported?
· Is metadata generation and deployment to OracleBI Answers supported?
· Is the eBusiness Suite connector required to deploy and schedule using Concurrent Manager?
· Is there a Connector for Siebel CRM?
· Are the OWB “Experts” part of the Core ETL functionality that's free with the database
· What Experts are available out of the box?
· Is Data Quality Option inclusive of Enterprise ETL option?
· Is name and address cleansing a Data Quality Option?
· Do we still need to get the Name & Address database from third-party partners, or is it included?

Packaging
· How is Warehouse Builder 10g Release 2 Packaged?
· Which is the version of the database that it is packaged with?
· Is Warehouse Builder 10g Release 2 still packaged as part of Developer Suite?

Licensing
· Is Warehouse Builder 10g Release 2 now licensed as part of the database?
· What are the key licensing options for Warehouse Builder 10g Release 2?
· How is Warehouse Builder 10g Release 2 priced?
· What does the new licensing model mean for existing Warehouse Builder Customers?
· What does the new licensing model mean for existing database Customers?
· For “Named User” licensing, what is the minimum number of named users a customer must purchase?
· Can a customer license Warehouse Builder and database differently?
· Can customers license a subset of CPUs on machine?
· Will elements of OWB be disabled if the add-on options haven't been licensed?
· Why are only the production systems licensed? Is it Production only?
· What licenses do customers get if they purchase Business Intelligence Suite Standard Edition?

Installation
· How do I download and install Warehouse Builder Client versus Warehouse Builder Server?
· Which Oracle database versions can I use with Warehouse Builder 10g Release 2?
· Which platforms does Warehouse Builder 10g Release 2 support?
· Which database version do I need for my Warehouse Builder Design Repository ?
· Are languages other than English supported?
· What are the known issues and bugs with Warehouse Builder 10g Release 2?
· Can I run the Design Center UI on non-Windows platforms?
· Does “packaged with the database” mean Warehouse Builder now gets installed with the database?
· Can I switch off and/or un-install the optional functionality?
· If I install the Windows DB Client tools (e.g. Windows OEM) will this install OWB, or is it a separate install?
· Will it show up in my Start menu under “Integrated Management Tools“ or where?
· Does Warehouse Builder install in the DB home or a separate home?
· Can Warehouse Builder 10g Release 1 and 10g Release 2 coexist?
· Can I use Warehouse Builder 10g Release 2 with Oracle 7?

Migration
· Can I upgrade to Warehouse Builder 10g Release 2 from a beta version?
· Can I upgrade to Warehouse Builder 10g Release 2 from an earlier release of Warehouse Builder?
· Is there any collateral to show me how to migrate to Warehouse Builder 10g Release 2 from an earlier release of Warehouse Builder?
· Is it possible to import OLAP dimensions and cubes built using Analytic Workspace Manager?
· Is the OLAP support consistent with the AWM interface. i.e. if I create a mapping in OWB, can I see / edit it in AWM?
· Is it possible to connect to an existing Designer repository?

Training
· Are there any training courses available for Warehouse Builder 10g Release 2?
· Is there a demo schema for Warehouse Builder 10g Release2?
· Is there any collateral to show me how to migrate to Warehouse Builder 10g Release 2 from an earlier release of Warehouse Builder?

What is Warehouse Builder 10g Release 2?

Oracle Warehouse Builder 10g Release 2 is Oracle’s industry leading enterprise business intelligence integration design tool. Warehouse Builder 10g Release 2 is the only tool that manages the full life-cycle of data and metadata for the Oracle 10g Database. It provides an easy to use, graphical environment to rapidly design, deploy, and manage business intelligence systems.

Back to top

Has Warehouse Builder been renamed?

Yes. Warehouse Builder was formally called Oracle Business Intelligence Warehouse Builder. It is now known as Oracle Warehouse Builder.

Back to top

What was Warehouse Builder “Paris”?

Paris was the internal code name for Warehouse Builder 10g Release 2. The code name was used on many presentations given at conferences such as Oracle Open World, Oracle Developer Tools User Group, Rocky Mountain User Group and various well know blog sites. Now Paris has shipped it will be known as Warehouse Builder 10g Release 2.

Back to top

What is new in Warehouse Builder 10g Release 2?

The 10g Release 2 release of Warehouse Builder contains many new features and significant enhancements to existing features. The following list provides a high-level overview of the new features and enhancements:

• Data Profiling
• New Data Sources and Targets
• Enhanced ERP Integration
• Transportable Modules
• Scheduled Process Execution
• User-defined Objects & Icons
• Relational and Dimensional Data Object Designer
• Business Intelligence Object Derivation

• Experts

For more detailed information about these new features please refer to the Preface chapter of the User Guide - “New in 10g Release 2”

Back to top

What are the key feature areas in Warehouse Builder 10g Release 2?

There are four key feature areas within Warehouse Builder as follows:

Back to top

What features are part of the ETL Core Features?

The aim of the ETL Core features is to provide core bulk ETL functionality as part of the database license. Common and repetitive tasks can be fully automated using public APIs and scripting macros extensions. These features will allow Oracle database customers to quickly and easily load data into an Oracle database. It contains all the existing 10g Release 1 functionality as well as “Experts”.

Back to top

Where can I get a complete list of Core ETL features?

The documentation relating to Warehouse Builder 10g Release 1 provides a comprehensive list of features in the Core ETL part of Warehouse Builder 10g Release 2. However, the 10g Release 2 pricing document provides details of features within each priced option (Enterprise ETL, Data Quality, Connectors), therefore, features not mentioned in this document as relating to those options are part of the Core ETL functionality.

Back to top

What features are part of the Enterprise ETL Option?

The aim of the Enterprise ETL Option is to support large scale and complex deployments by improving the scalability and performance of ETL jobs. Support is also provided to effectively manage multi-environment deployments that are typical of enterprise data warehouse projects. This option contains the following functionality:

• Improves the performance and scalability of ETL jobs
• Transportable Tablespaces
• Data Pump
• Supports large global Enterprise-wide deployments
• Interactive Lineage & Impact Analysis
• User-defined Objects

Note:

1) This option can only be purchased with the Enterprise Edition of the database

2) The features listed here are an overview and not legally binding. For more detailed information on the exact list of features provided by each part of the new licensing model please refer to the Database Licensing Information 10g Release 2 (10.2) B14199-04. A pdf version of this document is also available here. A pdf version of this document is also available here

Back to top

What features are part of the Data Quality Option?

2) The features listed here are an overview and not legally binding. For more detailed information on the exact list of features provided by each part of the new licensing model please refer to the Database Licensing Information 10g Release 2 (10.2) B14199-04. A pdf version of this document is also available here. A pdf version of this document is also available here

Back to top

Connectors allow customers to quickly and easily extract (and in some cases target) data to/from their CRM and ERP applications. This option contains the connectors to following environments:

• Oracle EBusiness Suite
• Peoplesoft 8/9
• SAP

For example if a customer has three EBusiness Suite sources and the target is a single Oracle database, only one connector would need to be purchased. If there are two target Oracle databases, two connectors would need to be purchased

Note:

1) This option can only be purchased with the Enterprise Edition of the database

2) The features listed here are an overview and not legally binding. For more detailed information on the exact list of features provided by each part of the new licensing model please refer to the Database Licensing Information 10g Release 2 (10.2) B14199-04. A pdf version of this document is also available here. A pdf version of this document is also available here

Back to top

Yes, deployment of metadata to OracleBI Discoverer 10g is supported.

Back to top

Is metadata generation and deployment to OracleBI Beans 10g supported?

Yes, deployment of metadata and presentations to OracleBI Beans is supported.

Back to top

Is metadata generation and deployment to OracleBI Answers supported?

No. Currently only OracleBI Discoverer and OracleBI Beans are supported.

Back to top

Is the eBusiness Suite Connector required to deploy/schedule using Concurrent Manager?

Yes. If you wish to use Concurrent Manager for deployment and scheduling, the eBusiness Suite Connector is required. The Connector requires customers to be using Enterprise Edition of the database.

Back to top

Is there a Connector for Siebel CRM?

No, not in this release.

Back to top

Are the OWB 'Experts' part of the Core ETL functionality that's free with the database?

Yes.

Back to top

What Experts are available out of the box?

There are no instances of Experts shipped out-of-the-box. Experts will be available using the exchange on OTN. For more information visit the Exchange website at:

http://www.oracle.com/technology/products/warehouse/htdocs/OWBexchange.html

All utilities posted on the Exchange are not part of any Warehouse Builder production release and are, therefore, not supported.

Back to top

Is Data Quality Option inclusive of Enterprise ETL option?

No. Each option is priced and bundled separately.

Back to top

Is Name and Address Cleansing part of the Data Quality Option?

No. Name and Address and Match/Merge are both part of the core ETL features that are provided free with Standard Edition, Standard Edition One and Enterprise Edition.

Back to top

Do we still need to get the Name & Address libraries from third party partners, or are they included?

The Name and Address transformation is provided free within the Core ETL features. However, the transformation engine requires a ‘Name and Address’ library to correct names and addresses. These libraries are provided by partners such as Trillium, First Logic, Melissa Data and/or DataFlux. For more information please refer to the Warehouse Builder Partner page on OTN.

http://www.oracle.com/technology/products/warehouse/htdocs/otn_partners.html

Back to top

How is Warehouse Builder 10g Release 2 Packaged?

As of May 2006 Warehouse Builder is now packaged as a separate media pack and is configured to ship with the database.

Back to top

Which is the version of the database that it is packaged with?

Warehouse Builder 10g Release 2 is packaged with 10g Release 2 of Standard Edition, Standard Edition One and Enterprise Edition.

Back to top

Is Warehouse Builder 10g Release 2 still packaged as part of Developer Suite?

No.

Back to top

Is Warehouse Builder 10g Release 2 now licensed as part of the database?

Yes, as of May 2006 Warehouse Builder is now shipped as part of the database and is no longer part of Developer Suite. The licensing and pricing have changed. See below for more details.

Back to top

What are the key licensing options for Warehouse Builder 10g Release 2?

Warehouse Builder is now comprised of four components as follows:

The core ETL features are now provided free with the database Standard Edition, Standard Edition One, and Enterprise Edition. The core features that are provided free are those provided by the current 10g Release 1 version of Warehouse Builder with the addition of “Experts”.

Back to top

How is Warehouse Builder 10g Release 2 priced?

The core ETL features are provided free with the database Standard Edition, Standard Edition One and Enterprise Edition. The core features that are provided free represent the functionality provided by the current 10g Release 1 version of Warehouse Builder.

The additional options for Warehouse Builder 10g Release 2 are only supported on the Enterprise Edition of the database as follows:

• The Enterprise ETL Option is priced option per CPU
• The Data Quality Option is priced option per CPU
• The Connectors Option is priced option per Connector per Target

Note:

1) This option can only be purchased with the Enterprise Edition of the database

2) The features listed here are an overview and not legally binding. For more detailed information on the exact list of features provided by each part of the new licensing model please refer to the Database Licensing Information 10g Release 2 (10.2) B14199-04. A pdf version of this document is also available here. A pdf version of this document is also available here

Back to top

What does the new licensing model mean for existing Warehouse Builder Customers?

As of May 2006, new Database customers are licensed for the Core ETL Features, i.e. the Warehouse Builder 10g Release 1 functionality inside Warehouse Builder 10g Release 2. All other features are available as priced options. All existing Developer Suite customers retain Warehouse Builder 10g Release 1 functionality + SAP connector (so they can use Warehouse Builder 10g Release 2 Core ETL Features and SAP connector)

Back to top

What does the new licensing model mean for existing database Customers?

As of May 2006, existing database customers are automatically licensed for the free Core ETL Features. All other features are available as priced options with Enterprise Edition. Some priced options require 10g database version such as Data Quality. For a list of supported database versions for Warehouse Builder 10g Release 2 please refer to the Certify page on Metalink.

http://metalink.oracle.com

Back to top

For “Named User” licensing, what is the minimum number of named users a customer must purchase?

Warehouse Builder can be licensed on a per-user basis. However, as the Warehouse Builder options can only be purchased with the Enterprise Edition of the database, there is a minimum named user purchase requirement of 25 users per CPU.

Back to top

Can a customer license Warehouse Builder and database differently?

The licensing model must be consistent across the database and Warehouse Builder.

So both must be either named user or CPU based. It is not possible to mi and match. For example a customer cannot license Enterprise Edition of the database on a per CPU basis and then license Warehouse Builder based on a named user model

Back to top

Can customers license a subset of CPUs on machine?

All CPUs on a machine must be licensed. It not possible to have Grid Control restrict ETL processing to a set number of CPUs and only license based on those CPUs.

Back to top

Will elements of OWB be disabled if the add-on options haven't been licensed?

No. Oracle does not disable the additional priced options within Warehouse Builder. After installing Warehouse Builder all options (Core ETL, Enterprise ETL, Data Quality and Connectors) are enabled and available for use. The licensing model is based on a “trust” model.

Back to top

Why are only the production systems licensed? Is it Production only?

No, customers must license all their target environments. This includes development, testing, training, QA and product environments.

Warehouse Builder supports the full development life-cycle from development right through to final production release.

Back to top

What licenses do customers get if they purchase Business Intelligence Suite Standard Edition?

Customers who purchase Business Intelligence Suite Standard Edition are automatically licensed for the Core ETL features when they purchase Standard Edition, Standard Edition One or Enterprise Edition of the database to support Oracle Business Intelligence Suite Standard Edition.

For more information please refer to the Oracle Business Intelligence Suite Standard Edition page on OTN:

http://www.oracle.com/technology/products/bi/standard-edition.html

Back to top

How do I download and install Warehouse Builder Client versus Warehouse Builder Server?

Warehouse Builder is a single install image that contains both Client and Server components, which are installed at the same time as part of the installation process. If the deployment target database is on the same machine as Warehouse Builder Client UI, there is one single installation process. If the deployment target database is on a separate machine, the install process has to be run twice, repeating the exact same install process on the client machine (to run the Warehouse Builder Design client) and the deployment target machine. Normally when installing the repository, either locally or remotely, the OWB software needs to be already present on the machine. However, it is possible to skip or defer the step of installing on the target deployment machine. This is referred to as a “Remote Target Configuration”. More information on this can be found in the Installation Guide, Chapter 2, “Remote Target”.

Back to top

Which Oracle database versions can I use with Warehouse Builder 10g Release 2?

Please refer to Metalink’s Certify page for details of supported database versions.

http://metalink.oracle.com

Back to top

Which platforms does Warehouse Builder 10g Release 2 support?

Oracle Warehouse Builder is now shipped as part of the database and accordingly supports all the same operating systems as the database.

Note: The database is no longer available on Sun Solaris SPARC 32 Bit platforms, therefore, neither is Warehouse Builder 10g Release 2.

Back to top

Which database version do I need for my Warehouse Builder Design Repository?

Oracle Database version 9.2 or higher is required for Warehouse Builder 10g Release 2 Repository. However, to use the data quality option, a database version of 10g Release 1 or higher is required.

Back to top

Are languages other than English supported?

Yes. Warehouse Builder supports a large number of languages within the repository. Once a language has been added using the Repository Assistant, you can supply a business name for your Warehouse Builder objects using that language. The User Interface of the Design Center (menus, etc) is also translated.

Back to top

What are the known issues and bugs with Warehouse Builder 10g Release 2?

Please refer to the Release Notes, “Known Issues” section.

Back to top

Can I run the Design Center UI on non-Windows platforms?

The Design Center UI is supported on both Windows and Linux platforms. All other platforms are supported as run-time environments only.

However, Warehouse Builder mappings and processes can now be deployed and executed in databases located on hosts that are different from the host where the Warehouse Builder Control Center Service is running. This eliminates the need to install Warehouse Builder software on the database host. Please refer to the Installation Guide, Chapter 2, “Remote Target” section for details.

Back to top

Does “packaged with the database” mean Warehouse Builder now gets installed with the database?

No. Warehouse Builder is delivered as a separate DVD that ships with database. The installation process requires the use of a separate ORACLE_HOME.

Back to top

Can I switch off and/or un-install the optional functionality?

No. For more detailed information on the exact list of features provided by each part of the new licensing model please refer to the Database Licensing Information 10g Release 2 (10.2) B14199-04, which is available here (A pdf version of this document is also available here), to understand what functionality is optional.

Back to top

If I install the Windows DB Client tools (e.g. Windows OEM) will this install OWB, or is it a separate install?

Warehouse Builder 10g Release 2 is a separate installation process. Warehouse Builder is packaged on two separate DVDs and is not include in the set of DVDs that provide the database installation process.

Back to top

Will it show up in my Start menu under “Integrated Management Tools” or where?

On Windows Clients, the installation process creates a program group called “Oracle – Owb_Home_Prod_Home” program group. This program group contains all the components of Warehouse Builder 10g Release 2

Back to top

Does Warehouse Builder install in the DB home or a separate home?

Yes, you must install Warehouse Builder 10g Release 2 into a separate Oracle Home.

Back to top

Can Warehouse Builder 10g Release 1 and 10g Release 2 coexist?

Yes, but you must install Warehouse Builder 10g Release 2 into a separate Oracle Home.

Back to top

Can I use Warehouse Builder 10g Release 2 with Oracle 7?

No. Oracle 7 is not supported directly as a source. It is not supported as a target either.

Back to top

Can I upgrade to Warehouse Builder 10g Release 2 from a beta version?

Yes. However, it is only possible to upgrade to 10g Release 2 from the Beta 4 version. If you are using an earlier Beta version then download the Beta 4 version from the Beta Program website and follow the upgrade steps to migrate to Beta 4. Once you have successfully upgraded to Beta 4, it will be possible to follow the upgrade steps to the production version of 10g Release 2.

More information on upgrading 10g Release 2 can be found in the Warehouse Builder 10g Release 2 Migration Document, which is available on the Beta Program Website.

Back to top

Can I upgrade to Warehouse Builder 10g Release 2 from an earlier release of Warehouse Builder?

Yes. However, direct migration is only supported from Warehouse Builder 10.1.0.4.

To upgrade from the earlier versions ((9.2.x, 9.0.x) to Warehouse Builder 10g Release 2, it will be necessary to first migrate to 10.1.0.4.

More information on upgrading 10g Release 2 can be found in the Installation and Configuration Guide, Chapter 3 “Upgrading to Warehouse Builder 10g Release 2”.

Back to top

Is there any collateral to show me how to migrate to Warehouse Builder 10g Release 2 from an earlier release of Warehouse Builder?

More information on upgrading 10g Release 2 can be found in the Installation and Configuration Guide, Chapter 3 “Upgrading to Warehouse Builder 10g Release 2”.

There is also an Oracle by Example available on OTN.

Back to top

Is it possible to import OLAP dimensions and cubes built using Analytic Workspace Manager?

There will be no “Out of the box” functionality to support this. However, there will be an Expert than can be downloaded from the Warehouse Builder exchange on OTN. For more information visit the Exchange website at:

http://www.oracle.com/technology/products/warehouse/htdocs/OWBexchange.html

All utilities posted on the Exchange are not part of any Warehouse Builder production release and are, therefore, not supported

Back to top

Is the OLAP support consistent with the AWM interface. i.e. if I create a mapping in OWB, can I see / edit it in AWM?

Currently, if OLAP objects are modeled and deployed from OWB, the mappings are not visible within AWM. This will be resolved by the 10.2.0.3 database patchset, which will be out shortly.

Back to top

Is it possible to connect to an existing Designer repository?

Using 10g Release 2 it is possible to create an Oracle module, then in the “Connection Information” step, edit the location so that it points to a Designer 2000 database. After you've created the module, edit the module and go to the “Metadata Location” page. Inside that page, you can then switch to Designer and fill in the workarea and container element information.

Back to top

Are there any training courses available for Warehouse Builder 10g Release 2?

• Oracle Warehouse Builder 10g R2: Implementation Part 1: 3-day in-Class (instructor-led)
• Oracle Warehouse Builder 10g R2: Implementation Part 2: 2-day in-Class (instructor-led)
• Oracle Warehouse Builder 10g R2: New Features: 2-day in-Class (instructor-led)
• Oracle Warehouse Builder 10g R2: Getting Started: 7-lesson Oracle By Example (online self-study)

Back to top

Is there a demo schema for Warehouse Builder 10g Release2?

There is no specific demo project or related schemas supplied with Warehouse Builder 10g Release 2. However, samples and utilities can be downloaded from the Warehouse Builder Exchange site on OTN. The Oracle Warehouse Builder Utility Exchange has been designed to provide the user community with a place where Warehouse Builder utilities, code samples, tips, tricks etc. can be exchanged on a non-profit, non-support basis.

We invite you to contribute to this exchange by sharing your own Warehouse Builder tidbits. Please post on the Oracle Warehouse Builder discussion forum and include your contact information if you would like to see your extension listed.

All utilities posted here are not part of any Warehouse Builder production release and are, therefore, not supported. Customers are invited to post questions, comments and suggestions related to this topic on the Warehouse Builder discussion forum.

Back to top

Is there any collateral to show me how to migrate to Warehouse Builder 10g Release 2 from an earlier release of Warehouse Builder?

More information on upgrading 10g Release 2 can be found in the Installation and Configuration Guide, Chapter 3 “Upgrading to Warehouse Builder 10g Release 2”.

There is also an Oracle by Example available on OTN.

Back to top