|
|
 |
 |
Oracle Warehouse Builder 10g Release 2 FAQ
Last Update 23 May 2006 at 2:00pm PDT |
General
New Features
Packaging
Licensing
Installation
Migration
Training
General
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. |
Top of Page
|
Has Warehouse Builder been renamed? |
Yes. Warehouse Builder was formally called Oracle Business Intelligence Warehouse Builder. It is now known as Oracle Warehouse Builder. |
Top of Page
|
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. |
Top of Page
|
New Features
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"
. |
Top of Page
|
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". |
Top of Page
|
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, which is available here. A pdf version of this document is also available here. |
Top of Page
|
What features are part of the Data Quality Option? |
The aim of the Data Quality Option is to support the transformation of data into quality information on an on-going basis. This option contains the following functionality:
· Discover Data Anomalies
· Identify Data Rules
· Auto-correction of Data Anomalies
· Audit ETL jobs (and take action if data quality is too low)
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, which is available here. A pdf version of this document is also available here. |
Top of Page
|
What features are part of the Connectors? |
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:
· SAP
· Oracle EBusiness Suite
· Peoplesoft 8/9
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, which is available here. A pdf version of this document is also available here. |
Top of Page
|
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. |
Top of Page
|
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. |
Top of Page
|
Is name and address cleansing a 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. |
Top of Page
|
Do we still need to get the Name & Address database from Trillium, or is it 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 |
Top of Page
|
Packaging
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. |
Top of Page
|
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. |
Top of Page
|
Licensing
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. |
Top of Page
|
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". |
Top of Page
|
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) Options can only be purchased with Enterprise Edition of the database
2) Refer to the price list for exact details and definitions.
Note – 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, which is available here. A pdf version of this document is also available here. |
Top of Page
|
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) |
Top of Page
|
For name 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. |
Top of Page
|
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 |
Top of Page
|
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. |
Top of Page
|
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. |
Top of Page
|
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. |
Top of Page
|
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 |
Top of Page
|
Installation
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". |
Top of Page
|
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. |
Top of Page
|
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. |
Top of Page
|
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. |
Top of Page
|
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. |
Top of Page
|
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. |
Top of Page
|
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. |
Top of Page
|
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. |
Top of Page
|
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
|
Top of Page
|
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. |
Top of Page
|
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. |
Top of Page
|
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. |
Top of Page
|
Migration
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. |
Top of Page
|
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". |
Top of Page
|
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. |
Top of Page
|
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. |
Top of Page
|
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. |
Top of Page
|
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. |
Top of Page
|
Training
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)
|
Top of Page
|
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. |
Top of Page
|
|
| |
Bookmark