Parameterizing Get Post Data Using Dataset

• How do I get to the Parameterization screen?

• Steps to Parameterize get/post data using Dataset option

• Fetching Data from Database

• Fetching Data from CSV file

• Fetching Data from XLS file
  

How do I get to the Parameterization screen?

Suite Manager >> Continue with Web Performance Testing >> Select load test from left-side tree view >> Click 'Edit' link under HTTP Parameters from the right panel.

Steps to Parameterize Get/Post Data using Dataset

1. From the left side panel of the HTTP Parameters screen, select the URL to be parameterized.

2. Click any of the required tabs such as Parameters, Cookies or Mime which contains the value to be parameterized.

3. From the row which contains the value to be parameterized, choose the list component from the Fetch Data From column. The 'Fetch Data From' column displays options such as Dataset, Cookie, Text, Element, Javascript, Constant, URL, Variable and Random Data.

4. From the dropdown list, choose the option as Dataset to fetch the values from a database or a CSV file or XLS file. This will display the View Data Configuration screen.

5. In this screen, you can select the already configured datasources. Click the Apply button to insert the data configuration in the Value column.

6. To add a new datasource, click the Add button. This will display the Add/Edit Data Configuration screen.

7. In this screen, select the datasource type such as database or csv. Enter the new datasource name in the DataSource Name field. This should be unique. If an existing name is given, the values configured are modified for the existing datasource.

8. Based on the selected datasource type (CSV or Database or Excel), configure the appropriate values as given in Fetching Data from Database or Fetching Data from CSV or Fetching Data from XLS file.

9. After configuring the values, choose the Save button to save the configurations and choose the Apply button to insert the data configuration in the Value column.

10. To edit a datasource, in the View Data Configuration screen, select the datasource and click the Edit button. This will display the Add/View Data Configuration screen.

11. In this screen, edit the desired values and click the Save button. To insert the selected datasource in the Value column, click the Apply button.

Fetching Data from Database

To fetch data from a database, select the datasource type as Database and enter the appropriate values for the following fields:

Fetching Data from CSV File

To fetch data from CSV file:

1. Select the datasource type as CSV and enter the appropriate values for the following fields:

2.  Select or create the csv file name. The CSV files displayed in the combo and the newly created csv files are placed in the server in <QEngine_Home>/projects/<Suite_Name>/dataset directory.

3. Enter the column index or column name value from where the CSV value has to be fetched. Please note that the column index starts with 1.

4. Click the Apply button.

1. Select the datasource type as Excel (XLS) and enter the appropriate values for the following fields:

2. Select the XLS file from the Excel File Name combo if the xls file you wish to use is already present in the combo, else import the xls file in to QEngine using "Import" link present below the combo.

3. Provide Sheet Name or Sheet Index of the XLS sheet where the test data is present.

• Sheet Name - is the sheet name provided in the XLS file

• Sheet Index - is the index of the sheet where the data is present in the XLS file. The Sheet index is starts from 1.

4. Enter the column index or column name , from where the data for the test needs to be fetched in XLS file.

5. Click the Apply button.