Home

	Expand Search

WarehouseArchitect - User's Guide

Part 3 WarehouseArchitect Model

Chapter 13: Creating Links to Operational Systems

Chapter 13
Creating Links to Operational Systems

About this chapterThis chapter explains how to create a link between a data warehouse and different operational systems. It explains how to import tables and columns from the operational system databases, and how to generate an extraction script to populate the data warehouse.

Defining external databases

Identifying an external database

External database properties

Importing objects from an external database

Importing tables from a PDM or a WAM

Importing tables from a script

Importing tables via ODBC

Selecting import options

Defining external tables

Creating an external table

External table properties

Modifying external table properties

Defining external columns

Creating an external column

External column properties

Importing an external column into a WAM table

Defining links to external sources

Linking a table in a WAM to an external table

Linking a column in a WAM to an external column

Editing extraction expressions

Editing an extraction expression for a table

Editing an extraction expression for a column

Using the script editor

Previewing an extraction expression

Making an expression invalid

Generating an extraction script