Benchmark Factory for Database 8.1 - User Guide

Repository Settings

Note: If you create a new repository in Benchmark Factory 5.5 or later, earlier versions of Benchmark Factory will not work against this repository.

The repository is a database where all of the test results are stored. Benchmark Factory inserts test results into the repository and provides an easy way to access all test results data.

By default, the Repository is a SQLite database that resides on the same machine as Benchmark Factory. The Repository can reside on another database server if required. To change the database, select the Data Source Name of the ODBC connection for the new database. To migrate data from one database to another, click Data Migration to open the Data Migration Wizard.

Note: By default in Benchmark Factory 7.1.1 or earlier, a MySQL database is created and used as the Repository, unless you selected the SQLite option during installation. In Benchmark Factory 7.2 or later, by default a SQLite database is created and used as the Repository.

If you plan to store a large amount of test data in the repository, you might want to consider using a more robust database than SQLite.

The Repository Settings page allows you to edit the DSN, perform ODBC administration, and test the connection. Benchmark Factory also provides a Repository Manager and Data Repository Migration wizard to assist you with other repository management functions.

Note: If the database structure does not exist on the selected database, Benchmark Factory prompts you to create the structure.

The supported database types are:

• MySQL
• SQL Server®
• SQLite
• SAP SQL Anywhere® (Adaptive Server® Anywhere)
• Oracle®

To specify Repository settings

1. Select Edit | Settings. The Settings dialog opens.

2. Select Repository. Review the following for additional information:

   Data Source Name	Data Source name of the ODBC connection used to connect to the repository database.
   User Name	The User Name used to log into the selected database.
   Password	The Password associated with the user name used to log into the database.
   Edit DSN	Click to edit the selected Data Source Name.
   ODBC Administrator	Click to open the ODBC Data Source Administrator dialog. Use this to add a DSN or ODBC connection.
   Test Connection	Tests the defined connection.
   Data Migration	Click to open the Data Migration Wizard. See Data Repository Migration Wizard for more information.