...
Click on the Models tab and choose a repository to interact with the data sets contained in the repository.
Data all sets within a repository are represented as diagrams in the Models tab of Test Data Assistant.
...
Data sets are high-level organizational structures within a repository. A data set is identified by a record type. In the following image, the "getItemById" data set is a "getItemByIdResponse" type of record.
Keys and Members
A data set contains keys and members. Keys are unique data fields that can be called by a tool so that responses with all the data in the row can be used in a test. Members are the data value fields. In the following image, "IMDBID" is a key and "Title" and "ProductionBudget" are members.
A list of members is represented as a stack. If the generation settings for a member has been configured, a gear icon will appear on the member label (see Working with Data Models).
Members can also represent a record type. In the following image, the dark boxes labeled "Results" are members of the "Results" record type (circle), but they also represent other record types ("addResponse", "subtractResponse", and "divideResponse").
Relationships within a Model
Relationships between objects are represented by lines and arrows. Clicking on an object opens a sidebar the provides additional information about the data structure. In the following model, the record type "test" is highlighted and it's its relationships are summarized in the sidebar.
The arrow to the record type from the "test" data set indicates that the record type is referenced by the data set.
...
Additionally, the record type "getItemByTitleResponse" is referenced by the data set and appears in the sidebar under the Value Types label.
Foreign key constraints are represented by a dotted line. In the following model, the key member "IMDBID" is a foreign key of the member "Title." A foreign key is a field in one data set that uniquely identifies a field in another data set. See Inferring Data Constraints for information about foreign keys.
SQL Data Sets
...
In the following model, the "ParabankSQL" SQL data set references the "SQL9" template by way of the "SELECT i..." member.
The member containing the statements is truncated to fit in the icon, but you can click on the member to view details in the sidebar.
You can also click on the SQL template to view references, the parameters in the template, and results of the SQL query.
SQL data sets also have the concept of a result set. The result set is a representation of the columns returned by the SQL template. Result sets are rendered as both a member of the SQL template and as a record type-like object–similar to how templates are rendered as two objects in the model. Clicking on the ResultSet# object shows the member columns in the sidebar.
See SQL Responder for additional information about recording and virtualizing SQL databases and using the data in your testing environments.
Navigating Models
Click in the search field to look for specific members, SQL templates, and other components in the data set. Begin typing to filter search results.
Objects that represent data sets link to the data table in a new tab. Clicking on a link opens the table data view in a new tab.
