|
|
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 Session Data using Dataset
From the left side panel of the HTTP Parameters screen, select the URL to be parameterized.
Click on the URL Rewriting tab which contains the value to be parameterized.
The URL text area field in the URL Rewriting tab will display the selected URL.
From the URL field, select a portion of the URL which contains the session identifier and click the Parameterize button.
A table is displayed which shows the selected session identifier in the Parameter Name column. To fill the Value column, click the list button in the Fetch Data From column. This will display a dropdown list with the various options to parameterize such as Dataset, Cookie, Text, Element, JavaScript, URL, Constant, Variable and Random Data.
From this dropdown list, choose the Dataset option 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 (if available) and 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, click 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/Edit Data Configuration screen.
In this screen, edit the desired values and click Save button. To insert the selected datasource in the Value column, click the Apply button.
Click the Save button to save the configured value.
During playback, the value in the specified dataset will be fetched and dynamically substituted for the selected session identifier.
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 Add button. |
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 field:
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.
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.
|
|