View your target model in a database format. You can later use IBM® Integration Bus to insert
information into an existing database.
Procedure
Click the Enable relational database mapping icon
(). The Destination
Database Platform Selection wizard opens.
Complete the Destination Database,
and Destination Schema fields, and select the
product and version of your database. Click OK. Blank Table, Column, and SQL Data Type columns are displayed.
The Relational mapping options icon (), at the upper right of the Target Model
editor, is also
in focus.
To generate the default SQL table naming for your target
database, click the Relational mapping options icon () and select Generate Default
SQL Table Naming.
Results
The Target Model
editor is
populated with the details of your target model, in a database format.
Renaming tables and columns
About this task
Rename tables or columns to change the location of an element
within your database representation.
Procedure
Double-click the table or column cell that you want to
alter. The cell is highlighted for editing.
Type the new name of the table or column.
Results
The selected table or column is renamed.
Assigning different data types to elements
About this task
Change the SQL Data Type of elements to change the type of
data the elements can hold.
Procedure
Double-click the SQL Data Type cell that you want to alter. An ellipsis button is displayed in the cell.
Click the ellipsis button to display the SQL
Data Type window.
Complete the fields and click OK.
Results
The SQL Data Type is changed.
Deleting cell contents
About this task
Delete the contents of cells in your database representation.
Procedure
To delete the contents of individual cells, complete the
following steps:
Double-click the cell to highlight it for editing.
Press the Delete key.
To delete the contents of a row, but not the element name,
complete the following steps:
Right-click a cell in the row that you want to delete
the contents of.
Select Reset SQL Naming from
the menu.
To delete the contents of all of the cells, except for
the element names, complete the following steps:
Click the Relational mapping options icon () at the upper-right of the target model
editor.
Select Reset SQL Naming from
the menu.
The contents of cells are deleted.
Highlighting elements or attributes that are in the same table
About this task
Highlight elements or attributes that are in the same table
so that it is easier to view the contents of a specific table.
Procedure
Right-click a cell in the table that you want to highlight.
Select Show Elements or Attributes With the
Same Table
Results
Elements and attributes that are from the same table are highlighted.