Oracle® Warehouse Builder Installation and Configuration Guide 10g Release 1 (10.1) Part Number B12150-02 |
|
|
View PDF |
This preface includes the following topics:
Oracle Warehouse Builder is a comprehensive toolset for practitioners who move and transform data, develop and implement business intelligence systems, perform metadata management, or create and manage Oracle databases and metadata. This manual provides instructions for installing Oracle Warehouse Builder and a core set of related products. Use this manual to install the Warehouse Builder client, server, and repositories on your Windows or UNIX machines.
You can modify this installation procedure to accommodate variations in hardware and software configurations, or in the products you install with Warehouse Builder. Refer to the Oracle Warehouse Builder Release Notes for further details.
This manual is written for those responsible for installing Warehouse Builder, including:
Business Intelligence application developers
Warehouse administrators
System administrators
Other MIS professionals
To install Oracle Warehouse Builder, you must be familiar with installing Oracle Database.
This manual is organized as follows:
Chapter 1, "Warehouse Builder Installation Requirements", discusses the Warehouse Builder installation requirements. Verify your system requirements to install the Warehouse Builder client, server, and repositories.
Chapter 2, "Installing Warehouse Builder", provides step-by-step instructions for a typical installation of the Warehouse Builder client, server, browser, and the design and runtime repositories.
Chapter 3, "Upgrading to 10g Release 1 (10.1) and Migrating Data", provides step-by-step instructions for upgrading metadata from a previous version of Warehouse Builder to Oracle Warehouse Builder.
Chapter 4, "Deinstalling Warehouse Builder Components", explains how to deinstall the Warehouse Builder components.
Appendix A, "Preparing an Oracle Database", lists modifications you need to make to the init.ora file to prepare your database for the Warehouse Builder installation.
Appendix C, "Installing Oracle Enterprise Manager and Oracle Workflow", provides guidelines for installing and configuring Oracle Enterprise Manager and Oracle Workflow with Warehouse Builder to schedule jobs and manage job dependencies.
Appendix D, "Upgrading Metadata with the MDL File Upgrade Utility", provides information on using the MDL File Upgrade Utility if you want to upgrade metadata separately, instead of upgrading it as an automatic part of the MDL import.
Appendix E, "Diagnostics and Debugging", provides troubleshooting guidelines for your installation.
Appendix F, "Warehouse Builder Supported Languages", provides a list of the languages supported in Warehouse Builder and their international standard IDs.
Our goal is to make Oracle products, services, and supporting documentation accessible, with good usability, to the disabled community. To that end, our documentation includes features that make information available to users of assistive technology. This documentation is available in HTML format, and contains markup to facilitate access by the disabled community. Standards will continue to evolve over time, and Oracle is actively engaged with other market-leading technology vendors to address technical obstacles so that our documentation can be accessible to all of our customers. For additional information, visit the Oracle Accessibility Program Web site at
http://www.oracle.com/accessibility/
Accessibility of Code Examples in Documentation
JAWS, a Windows screen reader, may not always correctly read the code examples in this document. The conventions for writing code require that closing braces should appear on an otherwise empty line; however, JAWS may not always read a line of text that consists solely of a bracket or brace.
Accessibility of Links to External Web Sites in Documentation
This documentation may contain links to Web sites of other companies or organizations that Oracle does not own or control. Oracle neither evaluates nor makes any representations regarding the accessibility of these Web sites.
Warehouse Builder 10g Release 1 (10.1) has the same functionality as Warehouse Builder 9.2, with the following exceptions:
Warehouse Builder 10g Release 1 (10.1) provides support for Oracle Database 10g sources and targets.
Warehouse Builder 10g Release 1 (10.1) enables remote execution through the owb/rtp/sql/set_oem_home.sql
script. For more information, consult the Oracle Warehouse Builder Release Notes.
Support for the Express Bridge has been removed.
The following changes were made to the installation and upgrade processes:
There is no longer a distinction between the Server Side and Design Time installations. Warehouse Builder 10g Release 1 (10.1) has only one type of installation on the database server, which you must install on a computer hosting an instance of Oracle Database. In addition, for all computers designated as design clients, you can install Warehouse Builder 10g Release 1 (10.1) without an instance of Oracle Database.
Warehouse Builder 10g Release 1 (10.1) is available on all the same platforms as the Oracle Database 10g with the exception of HP OpenVMS and IBM zOS (OS/390). In accordance with the Oracle Database 10g, Warehouse Builder is available on Solaris 64 bit platform and not available on Solaris 32 bit platform.
The following functionality was added in the previous release of Warehouse Builder.
Enhancements to the Mapping Editor: Mapping Debugger
Warehouse Builder now provides you with extensive debugging capabilities for your mappings from within the Mapping Editor. Use the Mapping Debugger to locate logical design errors in your mappings. The new features allow you to step through the data flow of a mapping using comprehensive debugging functions such as setting breakpoints and watches and interactively changing test data.
Enhanced Support of Multiple Targets: Correlated Commit
This release introduces a new commit strategy for mappings with multiple targets. In previous releases, Warehouse Builder performed independent commits. That is, Warehouse Builder committed and rolled back each target separately and independently of other targets. In addition to this option, Warehouse Builder now also performs correlated commits. Warehouse Builder considers all targets collectively and commits or rolls back data uniformly across all targets. Use the correlated commit when it is important to ensure that every row in the source impacts all affected targets uniformly.
Direct Partition Exchange Loading
In previous releases, Warehouse Builder by default created a temporary table for mappings that required additional processing of source data before exchanging partitions. This occurred when the mapping contained remote sources or multiple sources joined together. Beginning in this release, you can now by-pass the creation of a temporary table and directly swap a source into a target. Use Direct PEL in a mapping to instantaneously publish fact tables that you loaded in a previously executed mapping.
Data Quality Features
Multiple Name and Address Software Providers: Beginning in this release, Warehouse Builder is compatible with multiple certified Name and Address software providers. Third-party vendors can license Name and Address software directly to you for use with Warehouse Builder. This enables you to choose a name and address provider whose offering is the most appropriate for your project.
Name-Address Operator Wizard: In previous releases, you defined the Name-Address operator using the mapping canvas and the operator Configuration Properties sheet. For improved usability, Warehouse Builder now enables you to use a wizard and Operator editor to create and edit the Name-Address operator.
Match-Merge Operator: Warehouse Builder incorporates the data quality functionality formerly available in Oracle Pure Integrate. You can use the Match-Merge operator available in the Mapping Editor to define business rules for matching and merging records. The Match-Merge operator together with the Name-Address operator support householding, the process of identifying unique households in name and address data.
Metadata Change Management
In a previous release, you could perform metadata change management using the OMB Plus scripting utility. Beginning in this release, you can also access these functions from the Warehouse Builder client user interface. Metadata change management enables you to take snapshots of metadata objects and use them for backup and history management. Snapshots are supported for any object on the navigation tree and can store information about an object alone (such as a table or module), or the objects within it as well (such as the tables within a module).
Extending Warehouse Builder Functionality
Security: Warehouse Builder now provides advanced repository security and auditing options that you can implement according to your security requirements. The advanced security options include the following:
Proactive Security: Warehouse Builder enables you to plug in a customized security PL/SQL implementation package in the Warehouse Builder repository to provide tailored access control to users according to the security rules defined by your organization.
Reactive Security: Warehouse Builder enables you to track audit information based on the metadata history and to determine security policies from such audit information.
Data Stewardship: Warehouse Builder enables an individual or a group of individuals to "own" portions of the metadata rather than the technical administrators. Metadata ownership thus becomes an important component of metadata security management.
RAC Support: With the 9.2 release, Warehouse Builder provides increased support for RAC features. Warehouse Builder now supports the use of net service names in the runtime. This enables you to plan maintenance of nodes in a cluster without having to reconfigure the runtime environment. Warehouse Builder also provides an increased availability in the runtime service. For example, if either the service instance or its associated node fails or is taken out of service, then the runtime service instance on a different node can take over. While the Warehouse Builder design repository can also be used in a RAC cluster, it will not take advantage of any failover features of RAC for this release.
Enhancements to Flat File Support
ZONED Data Type Support: Warehouse Builder now enables you to load fixed format data files containing ZONED decimal data. In the Flat File Sample Wizard, specify the ZONED data type for a flat file you import. The format for ZONED data is a string of decimal digits, one for each byte, with the sign included in the last byte. (In COBOL, this is a SIGN TRAILING field.) The length of this field is equal to the precision (number of digits) that you specify. You may also specify a scale, which is the number of digits to the right of the decimal point.
DECIMAL Data Type Support: DECIMAL data is in packed decimal format; two digits for each byte, except for the last byte, which contains a digit and sign. The DECIMAL data type includes precision and scale and therefore can represent fractional values.
Enhancements in Database Connectivity
Warehouse Builder now enables you to create public database links that can be shared across a database. Public database links can be created by repository owners, as well as any user with the CREATE PUBLIC DATABASE LINK
privilege.
Warehouse Builder Available on HP-UX and AIX
Starting with Warehouse Builder 9.2, Warehouse Builder is available on HP-UX and AIX platforms. This new availability is an addition to the UNIX (Solaris and Linux), and Windows (NT, 2000, and XP) platforms, which have been available from previous releases. (Note that the MITI Bridges feature is only available on Windows platforms.)
Public Application Programming Interface
Starting with Warehouse Builder 9.2, Warehouse Builder now includes a Public Application Programming Interface (API). To access the API, unzip and extract the following file to a folder on your local machine:
<owb home directory>\owb\lib\int\pubapi_javadoc.jar
Double click the file index.html
. Select the Help link for information on how to use the API.
In this manual, Windows refers to the Windows NT, Windows 2000, and Windows XP operating systems. The SQL*Plus interface to Oracle Database may be referred to as SQL.
In the examples, an implied carriage return occurs at the end of each line, unless otherwise noted. You must press the Return key at the end of a line of input.
The following conventions are also used in this manual:
Convention | Meaning |
---|---|
... | Horizontal ellipsis points in statements or commands mean that parts of the statement or command not directly related to the example have been omitted. |
boldface text | Boldface type in text refers to interface buttons and links. Boldface type also serves as emphasis to set apart main ideas. |
italicized text | Italicized text applies to new terms introduced for the first time. Italicized text also serves as an emphasis on key concepts. |
unicode text |
Unicode text denotes exact code, file directories and names, and literal commands. |
italicized unicode text |
Italicized unicode text refers to parameters whose value is specified by the user. |
[ ] | Brackets enclose optional clauses from which you can choose one or none. |
The Warehouse Builder documentation set includes these manuals:
Oracle Warehouse Builder Installation and Configuration Guide
Oracle Warehouse Builder User's Guide
Oracle Warehouse Builder Transformation Guide
Oracle Warehouse Builder Scripting Reference
Oracle Warehouse Builder Release Notes
In addition to the Warehouse Builder documentation, you can refer to other documents listed as follows:
Oracle Data Warehousing Guide
Oracle provides additional information sources, including other documentation, training, and support services that can enhance your understanding and knowledge of Oracle Warehouse Builder.
For more information on Oracle Warehouse Builder technical support, contact Oracle World Wide Support services at:
For the latest information on, and downloads of, software and documentation updates to Oracle Warehouse Builder, visit OracleMetaLink at:
You can order other Oracle documentation at:
OracleMetaLink
OracleMetaLink is the Oracle support Web site where you can find the latest product information, including documentation, patch information, BUG reports, and TAR entries. Once registered, you can access email, phone and Web resources for all Oracle products. OracleMetaLink is located at:
Check OracleMetaLink regularly for Warehouse Builder information and updates.
Documentation
You can order Oracle product documentation by phone or through the World Wide Web:
Phone: Call 800-252-0303 to order documentation or request a fax listing of available Oracle documentation.
Oracle Documentation Sales Web site:
Oracle Support Services Web site: