Editing the database representation of the target model in the Target Model editor

Use the Target Model editor to view and edit your database representation, which is generated from your target model.

Before you begin

See the following topics to learn how to use different features in the Target Model editor:

View your target model in a database format. You can later use IBM App Connect Enterprise to insert information into an existing database.

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.

The Target Model editor is populated with the details of your target model, in a database format.

Rename tables or columns to change the location of an element within your database representation.

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.

The selected table or column is renamed.

Change the SQL Data Type of elements to change the type of data the elements can hold.

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.

The SQL Data Type is changed.

Delete the contents of cells in your database representation.

To delete the contents of individual cells, complete the following steps:
1. Double-click the cell to highlight it for editing.
2. Press the Delete key.
To delete the contents of a row, but not the element name, complete the following steps:
1. Right-click a cell in the row that you want to delete the contents of.
2. 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:
1. Click the Relational mapping options icon () at the upper-right of the target model editor.
2. Select Reset SQL Naming from the menu.
The contents of cells are deleted.

Highlight elements or attributes that are in the same table so that it is easier to view the contents of a specific table.

Elements and attributes that are from the same table are highlighted.

Create your Data Analysis tools. See Creating Data Analysis tools.