3.2.2 Data Sets

Abbreviations, used in manual:

QG - Quality Gates

 
What is a Data Set?

A Data Set could be based on a DB table, file or any source that returns data in a specific structure.  
The Data Set connects to the Data Source in order to get required data according to the conditions  defined in the Data Set. Different options are supported according to chosen Data Source type.

A Data Set could be created using 2 options:

1. As shared Data Set - could be used in one or many Tests for the whole project. Go to QG module -> in the left side menu choose My Projects section -> choose a Specific Project ->  go to Library section -> Data Sets section -> click "Add Data Set" button:

2. As internal Data Set - could be used only in the Test where it was created. Can be created from a Test: go to QG module -> in the left side menu choose My Projects section -> choose a Specific Project -> Tests section -> access needed existing Test or create a new one-> in Data Sets section click Add New button:

Note: When adding an internal Data Set, a rectangle with a + sign in the middle will appear in the Test Flow screen. Pressing twice on the rectangle itself, will open the Data Set in a Read-Only mode. Pressing once on the + sign, will open the Data Set in an edit mode, where you could create a new Data Set.
 

Creating a new Data Set:

There are several common fields for each Data Set type:

Name - suitable name for the Data Set.

Auto generate name - when checked => quilliup automatically creates a random name for the Data Set.
Data Source Name - choose the required Data Source from the list of Data Sources assigned to this specific Project.
Based on your selection, list of available entities (DB tables or files or ...) for data Set creation will be shown:


Description - short and informative Data Set description.

Tags - Data Set can be related to appropriate Tag(s).
Create Variable - to create a variable please see refer related manual: Variables

Set Variable - within each Data Set, it is possible to modify the value of a variable already used in this specific Data Set.

Several Data Set types could be created. Please see all the related manuals:

1. Data Sets based on a DB table(s): RDBMS Data Sets

 

2. Data Sets based on flat files (*.csv, *.txt,. ..): Files Data Sets

 

3. Data Sets based on QlikView: QlikView Data Sets

4. Data Sets based on Qlik Sense: Qlik Sense Data Sets

5. NoSQL Data Sets based on NoSQL Data Sources (MongoDB, Cassandra DB): NoSQL Data Sets

6. API Data Sets based on API calls data: API Data Sets

7. BigQuery Data Sets: BigQuery Data Sets

8. Data Sets based on files from Amazon S3: Amazon S3 Data Sets

 

Available operations in the Data Set grid:

Bulk Operations - allow to mark a few Data Sets at a time and to Delete, Update or Copy them together.

Deploy/Deploy All - allows to Deploy selected Data Sets/all the Data Sets in the page from one environment to another.

A Data Set(s) can also be Edited/Copied/Deleted by clicking relevant icons in each row.