|
|
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
From the left side panel of the HTTP Parameters screen, select the URL to be parameterized.
Click any of the required tabs such as Parameters, Cookies or Mime which contains the value to be parameterized.
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.
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.
In this screen, you can select the already configured datasources. Click the Apply button to insert the data configuration in the Value column.
To add a new datasource, click the Add button. This will display the Add/Edit Data Configuration screen.
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.
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.
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.
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.
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.
To fetch data from a database, select the datasource type as Database and enter the appropriate values for the following fields:
|
Field Name |
Value |
Example |
|---|---|---|
|
Database |
Select the name of the database if available or configure database properties by clicking the Configure Database link. |
ORACLE |
|
Connection URL |
The connection URL is a non-editable field which gets displayed based on the selected database or based on the configured details on choosing the Configure Database link. |
jdbc:oracle:thin:@HOST_NAME:PORT_NUMBER:orcl |
|
UserName |
Enter the username to connect to the database |
scott |
|
Password |
Enter the password to connect to the database |
tiger |
|
Table Name |
Enter the table name from where the value has to be fetched. |
employee |
|
Column Index (Or) Column Name |
Enter the column index value or column name from where the values has to be fetched. |
emp_name or 1. |
To fetch data from CSV file:
Select the datasource type as CSV and enter the appropriate values for the following fields:
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.
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.
Click the Apply button.
Select the datasource type as Excel (XLS) and enter the appropriate values for the following fields:
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.
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.
Enter the column index or column name , from where the data for the test needs to be fetched in XLS file.
Click the Apply button.
|
|