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.
Databases
This section provides some overview information on each of the Unica Discover databases.
System database
The system database is required for the configuration and operation of all Portal and Reporting capabilities. It contains all Discover system information that is created through the configuration and use of Discover.

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.
    - 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.
      - System database
        The system database is required for the configuration and operation of all Portal and Reporting capabilities. It contains all Discover system information that is created through the configuration and use of Discover.
      - Reporting database
        This database contains statistical information about traffic that is captured from monitored customer applications.
      - Statistics database
        The statistics database contains performance information about the Unica Discover system itself. It is used to monitor the systems health and to aid in troubleshooting if an issue arises.
    - 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.
  - ELK Configurations
    Before configuring ELK on Unica Discover, there are some prerequisites:
- Unica Discover Data Export for Data Analysis Administration Manual
- Session Archiving Guide

System database

The system database is required for the configuration and operation of all Portal and Reporting capabilities. It contains all Discover system information that is created through the configuration and use of Discover.

It contains the following data specific to the customer environment:

Discover user information
Dashboards definitions
Scorecards definitions
Report definitions
System log information
Event definitions
- Step-based event definitions

Filegroups

Filegroup: Description
PRIMARY: Contains SQL Server database-specific information, including temp space and data management inside the database. Does not contain any Discover data.
CONFIG: System configuration information contains all Discover system configuration information, user profiles, and report definitions.
INDEX: Contains indexes on all tables in the database.
APP_LOGS: Contains log tables for various components of the Discover application.

Sizing

This database is small, typically between 500 MB and 1 GB. It might experience some growth during normal operation because system logging data is written in to the database.

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.