Application Relationship Editor

Follow the steps below to create an Application Relationship (AR) specification.

Icons appear on various tabs to indicate the type of resource:

To create a new application relationship

1. Do one of the following:
   1. In File-AID Explorer, navigate to the desired repository, right-click Application Relationship, and select New.
   2. From the File menu, select New>Other. The Select a Wizard dialog box appears. Select Compuware>Topaz for Enterprise Data>Application Relationship and click Next.
      The New Application Relationship Specification dialog box appears.
2. In the Name field, enter a name for the application relationship specification being created.
3. Optionally, in the Description field, enter a description for the application relationship specification being created.
4. Optionally, from the Repository list, select a different repository in which to store the application relationship specification. The Repository field is prepopulated based on the repository from which the new specification was initiated.
5. In the Objects section, click Add Objects. The Resource selection dialog box appears to allow the user to locate the desired objects from which to create relationships.
6. Select one of the following based on the type of relationship to be created:
   • Select the Database radio button
   • Select the Db2 for z/OS radio button
   • Select the Dataset radio button
7. To select the host, do either of the following:
   • In the Host field, select the host connection from the list.
   • Click Configure to add a new host connection. The Host Connections page of the Preferences dialog box appears. Complete this dialog box according to the instructions in the Host Explorer Connections topic in the Host Explorer User Guide.

• 
  
  • If the Db2 for z/OS radio button was selected, from the SSID list, select the DB2 subsystem that contains the desired schema and objects.
  • If the Database radio button or the Db2 for z/OS radio button was selected, in the Schemas box's Name field, enter a schema name and click List. A list of matching schemas appears. Refer to the Filters topic in the Host Explorer User Guide for information about filtering schema names.
    From the resulting list, select the appropriate schema, and then use the Tables box to select or search for the desired objects. The search is case-sensitive.

      8. If the Dataset radio button was selected, do the following to select the desired dataset and a layout for that dataset.

• 
  
  • In the Name field, enter filter text and press Enter or click List to display the datasets matching the filter.
  • In the Record Layout Information section, click Browse and navigate to the location of the layout dataset (member) and select it. The Level 01 Name dropdown list is populated with the first 01 level from the layout selected. Click OK.

      9. Do one of the following:

1. 
   
   • To add the objects to the specification and remain on the dialog box to add more objects, click Add. The objects are added to the Objects list on the New Application Relationship Specification dialog box.

   • To add the objects and close the dialog box, click Add and Close.

     Note

     Optionally, to remove objects, select the desired objects and click Remove.

     10. Click Finish. The Application Relationship - Overview tab appears with the above information populated.

11. Click the Objects tab. The Application Relationship - Objects tab appears. This tab shows the ID (a numerical identification of the object), type, name, and relationship count (the number of relationships that the object is in) for objects that were added via the Resource Selection dialog box.

1. • Enter text into the <type filter text> field to filter the tab to show only the rows that contain the typed text.
   • To add more objects, click .

   • To remove objects from the specification, select the objects and either click  or right-click and select Remove.

12. To create a relationship between two objects, select the two objects and either click  or right-click and select Create New Relationship. The Create Relationship dialog box appears.

1. 
   
   • In the Relationship Name field, enter a name for the relationship.

   • From the Parent list, select the parent object for the application relationship.

     From the Dependent list, select the dependent object for the application relationship. The Layouts section displays the full layouts of the parent and dependent.

     Note

     If desired, click to change the parent to a dependent or vice versa.

   • Use the Layouts section in either of the following ways to select the columns to be associated:

1. 
   
   1. 
      
      • Drag and drop a parent column onto the dependent column
      • Select the parent and dependent columns and click .

The associations appear in the Associations section below.

• 
  
  • Do one of the following:

1. 
   
   1. 
      
      • To create only this one relationship, click Create and Close. The relationship is added to the specification and appears on the Application Relationship - Relationships tab.
      • To create additional relationships after this one, click Create. The relationship is added to the specification and appears on the Application Relationship - Relationships tab. The Create Relationship dialog box remains open to allow for additional relationships to be created.
   • To see the properties of an object, from the Objects List, right-click and select Properties. The Properties view appears.

   • Click the Relationships tab. This tab shows the relationships that have been created between objects and shows the associations made between columns in the parent object and columns in the dependent object.

     Note

     Optionally, do any of the following:

   • To add objects, click . The Objects tab appears. Follow the instructions above to add objects.
   • To add a relationship, click . The Create Relationship dialog box appears. Follow the instructions above to add a relationship.
   • To remove a relationship, select the relationship and click  . The relationship is removed from the Relationships tab.

   • To add an association between columns in a parent object and columns in a dependent object, select the relationship in the Relationships box, then either click  or right-click in the Associations box and select Add New Association. The Edit Relationship dialog box appears. The table displays all columns in each of the objects in the relationship.

     Note

     If desired, click to change the parent to a dependent or vice versa.

     Note

     To remove associations, select the association(s) and either click or right-click in the Associations box and select Remove Association(s). The associations are removed from the Relationships tab.

   • In the table, select the column name from the parent object and the column name from the dependent object that are to be associated.

     Note

     Only columns of the same type can be associated.

1. 
   
   • Click OK. Repeat as necessary to add additional associations between columns in the parent and dependent objects. Relationships are added to the Application Relationship - Relationships tab.
   • To see the properties of a relationship, from the Relationships table, right-click the relationship and select Properties. The Properties view appears.
   • Click the Visualization tab. This tab gives users a visual representation of the objects and relationships in the selected specification.

• 
  
  • To add objects, right-click and select Add Objects. The Objects tab appears. Follow the instructions above to add objects.
  • To add a relationship, select one or two nodes then right-click and select Create New Relationship. The Create Relationship dialog box appears. Follow the instructions above to add a relationship.
  • To remove a relationship, select the relationship then right-click and select Remove. The relationship is removed from the Relationships tab.

To edit a relationship or an association

Do one of the following:

1. On the Relationships tab:

   • Select the association and either click  or right-click in the Associations box and select Edit Associations.
   • Select the relationship and either click  or right-click in the Relationships box and select Edit Relationship.
   • On the Visualization tab, right-click the relationship line and select Edit Relationship.
   • The Edit Relationship dialog box appears.
     Do any of the following:

   1. • Edit the Relationship Name field by entering a different name for the relationship.
      • Click  to change the parent to a dependent or vice versa.
      • Select from the table the column name from the parent object and the column name from the dependent object that are to be associate

      Note

      Only columns of the same type can be associated. indicates columns that can be associated while indicates columns that cannot be associated.

2. Click Finish. When editing from the Relationships tab, the Relationships tab refreshes to reflect the changes.