After creating the business model, the next step is to add the business tables and business columns, then create the relationships between our business tables.
Introducing the Metadata Editor Graph
Up to this point, we have only used the Tree Navigator to construct the business objects. The big white canvas on the right side of the screen is the Metadata Editor Graph, and we use the Graph to lay out our business tables and show the relationships between them. While we can accomplish the rest of our tasks using only use the Tree Navigator, from here forward I will describe how to perform each operation using both the Tree Navigator and the Editor Graph, so you can decide which view suits you better.
Tree Navigator: Creating a New Business Table
To add a new business table using the Tree Navigator, first make sure that the model you want to add this business table to is selected (in the tree), and the Business Tables node is expanded.
- Right-click (or ALT-click) on the Business Tables branch in the Navigator Tree.
- Select the New Business Table... option from the popup menu.
- You will be prompted with a list of physical tables, each prefixed by the connection name they belong to. Select the physical table you want to associate with this new business table.
Under Construction Alert
The first business table you create determines what connection is linked to this model - the one connection that this model can support. The connection is determined by interrogating the physical table that you associate in this step.
We will be building out the connection to business model UI functionality in the future, but realize for now (as of the M4 release) that this area is half-baked. If you change your mind and want to associate a different connection with this model, you will have to delete all of your business tables. You could possibly hand-edit the exported XML and re-import it to change the connection, but I haven't tried it so I won't guarantee that it will work.
- Click OK on the prompt. The Business Table Properties dialog displays.