Contents

Title and Copyright Information

Preface

• Purpose
• Audience
• Documentation Accessibility
• Related Documents
• Conventions

Part I Public Views

1 Public Views for the Runtime Environment

• Warehouse Builder Runtime Repository Public Views
• Deployment Auditing Views
• Execution Auditing Views

2 Public Views for the Design Environment

• Warehouse Builder Design Repository Public Views
• General Model Views
• Data Model Views
• Flat Files Views
• Collections Views
• Function Model Views
• Configuration Model Views
• Deployment Model Views
• Mapping Model Views
• Process Flow Model Views
• Data Profiling Views
• Data Rules Views
• User Defined Object Views
• Expert Views
• Business Intelligence Views
• Real Time Views
• Scheduling Views
• Security Views
• Code Template Views
• Web Services Views
• Others

Part II OMB*Plus Scripting Language

3 Introduction to OMB*Plus

• About the OMB Scripting Language
  • Using OMB*Plus
    • Launching OMB*Plus
    • Connecting to a Repository
    • Getting Help for OMB*Plus Commands
  • Writing OMB*Plus Commands
    • Specifying Values
    • Special Characters
    • Escaping Special Characters and Writing Complex Arguments
    • Specifying Paths
    • Predefined Tcl Procedures
  • Running Scripts in OMB*Plus
    • Locating Errors in Scripts and Multi-line Commands
• OMB*Plus Commands
  • Metadata Manipulation Language (MML) Commands
  • Examples
    • Warehouse Builder Metadata Objects
  • Shell Commands
    • OMBHELP
    • OMBENV
  • Administrative Commands
  • Navigation Commands
    • OMBCC
    • OMBDCC
    • OMBLIST
  • Service Commands
    • Synchronizing Cached Data with Repository Objects
    • Changing the User Mode

4 Sample Scripts

• Updating a Design Repository
• Reporting on Repository Objects
• Finding Invalid Objects
• Using OMB*Plus to Navigate Repositories

Part III Using Experts

5 About Experts

• What Are Experts?
  • User's View of an Expert
  • Developer's View of an Expert
  • How Are Experts Different From Process Flows?

6 Creating Experts

• How to Create Experts
• Creating an Expert Object
• Adding Tasks to the Expert Canvas
• Adding Nested Experts to the Expert Canvas
• Adding Transitions to the Expert Canvas
• Passing Data Values Among Tasks
  • Binding Input Parameters
  • Using Constants
  • Using Variables
• Validating, Generating, and Starting Experts
• Creating a Development Environment
• Publishing Experts
• Running an Expert From a Batch File

7 Creating and Managing Custom Objects and Properties

• Extending the Workspace With User Defined Objects
  • Using OMB*Plus Scripts to Specify UDOs and UDPs
  • Naming Conventions for UDOs and UDPs
• Adding New Properties to Workspace Objects
  • Creating UDPs: An Example
• Adding UDOs to the Workspace
  • Writing Scripts to Define UDOs
  • Creating UDOs: An Example
  • Associating UDOs with Objects
• Working with UDOs and UDPs
  • Propagating UDOs and UDPs to Other Workspaces
• Creating New Icons for Workspace Objects
  • Creating Icon Sets
    • Create Icon Set Dialog Box
  • Assigning New Icon Sets to Objects

A Additional and Optional Usages

• Using Control Files to Import and Export Metadata
  • Creating MDL Control Files
    • Keywords Used to Import Metadata
    • Examples of Control Files Used to Import Metadata
  • Exporting Metadata Using OMB*Plus
  • Importing Metadata Using OMB*Plus
  • Accessing Transformation Modules Using OMB*Plus
    • Predefined Transformations
    • Accessing Predefined Transformations Using OMB*Plus
    • Custom Transformations
    • Public Custom Transformations
    • Custom Transformations that Belong to a Particular Project
• Working with Mappings and Operators
  • Defining Expressions in Mappings
  • Default Group Names and Attribute Names
• Accessing Transformation Modules
  • Predefined Transformations
    • Accessing Predefined Transformations Using OMB*Plus
  • Custom Transformations
    • Public Custom Transformations
    • Custom Transformations that Belong to a Particular Project