The Unity Scheduler installer installs the appropriate files, dependencies, and the Unity Scheduler service.
To run the Unity Scheduler installer:
-
Open the setup.exe file located in the Unity Scheduler installation files.
The default location for Unity Scheduler installation files is install\Unity Scheduler\.The Hyland Unity Scheduler installation wizard is displayed.
-
Click Next.
The Destination Folder page is displayed.
-
Enter the top-level installation directory in the field provided, or click
Change to browse to top-level installation
directory.
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 the path to the folder in the Folder name field or select the folder from the Look in drop-down list, and then click OK.
If the Destination Folder is not changed, the default location is used.
-
Click Next.
The Additional Components Destination Folder page is displayed.
-
To change the installation location of additional components being installed
with the Unity Scheduler (such as the Web Application
Management Console), enter a new folder location or click
Change to navigate to the folder location.
Note:
It is highly recommended to install additional components in a separate directory from Unity Scheduler.
-
Click Next.
The Default Service Instance Option page is displayed.
-
If you want to create a default service instance of the Unity Scheduler service during the installation process, select the Create Default Service Instance on install option.
If you selected the Create Default Service Instance on install option, proceed to the next step. Otherwise skip to step 16.
-
In the Connection String field, enter a valid connection
string for connecting to a data source.
Tip:
Connection strings are a .NET Framework concept. If you need assistance in building a valid connection string, there are several resources on the Internet that can be used. Microsoft has posted a detailed explanation of connection strings on the MSDN site (http://msdn.microsoft.com) under Working With Data Providers in the ADO.NET Entity Framework library. There is also a Web site devoted entirely to connection strings at http://www.connectionstrings.com.
The following are sample connection strings for SQL and MSOracle. Values in brackets need to be replaced before being used as valid connection strings.
Connection Type Sample String SQL Data Source=[DATABASE_SERVER];Database=[DATABASE_NAME]; User Id=[USERNAME];Password=[PASSWORD];Encrypt=[ENCRYPT_TYPE] MSOracle Data Source=[TNS_NAME];User Id=[USERNAME];Password=[PASSWORD] The following table describes the values that need to be replaced in the sample connection strings if they are going to be used as the basis of your connection string:
Sample Value Replacement [DATABASE_SERVER] For SQL Server connection strings, replace this value with the name of your SQL instance. For example YourMachineName\SQLSERVER. Do not include the brackets ([ ]) in this value. This value may be case sensitive, depending on how the data source is configured. [DATABASE_NAME] For SQL Server connection strings, replace this value with the actual name of the database to which the Unity Scheduler Service will connect. Do not include the brackets ([ ]) in this value. This value may be case sensitive, depending on how the data source is configured. Note:This is not the data source name of the database connection; it is the actual name of the database.
[TNS_NAME] For MSOracle connection strings, replace this value with the Oracle Service Name to which the Unity Scheduler Service will connect. Do not include the brackets ([ ]) in this value. This value may be case sensitive, depending on how the data source is configured. Note:This is not the data source name of the database connection; it is the Oracle Service Name.
[USERNAME] Replace this with the username of a user configured with access to the database. Do not include the brackets ([ ]) in this value. [PASSWORD] Replace this with the password for the user configured to access the database. Do not include the brackets ([ ]) in this value. [ENCRYPT_TYPE] For SQL Server connection strings, replace this with the encryption type used by your connection string, either Mandatory or Optional. Do not include the brackets ([ ]) in this value. - In the Database Name field, enter the actual name of the database that is referenced in the connection string.
- In the Data Provider drop-down list, select oracle if you are connecting to an Oracle data source or select sqlserver if you are connecting to a SQL data source.
- In the Service Instance Name field, enter the name for the default service instance of the Unity Scheduler.
- If you want to add the default service instance of the Unity Scheduler to a task group, enter the name of a task group in the Task Group (optional) field.
- If an institutional database is used, enter the Institutional ID in the Institution Id (optional) field.
-
Click Next.
The NT Service User Account page is displayed.
-
Specify a domain account to run the NT Service.
Note:
An NT Service User Account is required to create a default service instance of the Unity Scheduler service during the installation process.
- In the User Name field, enter the user name of the account that will be used to run the NT service.
- In the Password field, enter the password of the account.
- In the Confirm Password field, enter the password again.
-
Click Next.
The OnBase Service Account page is displayed.
- In the User Name field, enter the user name of the service account has been configured in OnBase.
- In the Password field, enter the password of the service account.
- In the Confirm Password field, enter the same password that was entered in the Password field.
-
Click Next.
If Create Default Service Instance on install was not selected, skip to step 23.
If Create Default Service Instance on install was selected, the NT Service Options page is displayed.
- If you want the default service instance of the Unity Scheduler to be started during the installation process, select the Start service during installation option.
-
Click Next.
The Ready to install page is displayed.
- Click Install.
-
When the installation is complete, select the Launch Web Application Management Console option in order to configure the connection string used to access the OnBase database.
Note:
You must configure a valid connection string in order for the Unity Scheduler service to function properly.
-
Click Finish.
The connection string configuration window is displayed. The connection string configuration window allows you to configure connection strings.
-
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.
- Click Add to start creating a new connection string. The fields on the right become available for interaction.
-
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.
-
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.
-
-
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.
-
-
-
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.
-
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).
- Click Test Connection to test whether the entered information forms a valid connection string.
-
Click Create.
The connection string is created, 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.
- Select File > Save to save the changes to the .config file.
- Select File > Close to exit the connection string configuration window.