Installation steps for Unica Campaign and Unica Optimize

About this task

To install Unica Campaign and Unica Optimize, version 12.1.0.3 for OneDB, perform the following steps.

Procedure

  1. Place the Unica Campaign version 12.1.0.3 fix pack installer at the same directory as version 12.1 installer.
  2. Run the Unica Campaign 12.1.0.3 fix pack installer through the HCL Unica Installer on all servers, where Unica Campaign resides including the web app server and the listener (analytic) server.
    Note: Provide reference to OneDB jar in jdbc classpath while installation.
  3. Connect to Campaign database and run the following scripts manually.
    For non-unicode database
    • <CAMPAIGN_HOME>\tools\upgrade\11.1+To12.1\ac_upgrade_onedb.sql
    For unicode database
    • <CAMPAIGN_HOME>\tools\upgrade\11.1+To12.1\ac_upgrade_onedb_unicode.sql
  4. Create ODBC DSN for OneDB. See the prerequisites of OneDB database before Campaign installation.
  5. Set up setenv.sh with the following entries.
    Sample example for setenv for Unix
    LD_LIBRARY_PATH=<CAMPAIGN_HOME>/bin:<HCL_OneDB_Client_SDK>/lib/:<HCL_OneDB_Client_SDK>/lib/esql:<HCL_OneDB_Client_SDK>/lib/cli:<HCL_OneDB_Client_SDK>/lib/client:/usr/local/unixODBC/lib/:/usr/lib64:/lib64:/lib:/usr/lib
export LD_LIBRARY_PATH
CAMPAIGN_HOME=<CAMPAIGN_HOME>
export CAMPAIGN_HOME
export ODBCINI=/etc/odbc.ini
export LANG=en_US.utf8
export DB_LOCALE=en_US.utf8
export CLIENT_LOCALE=en_US.utf8
export SERVER_LOCALE=en_US.utf8
export INFORMIXDIR=<HCL_OneDB_Client_SDK>
export INFORMIXSERVER=onedb
export ONCONFIG=onconfig.onedb
export INFORMIXSQLHOSTS=<HCL_OneDB_Client_SDK>/etc/sqlhosts.onedb
export DELIMIDENT=Y
export GL_USEGLU=1
  6. Test the connection using Campaign CxnTest utility.
    Note: For cxntest utility test, users are required to use libodb4dDD.so library file.
  7. Deploy the Campaign WAR file in the application server.
  8. Import OneDB datasource template.

    configTool -i -p "Campaign|partitions|partition1|dataSources" -f full_path_to_directory_containing_your_Oracle_template\OneDBTemplate.xml

  9. Configure UA_SYSTEM_TABLES.
  10. Start Unica Campaign listener.

    Windows: CAMPAIGN_HOME\bin\cmpServer.bat

    Unix: CAMPAIGN_HOME/bin/rc.unica_ac start