Installation - Change Control - English - Foundation 22.1 - OnBase - Essential - Premier - Standard - external - Standard - Essential - Premier

Change Control

Platform
OnBase
Product
Change Control
Release
Foundation 22.1
License
Standard
Essential
Premier

To install the Test System Creation utility:

  1. Launch the Test System Creation installer by executing setup.exe. This executable is usually located in the \Install\Test System Creation folder of your source installation files. The welcome dialog box is displayed.
  2. Click Next. The Destination Folder dialog box is displayed.
  3. Enter the top-level installation directory in the field provided, or click Change to browse to it.
    Note:

    This location does not affect components not installed under the top-level directory. If the installer provides for the installation of multiple components, the specific installation locations of each component can be changed later in the installation process.

    If Change is clicked the Change destination folder dialog box is displayed.

    Enter a Folder name in the field provided or select it from the Look in drop-down list, then click OK.

    If the Destination Folder is not changed, the default location is used.

  4. Click Next. The Ready to install dialog box is displayed:
  5. Click Install. After installation has completed, the Completed dialog box is displayed:
  6. Select Launch Web Application Management Console to open the Web Application Management Console and configure the connection strings used to access the source and test databases. If this option is not selected, the connection string can be configured by manually editing the Test System Creation configuration file. For more information, see Configuration.
    Note:

    You must configure valid connection strings for both the source and the test databases in order for the Test System Creation utility to function properly.

  7. Click Finish. The tsc.exe executable and all required files are saved to the specified location. If Launch Web Application Management Console was not selected, the installation is complete.
  8. If Launch Web Application Management Console was selected, the following dialog box is displayed.

    The connection strings dialog box allows you to configure connection strings.

  9. To encrypt all connection strings configured in the application's .config file, ensure the Options | Encrypt Connection Strings menu option is selected. This option is automatically selected by default every time you open the connection strings dialog box, and the connection strings are encrypted when the .config file is saved.
    CAUTION:

    It is strongly recommended to encrypt the connection strings. If they are not encrypted, all data source connection information is visible in the .config file and could expose sensitive data, including any entered database user names and passwords.

  10. Click Add to start creating a new connection string. The fields on the right become available for interaction.
  11. If you are configuring Reporting Dashboards with a secondary connection string with a read-only database user account, select Options | Populate Read-Only User. This optional feature populates the User ID and Password fields with the credentials for the read-only user. See the Reporting Dashboards documentation for more information.
    If you are creating a connection string for any other purpose, skip this step.
  12. In the fields on the right, enter the following information about the data source:

    Option

    Description

    Data Source Name

    A unique name that you create to identify the connection string.

    Note:

    This identifying name may be different from the name of the actual database.

    Data Provider

    The data provider type used for the database. Select one of the following:

    • System.Data.SqlClient: Select this for a SQL Server database.

    • Oracle.ManagedDataAccess.Client: Select this for an Oracle database.

    Note:

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

  13. Depending on your selection for Data Provider in the previous step, enter the following database connection information:
    • If System.Data.SqlClient is selected (for a SQL Server database):

      System.Data.SqlClient Option

      Description

      Data Source

      Enter the server\instance name of the SQL Server instance hosting the database.

      Database

      Enter the name of the SQL Server database.

    • If Oracle.ManagedDataAccess.Client is selected (for an Oracle database):

      Oracle.ManagedDataAccess.Client Option

      Description

      TNS Connection String

      Select this option to enter a full TNS connection string to connect to the Oracle database. Deselect the option to use the connection name instead.

      Note:

      Selecting this option enables the Host, Database, Protocol, and Port fields for interaction.

      Data Source

      Enter the TNS name or connect descriptor of the Oracle database.

      Note:

      This field is available only if the TNS Connection String option is deselected.

      Host

      Enter the host address of the Oracle database.

      Database

      Enter the name of the Oracle database.

      Protocol

      Select the protocol to use for connecting to the Oracle database. Options are:

      • TCP

      • TCPS

      Port

      Enter the port to use for connecting to the Oracle database.

  14. Enter the following security information:

    Option

    Description

    Integrated Security

    Select this option to use Windows Authentication to connect to the database.

    CAUTION:

    It is strongly recommended to use integrated security instead of a database account for authentication. To use integrated security, the Windows user connecting to the database must be the same user that is running the connecting server or service (such as the Application Server). This user must also be configured with the configgp role in the database.

    User ID

    The user name of the database user account accessing the database.

    Note:

    This user name is for a database user account, not a user account for OnBase.

    Password

    The password of the database user account accessing the database.

    Note:

    This password is for a database user account, not a user account for OnBase.

  15. Enter any additional options.

    Option

    Description

    Additional Options

    Any additional options for the connection string. For more information on available connection string options and syntax, see the documentation for your database provider (SQL Server or Oracle).

  16. Click Test Connection to test whether the entered information forms a valid connection string.
  17. Click Create to save the information in the fields and create the connection string. The name of the data source is added to the Data Sources list on the left, and the connection string is displayed in the Connection String section.
  18. Select File | Save to save the .config file.
  19. Select File | Close to exit the connection strings dialog box.
    Note:

    To ensure that the required system settings take effect, it is considered a best practice to restart the installing machine once the installer has finished.