LoadRunner Stuff

VuGen provides a wizard that guides you through the procedure of importing data from a database. In the wizard, you specify how to import the data—create a new query via an MS Query or by specifying an SQL statement. After you import the data, it is saved as a file with a .dat extension and stored as a regular parameter file.

To begin the procedure of importing a database, click Data Wizard in the Parameter List dialog box (Vuser > Parameter List). The Database Query Wizard opens.

VuGen allows you to import data from a database for use with parameterization. You can import the data in one of two ways:

• Creating a New Query
• Specifying an SQL Statement

To create a new query using Microsoft’s Database Query Wizard:

• Select Create query using Microsoft Query. If you need instructions on Microsoft Query, select Show me how to use Microsoft Query.
• Click Finish. If Microsoft Query is not installed on your machine, VuGen issues a message indicating that it is not available. Install MS Query from Microsoft Office before proceeding.
• Follow the instructions in the wizard, importing the desired tables and columns.
• When you finish importing the data, choose Exit and return to the Virtual User Generator and click Finish. The database records appear in the Parameter Properties box as a data file. To edit and view the data in MS Query, choose View data or edit in Microsoft Query.
• Set the data assignment properties as described in the section “Setting Properties for File Type Parameters”.

If you are proficient in SQL, you can manually specify an SQL statement to retireve data for a parameter using the folllowing steps:

• Select Specify SQL Statement. Click Next.
• Click Create to specify a new connection string. The Select Data Source window opens.
• Select a data source, or click New to create a new one. The wizard guides you through the procedure for creating an ODBC data source. When you are finished, the connection string appears in the Connection String box.
• In the SQL box, type or paste an SQL statement.
• Click Finish to process the SQL statement and import the data. The database records appears in the Parameter Properties box as a data file.
• Set the data assignment properties as described in the section “Setting Properties for File Type Parameters”.

After creating table or file data, you set the assignment properties. The properties specify the columns and rows to use, and whether to use the data randomly or sequentially. You set the properties separately for the File and Table type parameters.