WebSphere Message Broker, Version 8.0.0.7
Operating Systems: AIX, HP-Itanium, Linux, Solaris, Windows, z/OS
See information about the latest product version
See information about the latest product version
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 start:
- Create your target model. See Creating a target model.
- Populate your target model. See Populating a target model from your sample XML documents.
- Set up your database. See Data Analysis database setup.
See the following topics to learn how to use different features
in the Target Model editor:
Viewing your database representation
View your target model in a database format. You can later use WebSphere® Message
Broker 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.
Renaming tables and columns
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.
Assigning different data types to elements
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.
Deleting cell contents
Delete the contents of cells in your database representation.
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.
- Right-click a cell in the table that you want to highlight.
- Select Show Elements or Attributes With the Same Table
Elements and attributes that are from the same table are highlighted.
Next: Create your Data Analysis tools. See Creating Data Analysis tools.