Configure new relationships

  1. On the canvas, click and drag between entities to create a relationship.
    The order in which you click and drag defines the relationship.
    Completing this step expands the Relationship Configuration panel.
  2. If the input source contains a field with the relationship label, set Relationships provided at runtime to YES.
  3. In the Relationship label box, type the name of the relationship label.
    If you set Relationships provided at runtime to YES in the previous step, in the Relationship label field drop-down list box, click the input field that contains the relationship label.
  4. In the Connections drop-down list box, click the connection that you want to use for the relationship.
    The list box shows a connection for each configuration defined for an entity type.
  5. If it applies, check the Allow more than one relationship based on a unique ID check box, and select the input field that contains the unique ID.
  6. On the Properties tab, in the Update mode drop-down list box, choose how to update existing property values.
    For more information, see Update mode.
    Note: This setting is unavailable when Write mode is set to Initial load. For more information, see Write mode.
  7. On the Properties tab, in the Source field column, click the Add property drop-down list box to define properties for the relationship connection.
    To change the name for any property, enter the new name in Property name column.
  8. Optional: On the Conditions tab, you can add conditions that control whether to create a relationship between a source and a target entity.
    For more information, see Conditions.
  9. To add additional connections, repeat steps 4 through 7.
  10. Click OK.