Benchmark Factory for Database 8.2.1 - User Guide

Getting Started Licensing Overview of Benchmark Factory Benchmark Factory Components Agents Create and Edit Connections Create and Edit Tests and Jobs Test Results and Run Reports Troubleshooting The Benchmark Factory REST API

Connections Overview

Benchmark Factory allows you to connect to a variety of different databases. To learn how to create a connection for a specific database, see one of the following topics:

Using BFScripts in the Connection Dialog

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 for an ODBC connection. See Using Scripts in the Connection Dialog for more information.

For an overview of BFScripts, see About Scripts.

Create IBM DB2 CLI Connections

Benchmark Factory allows you to create a native connection to an IBM DB2 database.

To create an IBM DB2 CLI connection

  1. Click in the main toolbar. The New Connection dialog opens.
  2. Select IBM DB2 CLI from the drop-down list.
  3. Enter the connection information. Review the following for additional information:

    Note: BFScripts have been enabled on the User Name and Password fields.

    Native  

    Database Alias

    Enter the database name.

    User Name

    Enter the user name to use for this connection.

    Password

    Enter the password associated with the user name.

    Connection Name

    Enter a name to use to identify this connection.

    Options

    Click to specify timeout and reconnect options. See Connection Timeout and Reconnect Options.
  4. Click Create Connection to save the connection information and connect.
  5. After creating a new DB2 connection, you can collect database and host server information using the Edit Connection dialog. See Environment Information for more information.

Performance Counters

Benchmark Factory allows you to add additional performance counters to a connection. See Performance Counters Tab for more information.

Create MySQL Connections

Benchmark Factory allows you to create a connection to a MySQL database using either a native database provider or ODBC connectivity.

To create a MySQL connection

  1. Click in the main toolbar. The New Connection dialog opens.
  2. Select MySQL from the drop-down list.
  3. Select either the Native or ODBC tab, depending on the type of connection you want to create.

    Then enter the connection information. Review the following for additional information:

    Note: BFScripts have been enabled on the User Name and Password fields. In addition, BFScripts have been added to the Data Source name field in the ODBC Connection dialog.

    Native  

    Hostname

    Enter the name or IP address of the server.

    Port

    Enter the port number. The default is 3306.

    Username

    Enter the user name to use for this connection.

    Password

    Enter the password associated with the user name.

    Database

    Select the database to which you want to connect. Benchmark Factory creates a temporary connection and displays the available databases in the drop-down list.
    ODBC  

    Data Source Name

    The name of the MySQL ODBC data source.

    User Name

    Enter the user name to use for this connection.

    Password

    Enter the password associated with the user name.

    Connection Name

    Enter a name to use to identify this connection in the My Connections pane.

    Options

    Click to specify timeout and reconnect options. See Connection Timeout and Reconnect Options.
  4. Click Create Connection to save the connection information and connect.
  5. After creating a new MySQL connection, you can collect database and host server information using the Edit Connection dialog. See Environment Information for more information.

Performance Counters

Benchmark Factory allows you to add additional performance counters to a connection. See Performance Counters Tab for more information.

Create ODBC Connections

Benchmark Factory supports almost all databases that you can connect to using an ODBC 3.0 or later driver. Create an ODBC connection to access these databases.

To create an ODBC connection

  1. Click in the main toolbar. The New Connection dialog opens.
  2. Select ODBC from the drop-down list.
  3. Enter the connection information. Review the following for additional information:

    Note: BFScripts have been added to the Data Source name field in the ODBC Connection dialog. BFScripts have been enabled on the User Name and Password fields.

    ODBC  

    Data Source Name

    The name of the ODBC data source.

    User Name

    Enter the user name to use for this connection.

    Password

    Enter the password associated with the user name.

    Connection Name

    Enter a name to use to identify this connection in the My Connections pane.

    Options

    Click to specify timeout and reconnect options. See Connection Timeout and Reconnect Options.
  4. Click Create Connection to save the connection information and connect.

Note: To review or modify a connection, click Edit Connections in the main toolbar. Select a connection and click .

Performance Counters

Benchmark Factory allows you to add additional performance counters to a connection. See Performance Counters Tab for more information.

Related Documents