Chat now with support
Chat with Support

Benchmark Factory for Database 9.0 - User Guide

Welcome to Benchmark Factory What's New in Benchmark Factory Additional Resources Overview of Benchmark Factory Benchmark Factory Components Licensing Getting Started - the Benchmark Factory Workflow Agents Create and Edit Connections Create and Edit Tests and Jobs
Jobs View Pane Job Wizards Quickstart: Create a New Job Edit a Job Industry Standard Benchmark Tests Capture and Replay a Workload Artificial Test for Desired Effect Scalability Tests Custom Tests Create/Delete Benchmark Objects Execute External File Test Options for Create Objects Test Options for Transactions Job Setup Options Use Global Search/Replace Save Job as BMF Script Copy Test to Replay, Mix, Goal, or Scalability Test
Benchmarks How Do I... Settings Test Results and Run Reports BFScripts Repository Troubleshooting The Benchmark Factory REST API Appendix About Us Adding Virtual Users System/Upgrade Requirements/Supported Databases Shortcut Keys

BFScript Wizard

The Benchmark Factory scripting feature known as BFScripts allows you to insert randomized data into the load testing process. You can use BFScripts when you add SQL transactions. See Transactions Tab for more information.

Script-enabled fields have a yellow background. A field has scripting capabilities if the field's right-click menu includes the BFScript Wizard option. The BFScript Wizard is a quick and easy way to use Benchmark Factory scripts. The BFScript Wizard provides you with a list of built-in script functions, grouped by category, from which to select. Each script function has a short description included, and if applicable, the function parameters.  See About Scripts for an overview of BFScripts.

There are two features in Benchmark Factory that assist you when using scripting capabilities.

  1. Use one of the following methods to open the BFScript Wizard:
    • From within a script-enabled field (yellow background), right-click and select BFScript Wizard.

    • In the SQL Statement tab, click .
  2. Select a category in the left pane to display BFScripts (functions) in the right pane.

  3. Select a BFScript name (function).
  4. If the script requires parameters, click Next and enter the required parameters.
  5. Click Finish to enter the script in the field.

Script Assist

  1. When entering a SQL statement, enter $BF. Script Assist automatically displays a list of scripts from which you can select.

  1. Select the desired script.
  2. Press ENTER to enter the script in the field.
  3. Enter parameters as required.

 

Using Scripts in Username and Password Fields

You can use BFScripts in a Connection dialog. BFScripts are enabled in the User Name and Password fields. You can also add BFScripts to the Data Source Name field.

Using Scripts in the Username and Password Fields

You can use BFScripts in the User Name and Password fields in the Connection dialog. In Benchmark Factory, script-enabled fields have a yellow background. This includes the User Name and Password fields in the Connection dialog.

You can use BFScripts in the Connection dialog in order to login using a variety of users and associated passwords. If scripts are to be used in a Password field, the password must be contained entirely in a script, such as $BFConcat.

For example, $BFConcat("USER",$BFUserID(),"x") will generate "USER1x" for Virtual User 1, "USER2x" for Virtual User 2, etc.

The example above can be used to log in each virtual user with a unique username and password.  Prior to implementing this example, users should be created in the test system with a username and password containing the virtual user number that will be used.

Using Scripts in the ODBC Data Source Name Field

You can add BFScripts to the Data Source Name field in the ODBC Connection dialog. This allows you to have individual agents test against a different server.

To add BFScripts to the Data Source Name

  1. Click within the Data Source Name field (ODBC Connection dialog).
  2. Enter the desired script name.

 

Dates and Numbers

$BFCreditCardExp

Description:

Generates a credit card expiration date.

Parameters:

N/A

Syntax:

$BFCreditCardExp()

 

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating