Home
Administration
Administering HCL Discover involves configuring and integrating the HCL Discover client framework with your web applications or mobile native applications, installing and administering the databases used by HCL Discover, defining event objects and configuring events, hit attributes, dimensions, and other object attributes used by HCL Discover to monitor mission-critical metrics of your web application's performance.
HCL Discover Administration Manual
Database Administration
The HCL Discover datastore runs on top of a set of four Microsoft™ SQL Server databases.
SQL Server authentication
This page contains information about the authentication methods and login permissions that are required by Discover for accessing the SQL Server databases.
Authentication
During the installation process for SQL Server, you are prompted for the type of authentication in use for the install account.
Installation login
The SQL Server login that is used during installation needs the following permissions to install and modify the schemas of each Discover database.

Administration
Administering HCL Discover involves configuring and integrating the HCL Discover client framework with your web applications or mobile native applications, installing and administering the databases used by HCL Discover, defining event objects and configuring events, hit attributes, dimensions, and other object attributes used by HCL Discover to monitor mission-critical metrics of your web application's performance.
- HCL Discover Administration Manual
  - Discover Admin Overview
    This section is an overview to the Discover system and its components.
  - Discover System Monitoring
    Discover provides several mechanisms for monitoring the health of the Discover system and Discover user activities. This section provides access to the various tools available in the Discover system for monitoring it and its users.
  - Portal Management
    This section contains administration topics for managing the Discover Portal and features available through it.
  - Discover Management System
    The Discover Management System (Manage Services) centralizes configuration management for Discover systems on Windows™-based hosts.
  - Database Administration
    The HCL Discover datastore runs on top of a set of four Microsoft™ SQL Server databases.
    - SQL Server authentication
      This page contains information about the authentication methods and login permissions that are required by Discover for accessing the SQL Server databases.
      - Authentication
        During the installation process for SQL Server, you are prompted for the type of authentication in use for the install account.
        Required SQL Server login permissions
        The Discover application requires three SQL Server logins to operate correctly:
        Installation login
        The SQL Server login that is used during installation needs the following permissions to install and modify the schemas of each Discover database.
        Administrative login
        This login is used by Discover applications that must be able to modify the schemas of one or more of the Discover databases. The applications that use this account that is run in the background and do not allow user interaction.
        User login
        This login is used by the Discover Portal and any other Discover applications that require database access and allow user interaction. The login is limited to reading and writing data from the Discover databases.
      - Discover database security
        Follow these guidelines when setting up database security for Discover.
    - Configuring the Discover Data Service
      The Discover Data Service manages connections between Discover components and services and the databases they are querying. This service allows database connectivity to be managed as a Windows™-based service for security, reliability, and control.
    - Databases
      This section provides some overview information on each of the HCL Discover databases.
    - Database backup strategy
      Your Discover databases should be backed up regularly for recovery and performance reasons. Without valid backups, Discover may be unable to recover customer data in the event of a system failure or data corruption.
    - Troubleshooting Discover databases
      If you are experiencing an access or performance-related issue with your installed Discover SQL database, review the troubleshooting tips in this section, which may help to resolve your issue.
  - Report Access Permissions
    Users whose accounts contain the proper permissions may administer Discover reports. Depending on the type of report, permissions to administer individual reports of that type are configured in the report definition.
  - Managing User Agents
    Through Discover, you can monitor the different types of user agents that contact your web application. Through a provided set of data objects, Discover can identify the type of traffic that is requesting resources from your web application and then monitor counts and other information that pertains to the type of user agent. These objects can be used as the source data for developing a useful set of user agent-related reports, enabling you to closely monitor the composition of traffic to your site.
  - Configuring User Agent Detection
    This section describes how to acquire and maintain the configuration files necessary for parsing of fixed and mobile user agents and how to prepare those files for use in the HCL Discover platform.
  - Configuring User Agent Events
    To use the data that is injected into the [ExtendedUserAgent] section by the Discover SessionAgentTLTRef, a Discover administrator must create events that create charts for this data.
  - User Agent Tools
    These external utilities can be used to monitor and update user agent configuration data that is required by Discover.
  - bot Detection
    Most commercial enterprise web applications are subjected to significant traffic from web crawling bots. Short for "robot," a bot is a software agent that navigates websites to extract information about them. Some bots are used by search engines for indexing pages.
  - Discover Reference Information
    Use the links below to access reference information on file formats, common standards, and more in use by the Discover system.
  - Integrating HCL Discover and Unica Journey
    HCL Discover and Unica Journey integration works with CEP configuration. The CEP configuration enables the event to be sent to CEP and the external systems. Unica Discover-Unica Journey integration is supported from version 12.1.0.3 onwards.
  - Integrating HCL Discover and Unica Interact
    HCL Discover and Unica Interact integration works with CEP configuration. The CEP configuration enables the event to be sent to CEP and the external systems. Unica Discover-Unica Interact integration is supported from version 12.1.0.3 onwards.
  - Selective Deletion
    You can delete sessions and session fragments from the HCL Discover system with the Selective Deletion tool.
  - Using the ArchiveConfig utility
    Run the ArchiveConfig utility to configure and execute Selective Archiving.
  - ELK Configurations
    Before configuring ELK on HCL Discover, there are some prerequisites:
  - Securing Interprocess Communication
    Discover 12.1.8 and above supports the use of a new SSL certificate based mechanism for securing all inter-process communication between the Discover servers. This is important in a distributed environment with multiple servers, as the components of Discover communicate with each other over the network, using a variety of ports.
- HCL Discover Data Export for Data Analysis Administration Manual
- Session Archiving Guide

Installation login

The SQL Server login that is used during installation needs the following permissions to install and modify the schemas of each Discover database.

This login can either be the NT account of the user running the Discover installation or a separate SQL Server login that is provided to the Discover Database Manager as a secondary step after the main installation completes.

Note: The Installation login is required during initial installation of the databases only. After the installation completed successfully, this login can be deleted or disabled.

The simplest option is to use an NT Account that has SQL Server admin privileges or provide a SQL login with that level of access. If that is not possible a login with the following roles and permissions is required to successfully complete the Discover database installation:

Required Database Roles:
- db_ddladmin
- db_datareader
- db_datawriter
Required Database Permissions:
- ALTER ANY LOGIN
- ALTER ANY USER
- CREATE DATABASE
- CREATE SCHEMA

Rate this topic

5 stars 4 stars 3 stars 2 stars 1 star

Comment on this topic.

By clicking this box, you acknowledge that you are NOT a U.S. Federal Government employee or agency, nor are you submitting information with respect to or on behalf of one. HCL provides software and services to U.S. Federal Government customers through its partners immixGroup, Inc. Contact this team at https://hcltechsw.com/resources/us-government-contact. Do not include any personal data in this Comment box.