Benchmark Factory for Database 8.0 - User Guide

Create SAP Connection

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 wan 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.
   Reconnect Options	Click link 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.

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

Create MySQL Connection

Benchmark Factory allows you to create an ODBC connection to a MySQL database.

To create a MySQL connection

1. Click in the main toolbar. The New Connection dialog opens.
2. Select MySQL (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 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.
   Reconnect Options	Click link 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.

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

Create ODBC Connection

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

4. Click Create Connection to save the connection information and connect.

Performance Counters

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

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

Create IBM DB2 CLI Connection

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.
   Reconnect Options	Click link 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.

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