Data Warehouse Center Application Integration Guide

Table of Contents

  • About this book
    Who should read this book

    Integrating Applications

  • Planning to integrate your applications
    How partner applications can work with the Data Warehouse Center and the Information Catalog Manager
    Managing partner applications
    Managing metadata
    Integration scenarios
    Hardware and software requirements

  • Importing and exporting metadata
    Importing metadata into the Data Warehouse Center
    Building the tag language file
    Importing metadata from the tag language file
    Preparing the steps to run
    Exporting metadata from the Data Warehouse Center
    Selecting objects for which to export metadata
    Exporting metadata into a tag language file

  • Importing and exporting metadata with the Information Catalog Manager
    Importing metadata into an information catalog
    Selecting metadata to import
    Importing metadata from a tag language file
    Exporting metadata from Information Catalog Manager
    Selecting metadata to export
    Exporting tag language files

  • Ensuring that users can start programs from the Information Catalog Manager
    Additional requirements for Information Catalog Manager for the Web users

    Metadata reference

  • Metadata templates
    AgentSite.tag
    Tokens
    Examples of values
    Column.tag
    Tokens
    Examples of values
    HeaderInfo.tag
    Tokens
    Examples of values
    Process.tag
    Tokens
    Examples of values
    StarSchema.tag
    Tokens
    Examples of values
    StarSchemaInputTable.tag
    Tokens
    Examples of values
    Step.tag
    Tokens
    Examples of values
    StepCascade.tag
    Tokens
    Examples of values
    StepInputTable.tag
    Tokens
    Examples of values
    StepOutputTable.tag
    Tokens
    Examples of values
    StepVWPOutputTable.tag
    Tokens
    Examples of values
    StepVWPProgramInstance.tag
    Tokens
    Examples of values
    SourceDataBase.tag
    Tokens
    Examples of values
    SubjectArea.tag
    Tokens
    Examples of values
    Table.tag
    Tokens
    Examples of values
    VWPGroup.tag
    Tokens
    Examples of values
    VWPProgramInstanceParameter.tag
    Tokens
    Examples of values
    VWPProgramTemplate.tag
    Tokens
    Examples of values
    VWPProgramTemplateParameter.tag
    Tokens
    Examples of values
    WarehouseDataBase.tag
    Tokens
    Examples of values

  • Data Warehouse Center metadata
    DATABASE object
    Properties
    Relationships
    TABLES object
    Properties
    Relationships
    COLUMN object
    Properties
    Relationships

  • Information Catalog Manager system tables and metadata models
    FLG.ATCHREL table
    FLG.CHECKPT table
    FLG.COMMENTS table
    FLG.EXCHANGE table
    FLG.HISTORY table
    FLG.NAMEINST table
    FLG.OBJTYREG table
    FLG.OVERDESC table
    FLG.PARMS table
    FLG.PROGRAMS table
    FLG.PROPERTY table
    FLG.RELINST table
    FLG.USERS table
    FLG.WINICON table
    Information Catalog Manager metadata models
    Model for Information Catalog Manager system tables
    Logical metadata model
    Using SQL to access metadata

  • Information Catalog Manager object types
    Default properties for all object types
    Default property summary
    Guidelines for extendible objects types
    Predefined Information Catalog Manager object types
    Predefined object type models
    Predefined object type descriptions
    Predefined program objects

  • Tag language
    Rules for writing tag language files
    How the Information Catalog Manager reads tag language files
    Valid data types for Information Catalog Manager descriptive data
    How to read the tag language syntax diagrams
    ACTION.OBJINST
    Context
    Syntax
    Options
    ACTION.OBJTYPE
    Context
    Syntax
    Options
    ACTION.RELATION
    Context
    Syntax
    Options
    COMMENT
    Syntax
    Rules
    COMMIT
    Context
    Syntax
    Keywords
    Rules
    DISKCNTL
    Context
    Syntax
    Keywords
    Rules
    INSTANCE
    Context
    Syntax
    NL
    Syntax
    Rules
    OBJECT
    Context
    Syntax
    PROPERTY
    Syntax
    Context
    Keywords
    Rules
    RELTYPE
    Syntax
    Context
    Keywords
    TAB
    Syntax
    Rules

  • What a tag language file should look like
    Start your tag language file with DISKCNTL
    Define your additions, changes, and deletions
    Defining what you want to do
    Defining the information
    Putting it all together
    Committing changes to the database
    Putting comments in the tag language file

    Supplied program and macro reference

  • Supplied Data Warehouse Center programs
    VWPEXUNX
    Parameters
    Return codes
    Log files
    ISV_Sample

  • Net.Data macros
    Information Catalog Manager for the Web files

    Appendixes

  • Appendix A. Template planning worksheet

  • Appendix B. Templates supported by Visual Warehouse 5.2
    BusinessView.tag
    Tokens
    Examples of values
    BusinessViewInputTable.tag
    Tokens
    Examples of values
    BusinessViewOutputTable.tag
    Tokens
    Examples of values
    BusinessViewVWPOutputTable.tag
    Tokens
    Examples of values
    ConcurrentCascade.tag
    Tokens
    Examples of values
    PostCascade.tag
    Tokens
    Examples of values
    VWPProgramInstance.tag
    Tokens
    Examples of values

  • Appendix C. Writing your own program to use with the Data Warehouse Center
    Passing parameters
    Returning status information
    Transferring the information to the Data Warehouse Center
    Format of the feedback file
    How the feedback determines the step status

  • Notices
    Trademarks

  • Bibliography

  • Index

  • Contacting IBM
    Product Information