Benchmark Factory for Database 8.3 - User Guide

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:

• Create IBM DB2 CLI Connection
• Create MySQL Connection
• Create ODBC Connection
• Create Oracle Connection
• Create PostgreSQL Connections
• Create SAP Connection
• Create SQL Server Connection

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.