Configuration - System Administration - On-Premises - English - Foundation 22.1 - OnBase - Essential - Premier - Standard - external - Standard - Premier - Essential

On-Premises System Administration

Platform
OnBase
Product
System Administration - On-Premises
Release
Foundation 22.1
License
Standard
Premier
Essential

Before using the Test System Creation utility, ADO.NET connection strings for the source and test databases must be configured in the tsc.exe.config file. In a default installation, the tsc.exe.config file is located at C:\Program Files (86x)\Hyland\Test System Creation. If the connection strings have not been configured using the Web Application Management Console, they must be configured manually.

Note:

ADO.NET connection strings can be specified when creating a test system using the command prompt. The connection string for the source database and the connection string for the test databases can be specified using different methods. For more information, see 4.

To configure ADO.NET connection strings in the tsc.exe.config file:

  1. In the tsc.exe.config file, find the following under the <connectionStrings> element:

    <!--<add name="[Source Data Source Name]" connectionString="Data Source=[server\instance];database=[databaseName];User Id=[user name];Password=[password]" providerName="[providerName]" />-->

    <!--<add name="[Destination Data Source Name]" connectionString="Data Source=[server\instance];database=[databaseName];User Id=[user name];Password=[password]" providerName="[providerName]" />-->

  2. In the Source Data Source entry, using the source database information, perform the following:
    1. Replace [DataSourceName] with the name of your database connection string.
    2. Replace [server\instance] with the value of your database data source.
    3. Replace [databaseName] with the name of your database.
    4. Replace [user name] with the value of your database user name.
    5. Replace [password] with the value of your database password.
    6. Replace [providerName] with your database provider name.

      Use one of the following:

      • SQL Server :

        providerName="System.Data.SqlClient"

      • Oracle :

        providerName="Oracle.ManagedDataAccess.Client"

      Note:

      Only SQL Server and Oracle data providers can be used to connect to the database.

  3. In the Destination Data Source entry, repeat step 2 using the test database information.
    Note:

    The user specified for the test database connection string must have privileges in the test database to create tables, indexes, and users.

  4. Save and close the tsc.exe.config file.

For more information on configuring ADO.NET connection strings, see the Application Server module reference guide.