...
A data set is a subset of data records. The various data sets on a repository all tap into the same library of record types. For instance, if multiple data sets in a data repository use the record type "book," they will all access the same instance of the book record type. Each data set always has at least one record type.
SQL Data Set
The SQL Data Sets node contains SQL data sets, which are designed for parameterizing SQL Responders. They are automatically added when creating parameterized SQL responders from recorded database queries. Each added database data set will be labelled according to the name previously- provided for that database (via the Parasoft JDBC Driver).
This node will display only if SQL data sets are available in the given repository.
Double-clicking one of these SQL data set nodes will open the associated data editor.
For details on how to create SQL Responders that are parameterized from data repositories, see Creating SQL Responders from a Database Recording. For details on how to edit such SQL Responders, see Editing Data Stored in a Data Repository.
Record Type
A record type has a name, a certain number of columns (also known as fields), and a hierarchy defined. The scope of record types is at the repository level (for example, the same "book" record type definition applies across all data sets that use the "book" record type).
...
- Message parameterization: Using a repository data source, you can parameterize messages with sequences or elements with varying numbers of items. Sequences or elements that are of option type or of abstract/concrete schema types cannot be parameterized using repository data.
- At least one key column: Key columns are used for data source correlations within Message Responders (in the Data Source correlations tab). You can have multiple key columns (e.g., if you have 3 parameters in the data source correlation and want to parameterize each with a separate column from the repository, you would need at least 3 key columns).
- One row column: The row column is used to determine how SOAtest iterates through a data source. You must have exactly one row column if you will be using this data in SOAtest.