Last modified on July 24, 2020.

Why use databanks in tests?

By default, LoadNinja simulates script events by using hard-coded parameter values, the ones you specified during script recording or editing.

To get larger coverage and to check how your web application works with different input values, you need to associate a databank (a file containing the data you want to input) with a script. LoadNinja will read it row by row, and will run test commands for each row in that databank. Such tests are called data-driven load tests.

Databank formats

  • The databank must be a CSV or TXT file, with either commas or tabs as a value delimiter. The first line may contain column headers.

    If a value contains a comma, you need to add quotes. If a value contains a quote, you need to duplicate it.

  • In order for LoadNinja to use the databank, the latter should not contain cells with empty values.

  • If you have column headers in the first row of the databank, then the number of values in each of subsequent rows should not exceed the number of headers.

    Show Example

Associate a databank with a script

1. Prepare the databank

Create a .csv or .txt file with the desired data, using either commas or tabs as value delimiters. Use any text editor to create the file. Many spreadsheet applications such as Microsoft Excel, Numbers, and LibreOffice Calc also export data to CSV.

Tip: We recommend that the first line contains descriptive column headers. In this case, the test will display the column names rather than indexes (1, 2, …).

2. Record a script

Open an existing script from your project on the Projects > [Project] > Web Tests tab.

If you do not have a script yet, record it. Replay the recorded test once to make sure it works correctly.

3. Import a databank
  1. In the script recorder, select Add > Databank on the toolbar:

    Upload Databank

    Click the image to enlarge it.

  2. Click Browse and select one or multiple .csv or .txt files from your device you want to use as databanks.

    To remove the file you added accidentally, click next to the file in the list.

    Import Data Bank

    Click the image to enlarge it.

    Click Next: Define File Format to proceed.

  3. In First row contains, specify whether the first row of each file you have attached should be treated as a header or a data row. In the Column delimiter column, select the symbol that separates columns within your databank.

    Import Data Bank: Structure

    Click the image to enlarge it.

    Click Next: Review Import. LoadNinja will try reading data from your files.

  4. LoadNinja will display a preview of the data. If the data does not look right, click Back and change the parsing settings.

    Import Data Bank: Preview

    Click the image to enlarge it.

    If LoadNinja loaded data correctly, go to the next page by clicking Next: Map Data to Script.

  5. On the next page, map column values to test commands in your script. LoadNinja will locate parameters within the test and list them.

    To command LoadNinja to use a databank for replacing parameter values, do the following for each input event:

    • In the Map file column, select a file to use as the databank in the Map file column for a parameter.

    • In the Map column column, select the databank column to take values from during the playback.

    In both these cases, select No Mapping to skip this setting and use the hard-coded recorded value during the playback.

    Tip: To change these mappings later, click # databank(s) in the script recorder.

    LoadNinja will show a preview of the item in the first data source’s row in the rightmost column:

    Import Data Bank: Map Values

    Click the image to enlarge it.

    To learn how to map values in the script recorder, see below.

  6. Click Next: Save Mapping.

LoadNinja will upload your data file to the cloud and update the test. Events that use values from a databank will have the corresponding label:

A script event that uses a databank
Note: Databanks are not shared among scripts. To use the same databank in another script, associate it with that script separately.

How it works in LoadNinja

To create a data-driven load test in LoadNinja, attach databanks to individual scripts that your load scenario will run. Then, map databank columns to event parameters as explained above.

LoadNinja supports this type of parameterization for the Keyboard Input events, Select Input events, and web page URLs.

During the load test execution, each script will typically run several times. For each iteration, LoadNinja will pick a databank row and insert column values from this row into event parameters:

Data-driven testing with LoadNinja: Using data rows in test iterations

Click the image to enlarge it.

How LoadNinja picks values from the databank

By default, LoadNinja picks databank rows randomly. To change this behavior, go to the script recorder  Settings and change the value of Run Databank Rows:

Run Databank Rows setting

Click the image to enlarge it.

Possible options are —

Value Description
Random Default value. LoadNinja will pick random data rows from the databank for each iteration and each virtual user.
During the load test run, there is a possibility that multiple users will use the same data at the same time.
Depending on the number of iterations and the number of rows, some rows are used more or less frequently than others. If the number of iterations is significantly larger than the number of rows, each row will be used approximately the same number of times.
Sequential For each virtual user, LoadNinja will pick data sequentially for each iteration, that is, the first iteration of a virtual user will use the first databank row, the second iteration will use the second databank row, and so on.
Each virtual user processes the databank on its own, so it means that multiple virtual users may be using the same data at the same time.
Unique At any given time instance, LoadNinja will pick unique data rows for virtual users, so they will never use the same data at the same time.
The number of databank rows should be equal to or greater than the number of virtual users that will run this load test.

Change event-to-data column mappings

To change the databank columns used for events, use the # databank(s) dialog or edit the event parameters directly.

  1. Click # databank(s) on the toolbar.

    Modify Databank
  2. Click Edit data mapping.

  3. Configure the mapping settings, as you do for the new databanks.

  4. Click Save mapping.

Currently, LoadNinja supports this feature only for Keyboard Input events. For parameterizing URLs and selection inputs, consider creating a mapping while uploading a databank.

  1. In the list of test steps, locate the Keyboard Input event you want to parameterize.

  2. Expand the event parameters and click .

    Mapping values: Start

    Click the image to enlarge it.

  3. Select or clear the Use Dataset check box, as you see fit.

  4. If Use Databank is selected, select the databank column to take the parameter value from.

  5. Click Submit.

Attach more databanks

A script can have up to 4 databanks attached to it. LoadNinja stores the databanks along with the script that uses them.

To associate an extra databank with the script, do the following:

  1. Click # databank(s) on the toolbar (that button appears after you associated a databank with a script).

    Modify Databank
  2. (Optional) Remove the obsolete databanks by clicking near them.

  3. Click Import another databank.

  4. Click Browse..., locate the new databank and click Next: Define File Format.

  5. Configure the importing settings, as you do for the new databanks. Click Next Review import.

  6. Check the preview. Click Next: Map data to script

  7. If the new databank has a different set of columns, update the event-to-column mappings as required. Click Next: Save mapping.

See Also

LoadNinja Documentation

Highlight search results