Home

	Expand Search

WarehouseArchitect - User's Guide

Part 3 WarehouseArchitect Model

Chapter 22: Database Creation and Modification

Accessing a database

Accessing a database

Changing target database

When you create a WAM, you select a target database. If you change target database the WAM may be altered to become compatible with the new database.

Preservation optionsWhen you change database, depending on which objects are supported by the old and new target databases, you can choose to preserve or not to preserve the values associated with the following database objects:

• Triggers and stored procedures
• Physical options (on the database, tables, indexes, primary and alternate keys)
• Storages
• Tablespaces
• Abstract data types

If a database object is not supported by the old or new target database, the preserve option for that object is greyed and cannot be selected. If the new target database does not support an object, you will lose the values associated with that object when you change target database.

Syntax incompatibilityWhen you change target database there can be syntax incompatibility between physical options.

If there is syntax incompatibility, you will lose the values for the physical option that is not recognized by the new target database, even if you have selected the checkbox to preserve that physical option.

ExampleIf you are using physical option in while using SQL Anywhere, and you change target database to Oracle 7 which does not recognize the option in , you will lose all the values associated with that option in your model.

• To change the target database for a WAM:
  1. Select Database-->Change Target Database.

     If you have made modifications to the model, a confirmation box asks if you want to save the model before you change database.

     Click Yes to save your modifications.

     If you have not made any modifications to the model before changing database, you do not receive the message.

     The database selection dialog box appears.

     

     If you are changing target database within a database family, for example between Sybase SQL Server 10 and Sybase SQL Server 11, all preserve options available are selected by default.

     The checkboxes for database objects not supported by the old and new target databases are disabled.

  2. Select a target database from the dropdown listbox.

  3. Select checkboxes for procedures and triggers, objects, and physical options that you want to preserve.

  4. Clear checkboxes for procedures and triggers, objects, and physical options that you do not want to preserve.

  5. Click OK.

  6. A message box tells you the target database has been changed.

  7. Click OK.

     The name of the selected database appears in the status bar.

Displaying data from a database

If the database corresponding to the WAM already exists, you can display the data that corresponds to a table, view, or reference in the WAM.

• To display data from a connected database:
  1. Right-click a table, view, or reference.

  2. Select View Data from the context menu.

     A dialog box asks you to identify a data source and connection parameters.

     

  3. Select a data source from the dropdown listbox.

  4. Type your user name and password.

  5. Click Connect and, if prompted by your data source, enter additional connection parameters.

     A Query Results windows list all the database records corresponding to the selected table, view, or reference.

  6. Click the Close button.

Executing SQL queries

You can send SQL queries to a connected data source and display the results.

• To execute SQL queries:
  1. Select Database-->Execute SQL.

     A dialog box asks you to identify a data source and connection parameters.

     

  2. Select a data source from the dropdown listbox.

  3. Type your user name and password.

  4. Click Connect and, if prompted by your data source, enter additional connection parameters.

     A Queries window appears.

     

  5. Type one or more SQL queries in the window.

     The syntax of some SQL queries may be DBMS-dependent.

  6. Click the Execute button.

     A list displays the results of your queries.

     

  7. Click Close.

     You return to the queries window.

  8. Click Cancel.