Business Indexing Connector for use with SAP ArchiveLink runs as a Windows service. In order for BIC to be successfully installed, you must install the BIC service. To install the BIC service,
-
Double-click on the Hyland BIC Service for SAP ArchiveLink.msi file located in the ..\install\BICService directory of the software build. Copy this directory locally to the machine that will run BIC before beginning
-
Click Next.
- For typical installations, the default folder is correct. You can specify a different folder location if necessary by clicking Change, entering the correct path, and clicking OK.
-
Click Next.
- You are prompted to enter the Username and Password for the Windows account that will run the service. Include the domain in the Username field: domain\username. If you deselect the Specify domain account to run NT Service check box, the Local System account will run the service.
-
Click Next.
-
Click Install. Installation of files begins.
-
When installation is complete, select Launch Web Application Management Console 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 Business Indexing Connector for use with SAP ArchiveLink to function properly.
-
Click Finish. The connection string configuration window is displayed.
The connection strings dialog box 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 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.
- Select File | Save to save the .config file.
- Select File | Close to exit the connection strings dialog box.