1 / 41

Setting Up and Starting Warehouse Builder

Setting Up and Starting Warehouse Builder. Objectives. After completing this lesson, you should be able to do the following: Describe typical Oracle Warehouse Builder configurations, including the classroom stand-alone setup Describe Oracle Warehouse Builder program group components

benard
Download Presentation

Setting Up and Starting Warehouse Builder

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Setting Up and Starting Warehouse Builder

  2. Objectives • After completing this lesson, you should be able to do the following: • Describe typical Oracle Warehouse Builder configurations, including the classroom stand-alone setup • Describe Oracle Warehouse Builder program group components • Log in to the Design Center • Create a design repository and users • Open a project and navigate the user interface

  3. What Is Oracle Warehouse Builder? • Oracle Warehouse Builder (OWB) is an extensible framework for designing, deploying, and managing enterprise data warehouses, data marts, and e-business intelligence applications.

  4. Producing Quality Information • Warehouse Builder enables the extraction, transformation, and loading of data to produce quality information in the Oracle database. Businessintelligence Action Transformation Data Information Knowledge (Qualityinformation)

  5. New Segmentation of OWB Functionality Core ETL FeaturesEasily load data into the Oracle database: • Bundled with Database SE1/SE/EE at no extra charge • Packaged as a separate media pack • Includes all existing 10g R1 functionality, plus “experts” Connectors Extract from commonERP/CRM: • SAP • PeopleSoft 8/9 • Oracle E-Business Suite Data Quality Option Convert data to quality Information on an ongoing basis: • Data profiling • Derivation of rules • Correction maps Enterprise ETL Option Enable large-scale,complex deployments Note: Options and connectors are available for licensing with Oracle Database Enterprise Edition only.

  6. New Segmentation of OWB Functionality Core ETL FeaturesEasily load data into the Oracle database: • Bundled with Database SE1/SE/EE at no extra charge • Packaged as a separate media pack • Includes all existing 10g R1 functionality, plus “experts” Connectors Extract from commonERP/CRM: • SAP • PeopleSoft 8/9 • Oracle E-Business Suite Data Quality Option Convert data to quality information on an ongoing basis: • Data profiling • Derivation of rules • Correction maps Enterprise ETL Option Enable large-scale,complex deployments Note: Options and connectors are available for licensing with Oracle Database Enterprise Edition only.

  7. BI Environment from an OWB Perspective OWB Model, extract, transform, load, and manage BI data Create analytic content Share Business Intelligence OWB repository Relational Portal page Disco Plus BI Beans Sources and/or Disco Viewer Multi-dimensional(OLAP) • Relational • Flat files • Applications • Mainframe • SAP Spread-sheet add-in Reports BI Beans application Oracle database Tools using BI data

  8. Sources Targets Oracle: Tables, views, materialized views, external tables, transportable tablespaces, SQL*Loader, and so on Oracle: Tables, views, materialized views, external tables, dimensions, cubes, and so on Other vendors: IBM DB2, Microsoft SQL Server, Sybase, Informix, Mainframes, and so on (via Oracle Transparent Gateways) Other vendors: IBM DB2, Microsoft SQL Server, Sybase, Informix, Mainframes, and so on (via Oracle Transparent Gateways) ODBC ODBC Flat files Flat files Applications: Oracle Applications, SAP, PeopleSoft, Custom SQL applications, and so on Applications: Oracle Applications, PeopleSoft, Custom SQL applications, and so on OWB Sources and Targets

  9. Installing OWB • Read the entire installation document before: • Choosing a configuration environment • Choosing the order of installation • Starting the installation • Oracle Warehouse Builder Installation and Configuration Guide

  10. Hardware and Software Requirements • Hardware requirements for Microsoft Windows: • 963 MB disk space for OWB installation • 1 GB memory • 1 GB page file size, TMP, or swap space • 1 GHz Pentium processor or equivalent • Software requirements: Supported operating systems: • Microsoft Windows XP • Microsoft Windows 2000 • Windows Server 2003 • Linux x86 (Red Hat Enterprise Linux AS/ES, SLES,and Asianux, and SuSE LINUX Enterprise Server) • HP-UX PA-RISC • IBM AIX

  11. Supported and Certified Versionsof Oracle RDBMS • Oracle Database 10g or Oracle9i Database (9.2) Enterprise Edition is installed on computers hosting the Warehouse Builder repository and targets. • Deploying dimensional structures to an analytic workspace requires either Oracle Database 10g Release 2 or Oracle Database 10g Release 1 (10.1.0.3) with the 10.1.0.4 patch set, with the OLAP option selected. • RDBMS support for data warehousing includes: • Oracle Enterprise Manager (OEM) integration for the “warehouse upgrade” feature and job scheduling • Oracle Workflow for dependency management • The MERGE command • Full outer joins, and much more

  12. Software Versions Compatiblewith Warehouse Builder • Supported Oracle database versions: • Sources: 8.1.7, 9.0.x, 9.2.x, 10g Releases 1 and 2 • Targets: 9.2.x, 10g Releases 1 and 2 • OWB Repository: 9.2.x, 10g Releases 1 and 2 • Oracle OLAP: 10.1.0.4 and later • Discoverer: 10g • BI Beans: 10g • SAP: 3.x, 4.x • Oracle Enterprise Manager: 9.0.x, 9.2.x • Oracle Workflow: 2.6.2, 2.6.3, 2.6.4 (OWF 10g) • Oracle Applications (Concurrent Manager): 11i

  13. OWB Product Components • Design Center • OMB Plus • Repository Browser • Administration • Repository Assistant: • Start or Stop Control Center Service • Start or Stop OWB Browser Listener

  14. Installing and Configuring OWB Run the Oracle Universal Installerto install the OWB software. Start the Design Center, and click the Get Started button. Or, select Administration > Repository Assistant to createusers. Create target schemas. You can create target schemas by using the Repository Assistant or by using the Security node in the Global Explorer panel in the Design Center.

  15. Configuring OWB Database Client • Oracle database • Oracle Agent • TNS listener • Oracle Management Service (OMS) • Oracle Application Server 10g: HTTP Server and Portal (O) • Workflow Monitor • OWB Runtime Platform Service • Database object for: OWB : Repository schema : Target schema Portal (O) Workflow Server (O) OEM repository (O) • Warehouse Builder: • Design Center • Repository Assistant • Repository Browser • Control Center Service • OMB Plus scripting • Net client • Web browser • OEM client (O) • Workflow client (O) O = optional

  16. Classroom Stand-alone Configuration Each student PC • The following reside on each computer: • Source flat files and schemas • Metadata repository • Target schema • All data warehousing software • Warehouse Builder: • Design Center • Repository Assistant • Repository Browser • Control Center Service • OMB Plus scripting • Oracle Database 10g: • Repository schema • Source and target schemas • Workflow Server • OracleBI 10g components (Discoverer for OLAP to show integration)

  17. OWB 10g R2 Default Installationwith a Single Repository Created by the OWB Repository Assistant or Logon dialog box’s Get Started button Created by the repository owner Target schemas Repository owner Highly privileged database user • Create database objects: • - Tables - Dimensions, cubes - Mappings - Packages, … Repository user • - Audit tables - Run-time and deployment statistics - Physical location info - Design metadata - Possible target Can be a single repository Repository users Repository owner Target users

  18. Target Users Created by the OWB Repository Assistant or Logon dialog box’s Get Started button Created by the repository owner Target schemas Repository owner Highly privileged database user • Create database objects: • - Tables - Dimensions, cubes - Mappings - Packages, … Repository user • - Audit tables - Run-time and deployment statistics - Physical location info - Design metadata - Possible target Can be a single repository Repository users Repository owner Target users

  19. Logging In to OWB Design Center You can initially use the Get Started button to create a user, after which you should use privileged users in the Design Center to administer other users.

  20. Practice 1-1:Creating a Repository Owner and User • This practice covers the following topics: • Invoking the Warehouse Builder Design Center Logon dialog box • Creating a repository user and repository owner

  21. Projects • A project is the highest-level object in Warehouse Builder. • It is best to create projects after identifying the functional areas for the projects. Project A Staging Mapping Warehousemodule Transformations Source module Project B Operational data sources Data Mart Mapping Warehousemodule Warehousemodule Transformations

  22. Organizing Your Work in Projects Source to Warehouse Project Warehouse Source Warehouse module Warehouse module Tables Views Tables Views Sequences Temp tables Sequences Flat files Custom schema objects Mappings Transformations Warehouse to Data Mart Project Data mart Warehouse Warehouse module Warehouse module Cube table Dimensions Tables Views Materialized views Sequences Temp tables Mappings Mappings Transformations Transformations

  23. Jan Kim Trevor Concurrent Users per Projectwith Object Locking Project 1 Database Project 1 Repository A Repository B A database can contain multiple users’ OWB repositories.Multiple users can work on the same project. Project 2

  24. Multiple User Access Title bar indicatesread/write orread-only mode. An attempt to open an object already opened and locked by another user results in a warning, allowing read-only access. An attempt to delete a read-only object locked by another user results in a warning.

  25. Design Center Menus Toolbar Project explorer Connection explorer Project explorer: Holds all information related to a single project Connection explorer: Holds all connections and control centers for the repository Global explorer: Holds all objects that are shared among users of the repository; this is a great place to share reusable components across projects Global explorer

  26. Objects Within a Project Oraclemodules

  27. Objects Within a Project Files Applications

  28. Objects Within a Project Data rules Pluggable mappings Process flow modules Process flow

  29. Objects Within a Project Derived object for OracleBI Discoverer Derived object for OracleBI Beans Schedules User-defined modulesfor user-defined objectscreated via OMB Plus scripting

  30. Objects Within a Project Experts Named configurations for multiple targets Collections

  31. Objects Within a Module Module node expanded to show its objects Dimensions Cubes Tables

  32. Objects Within a Module Mappings Transformations Data auditors

  33. Objects Within a Module User-defined types Queues

  34. Locations, Connectors,and Control Centers Oracle database locations Connectors Files locations Workflow location Discoverer location Control centers

  35. Locations, Connectors,and Control Centers Oracle database locations Connectors Files locations Workflow location Discoverer location Control centers

  36. Global Explorer Objects Security node seenonly by users granted the Administrator role

  37. Creating a Project

  38. Setting Project Preferences

  39. Setting Project Preferences

  40. Summary • In this lesson, you should have learned how to: • Describe a variety of possible installation configurations • Install Warehouse Builder • Create repository users and log in • Begin navigating through the Warehouse Builder client user interface

  41. Practice 1-2: Invoking OWBand Opening a Project • This practice covers the following topics: • Logging in to Warehouse Builder Design Center • Creating a new project • Viewing project properties • Navigating through the user interface

More Related