Editing databases in the Target Model editor

Use the Data Analysis perspective to view and edit your database, which is generated from your target model.

Before you start:
See the following topics to learn how to use different features in the database editor:

Viewing your database

View your target model in a database format. You can later use WebSphere® Message Broker to insert information to an existing database.
  1. To generate the correct SQL for your target database, click the Enable relational database mapping icon at the upper right of the target model editor. The Destination Database Platform Selection wizard opens.
  2. Complete the Destination Database, and Destination Schema fields, and select the product and version of the database. Click OK. Blank Table, Column, and SQL Data Type columns are displayed. The Relational mapping options icon is also in focus.
  3. Click the Relational mapping options icon and select Generate Default SQL Table Naming.
The database is populated.

Renaming tables and columns

Rename tables or columns to change the location of an element within your database.
  1. Double-click the table or column cell that you want to alter. The cell is highlighted for editing.
  2. Type the new name of the table or column.
The selected table or column is renamed.

Assigning different data types to elements

Change the SQL Data Type of elements to change the type of data the elements can hold.
  1. Double-click the SQL Data Type cell that you want to alter. An icon is displayed in the cell.
  2. Click the icon to display the SQL Data Type window.
  3. Complete the fields and click OK.
The SQL Data Type is changed.

Deleting cell contents

Delete the contents of cells in your database.

Highlighting elements or attributes that are in the same table

Highlight elements or attributes that are in the same table so that it is easier to view the contents of a specific table.
  1. Right-click a cell in the table that you want to highlight.
  2. Select Show Elements or Attributes With the Same Table
Next:Create your Data Analysis Tools. See Creating Data Analysis tools.
Avisos | Marcas registradas | Descargas | Biblioteca | Soporte | Su opinión

Copyright IBM Corporation 1999, 2013Copyright IBM Corporation 1999, 2013.

        
        Última actualización
        
        Última actualización : 2013-02-27 18:27:14


Tema de tareaTema de tarea | Versión 8.0.0.2 | bd24250_