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.

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.
  - ELK Configurations
    Before configuring ELK on Unica Discover, there are some prerequisites:
- Unica Discover Data Export for Data Analysis Administration Manual
- Session Archiving Guide

Authentication

During the installation process for SQL Server, you are prompted for the type of authentication in use for the install account.

The account in use should have both Windows™ and SQL Server authentication.

Note: If your account is restricted to Windows™-only authentication, and you are upgrading Discover databases on an SQL Server, see Upgrading Discover databases on SQL Server when your account is restricted to Windows™-only authentication in the topic titled "Other common database scenarios".

Note: If your account is restricted to Windows™-only authentication, and you are installing Discover databases on an SQL Server, see Installing Discover databases on SQL Server when your account is restricted to Windows™-only authentication in the topic titled "Scenario 2: Partial permissions; must grant permissions to Discover database users".

Note: The accounts that you use for the Discover databases should not be shared with any other application in your SQL Server environment.

Note: If these logins are created with names other than the default ones, that information must also be updated in the Report Server configuration. See "Configuring the Report Server" in the Unica Discover Configuration Manual.

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.