Chat now with support
Chat with Support

Benchmark Factory for Database 8.4 - 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

Create SAP Connections

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

Create SAP native connection need to configure sql.ini file.

To configure sql.ini file

The sql.ini file contains information about the network locations of servers. Open Client uses the network information provided by the query line of a sql.ini file entry to connect to the server. By default, Open Client and Open Server products look for sql.ini in the %SYBASE%\ini directory.

The following provides an form of a sql.ini file entry:

[SERVERNAME]

service_type=driver,address

Description  

Server Name

Enter the name of the server

service_type

Enter the type of connection.

driver

Enter the name of the network driver to use for the connection.

address

Enter the network address for the specified server.

For detailed information on the sql.ini file, see http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc35830.1550/html/pccfg/X99417.htm

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.

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

To create a SAP ODBC connection

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

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.

  

Edit and Manage Connections

To edit a connection, use the My Connections pane or click the Edit Connections button in the main toolbar. Both the My Connections pane and the Edit Connections dialog provide a list of your currently-defined connections. Use either of these interfaces to view or modify information for each connection.

To learn how to create a new connection, see Benchmark Factory Connections.

To edit a connection

  1. Use one of the following methods to edit a connection:

    • Click in the main toolbar. Select a connection and click in the Edit Connections dialog.
    • Select View | My Connections. In the My Connections pane, select a connection and click .
  2. The Connection dialog for the selected connection opens. Use the DB Connection tab to update the connection password or other connection information.
  3. Select from among the other tabs to add or modify other properties associated with the connection. The following tabs are available (depending on the connection type).

Manage Connections

  • Click Edit Connections. In the Edit Connections dialog, use the following toolbar buttons to manage connections.

    Open the New Connection dialog to create a new connection.
    Remove the selected connection.
    Open the Connection dialog for the selected connection. Use this dialog to view or edit connection properties.
  • Select View | My Connections. In the My Connections pane, use the following toolbar buttons to manage connections.

    Create a new connection.
    Edit the selected connection.
    Duplicate the selected connection.
    Delete the selected connection.

  

Related Topics

Timeout and Reconnect Options

You can specify timeout and reconnect options when you are creating a new connection. You can also specify these options at any time for an existing connection.

To specify timeout and reconnect options

  1. In the New Connection dialog, after entering connection information, click Options.
  2. Specify the following options.

    Timeout  

    Time

    The maximum amount of time Benchmark Factory will try to log on to the system-under-test. If this amount of time is reached, Benchmark Factory will return an error.

    Infinite timeout

    Prevents the logon to the system-under-test from timing out and returning an error.
    Reconnect  

    Enable Reconnect

    Enables Benchmark Factory to attempt to reconnect to the system-under-test if the connection is lost.

    Number of reconnect attempts

    The number of times to attempt to reconnect before aborting.

    Time to wait between reconnect attempts (seconds)

    How long to wait before attempting to reconnect.
  3. Click OK.

To specify timeout and reconnect options for an existing connection

  1. Click in the main toolbar.
  2. Select the connection and click .
  3. Then click Options in the Connection dialog.

  

Related Topics

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating