Data Model/Relationships and Schema

The Data Model/Relationships and Data Model/Schema pages allows user to

  • manage relationships for tables, views and stored procedures

  • view database schema

List relationships

  1. In browser, log in to AgilePoint NX as a user with Data Model permission.

  2. Click Settings, then Data Setup then Data Model in the left menu.

  3. Select the Setting Level: either System or a specific tenant.

  4. Select Relationships in the Middle Panel. (Fig. 49)

    ../_images/Data_Model_Relationships_Location.png

    Fig. 49 Data Model - Relationships

  5. Relationships of all visible data sources from all connections will be displayed.

  6. By default, only the first page with 10 items are displayed. To see more, either use the next page icon

    ../_images/Data_Model_Next_Page_Icon.png

    Fig. 50 Data Model - Next Page

    or select a larger number in Items per page box.

    ../_images/Data_Model_Items_per_page.png

    Fig. 51 Data Model - Items per page

Search for relationships

The Search box at the top allows user to search for specific relationships.

  1. ../_images/Data_Model_Relationships_Search_by_Elements.png

    Fig. 52 Data Model - Search Relationships by element

    Select a specific element to search for in the dropdown on the left of the Search box. Default is All.

  2. Type a partial name and click the search icon (🔍).

  3. Only the matching relationships will be displayed.

Add relationship

  1. ../_images/Data_Model_Relationships_Add_New_button.png

    Fig. 53 Data Model - Add New Relationship

    Click the Add Relationship button at the top. (Fig. 53)

  2. A new empty row will appear at the first line.

  3. Select the elements of the relationship from dropdown boxes.

    User must select Connection Name, then Data Source, then Data Source Field in that order for the dropdown boxes to populate conveniently.

    User should input the positionID to define the priority of each relationship when querying data. (This option is available from version 2.16.0).

  4. Continue to add more relationships.

  5. Click the Save button at the top.1w`

    Relationships that already exists or have errors will be highlighted and not saved. (Fig. 54 and Fig. 55)

    ../_images/Data_Model_Relationships_Existed_Error.png

    Fig. 54 Data Model - Relationship Already Exists

    ../_images/Data_Model_Relationships_Data_Type_Error.png

    Fig. 55 Data Model - Data Type Error

Note

Only single-column relationships are supported in Data Model. Multiple-column relationships are supported in Report Designer.

Copy relationship

The copy feature help users to save efforts in adding and editing relationships.

  1. Click the Copy icon (that looks a bit like this ❐) of each relationship to copy its details to a new line beneath.

  2. Edit the new line to make a new relationship.

  3. Continue for more relationships.

  4. Click the Save button at the top.

Edit relationship

User can freely edit any relationship in a page and save them.

Delete relationship

User can only delete relationships newly created in Data Model. Relationships originally created from physical database cannot be deleted, their delete icon will be disabled.

  1. Click the Delete icon (x) of each relationship.

  2. Click OK in the confirmation pop-up.

  3. The relationship is deleted.

Warning

The Cancel button at the top will have no effect in this case.

View the schema

To be updated.