Home
Administration
Administering Unica Discover involves configuring and integrating the Unica Discover client framework with your web applications or mobile native applications, installing and administering the databases used by Unica Discover, defining event objects and configuring events, hit attributes, dimensions, and other object attributes used by Unica Discover to monitor mission-critical metrics of your web application's performance.
Unica Discover Administration Manual
Database Administration
The Unica 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:

Administration
Administering Unica Discover involves configuring and integrating the Unica Discover client framework with your web applications or mobile native applications, installing and administering the databases used by Unica Discover, defining event objects and configuring events, hit attributes, dimensions, and other object attributes used by Unica Discover to monitor mission-critical metrics of your web application's performance.
- Unica 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 Unica 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 Unica 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 Unica 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 Unica Discover and Unica Journey
    Unica 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 Unica Discover and Unica Interact
    Unica 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 Unica 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 Unica 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.
- Unica Discover Data Export for Data Analysis Administration Manual
- Session Archiving Guide

Required SQL Server login permissions

The Discover application requires three SQL Server logins to operate correctly:

About this task

Procedure

During installation, a SQL Server login is required with sufficient permissions to create and modify the Discover databases. This login is used only during installation. See Installation login.
An Administrative login enables background processes to modify the database schema during normal operation. See Administrative login.
A User login is used by all customer-facing portions of the application and only permits read and write access to the databases. See User login.

Have feedback?
Google Analytics is used to store comments and ratings. To provide a comment or rating for a topic, click Accept All Cookies or Allow All in Cookie Preferences in the footer of this page.