Home

	Expand Search

WarehouseArchitect - User's Guide

Part 3 WarehouseArchitect Model

Chapter 13: Creating Links to Operational Systems

Generating an extraction script

Generating an extraction script

Table optionsTable options indicate the tables for which you want to generate an extraction script.

You have the following table options:

Option	Description
All Tables	Generate an extraction script for all tables in the WAM
List	Generate an extraction script for selected tables in the WAM

Database optionsDatabase options indicate the external databases for which you want to generate an extraction script.

You have the following database options:

Option	Description
All databases	Generate an extraction script for all external databases
List	Generate an extraction script for selected external databases

General optionsGeneral options indicate the format of database generation scripts.

The availability of these options depends on the target database. Unavailable options appear in gray and you cannot select them.

Option	Result of selection
Uppercase	Script contains all uppercase characters
Lowercase	Script contains all lowercase characters
No accent	Non-accented characters replace non-accented characters in script
Codes	Script refers to objects by their codes
Names	Script refers to objects by their names
Windows (ANSI)	Script uses ANSI character set
DOS (OEM)	Script uses DOS character set
Add titles	Each section of the script includes commentary in the form of titles (for example, Database Name: TUTORIAL)
ODBC syntax	Generates script in ODBC syntax instead of DBMS-specific syntax. This option based on the ODBC.DEF file allows you to preview the commands the PowerDesigner sends when it creates or modify a database via an ODBC driver
Check model	Check the WAM before generating the database or script, and stop generation if an error is found

• To generate an extraction script:
  1. Select WAM-->Generate Extraction Scripts.

     The Extraction Script Generation dialog box appears.

     

  2. Type the destination directory in the Directory box.

  3. Select the All Tables radio button to generate a script for all tables.

     or

     Select the List radio button, click the Question Mark button, select tables, and click OK.

  4. Select the All Databases radio button to generate a script for all external databases.

     or

     Select the List radio button, click the Question Mark button, select external databases, and click OK.

  5. Select script generation options.

  6. Click the Generate Script button.

     A message window reports progress of script generation.

     

  7. Click OK.