Creating and populating the Unica Platform system tables manually

When you install Unica Platform, you can select the option where the installer creates the Unica Platform system tables automatically. Alternatively, you can manually create the system tables.

Procedure

Complete the following tasks to create and populate the system tables manually:
  1. Run the installer as described in Installing Unica Platform using the GUI mode, but with the following differences in your choices when it launches the Unica Platform installer.
    • Select Manual database setup.
    • Deselect the Run Platform configuration checkbox.
  2. After the installer finishes, create the system tables manually by running the following SQL scripts appropriate for your database type against your Unica Platform system table database, as described in SQL scripts for creating system tables.

    Run the scripts in this order.

    • ManagerSchema_DBType.sql

      If you plan to support multi-byte characters (for example, Chinese, Japanese, or Korean) and your database is DB2®, use the ManagerSchema_DB2_unicode.sql script.

    • ManagerSchema__DBType_CeateFKConstraints.sql
    • active_portlets.sql
    • quartz__DBType.sql
    • active_portlets.sql
    • notification_rules.sql(or notification_rules._Oracle.sql in case of oracle db)
  3. Run the populateDB utility to populate the system tables with default users and roles.

    Use this command:

    populateDb -n Manager

    See populateDb for complete details on using this utility.

  4. Run the installer again, making the following selections when it launches the Unica Platform installer.
    • Select Manual database setup.
    • Select the Run Platform configuration checkbox.

      This adds default configuration properties to the system tables.