Home
Installation Guides
Installation Guide
An installation of HCL Unica products is complete when you install, configure, and deploy the HCL Unica products . The Installation Guide provides detailed information about installing, configuring, and deploying the products.
About Platform SQL scripts
This section describes the SQL scripts provided with Unica Platform to perform various tasks relating to the Unica Platform system tables.

Installation Guides
- Installation Guide
  An installation of HCL Unica products is complete when you install, configure, and deploy the HCL Unica products . The Installation Guide provides detailed information about installing, configuring, and deploying the products.
  - Installation overview
    An installation of HCL Unica products is complete when you install, configure, and deploy the HCL Unica products . The Installation Guide provides detailed information about installing, configuring, and deploying the products.
  - Planning the Unica Platform installation
    When you plan your Unica Platform installation, you must ensure that you have set up your system correctly, and that you have configured your environment to deal with any failures.
  - Creating the Unica Platform data sources
    You must create Unica Platform data sources before you can install Unica Platform.
  - Installing Platform
    You must run the Unica installer to start the installation of Unica Platform. The Unica installer starts the Unica Platform installer during the installation process. Make sure that the Unica installer and the product installer are saved at the same location.
  - Deploying Platform
    You must follow a set of guidelines when you deploy Unica Platform in your web application server. There is a different set of guidelines for deploying Unica Platform on WebLogic and on WebSphere®.
  - Configuring Platform after deployment
    For a basic installation of Unica Platform, you must configure Unica Platform after deployment if you use the Unica reporting feature, or if you want to use a password policy.
  - Installing Unica Platform in a cluster
  - Deploying Asset Picker
  - Unica Platform utilities
    This section provides an overview of the Unica Platform utilities, including some details that apply to all the utilities and which are not included in the individual utility descriptions.
  - About Platform SQL scripts
    This section describes the SQL scripts provided with Unica Platform to perform various tasks relating to the Unica Platform system tables.
    - Removing all data (ManagerSchema_DeleteAll.sql)
      The Manager_Schema_DeleteAll.sql script removes all data from the Unica Platform system tables without removing the tables themselves. This script removes all users, groups, security credentials, data filters, and configuration settings from Unica Platform.
    - Removing data filters only (ManagerSchema_PurgeDataFiltering.sql)
      The ManagerSchema_PurgeDataFiltering.sql script removes all data filtering data from the Unica Platform system tables without removing the data filter tables themselves. This script removes all data filters, data filter configurations, audiences, and data filter assignments from Unica Platform.
    - Creating system tables
      Use the scripts described in the following table to create Unica Platform system tables manually when your company policy does not allow you to use the installer to create them automatically.
    - Removing system tables (ManagerSchema_DropAll.sql)
      The ManagerSchema_DropAll.sql script removes all Unica Platform system tables from a database. This script removes all tables, users, groups, security credentials, and configuration settings from Unica Platform.
  - Uninstalling Unica Platform
    Run the Unica Platform uninstaller to uninstall Unica Platform. When you run the uninstaller, the files that were created during the installation process are removed. For example, files such as configuration files, installer registry information, and user data are removed from the computer.

Unica Platform SQL scripts

This section describes the SQL scripts provided with Unica Platform to perform various tasks relating to the Unica Platform system tables.

The Unica Platform SQL scripts are located in the db directory under your Unica Platform installation.

The scripts are designed to be run against the Unica Platform system tables, using the database client.

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.