Benchmark Factory for Database 7.6.1 - User Guide

Create Microsoft SQL Server Connection

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: For a list of operating systems that support the SQL Server native provider distributed with Benchmark Factory (native client 11.0), see https://msdn.microsoft.com/en-us/library/cc280356(v=sql.120).aspx. If your client operating system is not supported, use ODBC connectivity.

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

To create a SQL Server DB-Library connection (obsolete)

Note: 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.

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 DB-Library (Obsolete) tab.

4. Enter the following connection information.

   DB-Library (Obsolete)
   Server Name	The name or the IP address of the server.
   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.

5. 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 an existing connection, click Edit Connections in the main toolbar. Select a connection and click .

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 .