Chat now with support
Chat with Support

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

Create Oracle Connections

Benchmark Factory allows you to create an Oracle connection using an Oracle client, direct connecton, or ODBC.

To create an Oracle connection

  1. Click in the main toolbar. The New Connection dialog opens.
  2. Select Oracle 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 tab

     

    User/Schema

    Schema to which you want to connect.

    Password

    Password for schema to which you want connect.

    TNS or Direct tab

    TNS—Allows you to connect to a database using your TNS names file.

    • Databases—Allows you to connect to a database using your TNS names file. Select a database from the list.

    Direct—Allows you to connect to a database using Host, Port, Server name or SID.

    Connect as

    Type of connection you connect to the database with: Normal, SYSDBA, or SYSOPER.

    Connect Using

    Select the Oracle Client to use for this connection.

    This specification is used by Benchmark Factory Agents running on Windows only.

    Make this the BMF default home

    Selecting this check box sets this as the default client for Benchmark Factory.

    Connection Name

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

    Data Source Name

    Select a data source from the drop-down list.

    Click Add DSN to create a new data source.

    User Name

    Enter the user name to use for this connection.

    Password

    Enter the password to use for 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 Oracle connection, you can collect database and host server information using the Edit Connection dialog. See Environment Information for more information.

Miscellaneous

Select the Miscellaneous tab of the Connection dialog to specify options for flushing cached data. Review the following for additional information.

Note: The Miscellaneous tab is only available when creating an Oracle Native connection. For an Oracle ODBC connection, the default options specified in Edit | Settings | Oracle are used.

Database Flush  
Flush data buffer caches at start of each test iteration

Select to clear data buffer caches between iterations.

Note: To perform this action, the Oracle database account must have certain privileges. In Oracle 10g or later, the ALTER SYSTEM privilege is required.

Flush shared pool at start of each test iteration

Select to clear shared pool between iterations.

Note: To perform this action, the Oracle database account must have the ALTER SYSTEM privilege.

Note: Cached data can improve performance, so selecting one or both of these options can prevent cached data from affecting subsequent iterations.

Performance Counters

Select the Performance Counters tab of the Connection dialog to add additional performance counters to a connection. See Performance Counters Tab for more information.

Clustering

Select the Clustering tab of the Connection dialog to enable clustering. See Oracle Clustering Tab (Connections) for more information.

Statistics

Select the Statistics tab of the Connection dialog to specify statistics collection options for this connection. See Oracle Statistics Tab (Connections) for more information.

Create PostgreSQL Connections

Benchmark Factory allows you to create a PostgreSQL connection using a native connection or ODBC connectivity.

To create a PostgreSQL native connection

  1. Click in the main toolbar to open the New Connection dialog.
  2. Select PostgreSQL from the Database Type drop-down list.
  3. Select the Native tab.
  4. Enter the following connection information.

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

    Native Tab  

    Server name

    Enter the name or IP address of the server.

    Port

    Enter the port number. The default is 5432.

    User name

    Enter the user name to use for this connection.

    Password

    Enter the password associated with the user name.

    Database

    Select a database. Benchmark Factory creates a temporary connection and displays available databases in the drop-down list.
    Connection Name Enter a name to use to identify this connection in the My Connections pane.
    Options Click Options to specify timeout and reconnect options. See Connection Timeout and Reconnect Options.
  5. Click Create Connection to save the connection information and connect.
  6. After creating a new PostgreSQL connection, you can collect database information using the Edit Connection dialog. See Environment Information for more information.

To create a PostgreSQL ODBC connection

  1. Click in the main toolbar to open the New Connection dialog.
  2. Select PostgreSQL from the Database Type drop-down list.
  3. Select the ODBC tab.
  4. Enter the following connection information.

    ODBC Tab  

    Data Source Name

    Select a data source from the drop-down list.

    Click Add DSN to create a new 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 Options to specify timeout and reconnect options. See Connection Timeout and Reconnect Options.
  5. Click Create Connection to save the connection information and connect.
  6. After creating a new PostgreSQL connection, you can collect database information using the Edit Connection dialog. See Environment Information for more information.

Performance Counters

Select the Performance Counters tab of the Connection dialog to add additional performance counters to the connection. See Performance Counters Tab for more information.

Create SAP Connections

Benchmark Factory allows you to create a native SAP database connection.

To create an SAP database connection

  1. Click in the main toolbar. The New Connection dialog opens.
  2. Select SAP 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  

    Server Name

    The name or the IP address of the server.

    Database

    The name of the database to which you want to connect.

    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 SAP 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 SQL Server Connections

Benchmark Factory allows you to create a connection to a Microsoft SQL Server database using native database provider connectivity or ODBC connectivity.

To create a SQL Server native connection

Note: Beginning with Benchmark Factory 8.1, a SQL Server client is no longer distributed along with Benchmark Factory. To create a SQL Server native connection, ensure a SQL Server client is installed.

  1. Click in the main toolbar to open the New Connection dialog.
  2. Select Microsoft SQL Server from the Database Type drop-down list.
  3. Select the Native tab.
  4. Enter the following connection information.

    Native  

    Server Name

    Enter the name or the IP address of the server.

    Click the drop-down arrow to retrieve a list of servers running SQL Server that are currently active on the network.

    Authentication

    Select the type of authentication to use.

    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 Options to specify timeout and reconnect options. See Connection Timeout and Reconnect Options.

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

  5. Click Create Connection to save the connection information and connect.
  6. After creating a new SQL Server connection, you can collect database and host server information using the Edit Connection dialog. See Environment Information for more information.

To create a SQL Server ODBC connection

  1. Click in the main toolbar to open the New Connection dialog.
  2. Select Microsoft SQL Server from the Database Type drop-down list.
  3. Select the ODBC tab.
  4. Enter the following connection information.

    ODBC tab  

    Data Source Name

    The name of the MS SQL Server 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 Options to specify timeout and reconnect options. See Connection Timeout and Reconnect Options.

    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.

  5. Click Create Connection to save the connection information and connect.
  6. After creating a new SQL Server connection, you can collect database and host server information using the Edit Connection dialog. See Environment Information for more information.

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

SQL Server DB-Library connection (obsolete)

The SQL Server DB-Library connection is available in the 32-bit version of Benchmark Factory. Before using this connection type, please review the following considerations.

  • For connections to SQL Server 2005 (or later), the SQL Server native connection or ODBC connection is preferred. Microsoft SQL Server is no longer including the DB-Library for database client connectivity.
  • The SQL Server DB-Library connection cannot be used to connect to SQL Server 2014 or later.

Miscellaneous

Select the Miscellaneous tab of the Connection dialog to specify options for flushing cached data. Review the following for additional information.

Note: The Miscellaneous tab is only available when creating a SQL Server Native connection. For a SQL Server ODBC connection, the default options specified in Edit | Settings | SQL Server are used.

Database Flush  
Clean data buffer and procedure caches at start of each test iteration

Select this option to instruct Benchmark Factory to clear cached data between iterations. Cached data can improve performance, so selecting this option can prevent cached data from affecting subsequent iterations.

Notes:

  • This option is only applicable to SQL Server 2005 or later.
  • To perform this action, the SQL Server database account must have the sysadmin fixed server role.

Performance Counters

Select the Performance Counters tab of the Connection dialog to add additional performance counters to a connection. See Performance Counters Tab for more information.

Related Documents