Installation steps for Unica Campaign and Unica Optimize
About this task
Procedure
- Place the Unica Campaign version 12.1.0.3 fix pack installer at the same directory as version 12.1 installer.
-
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.
-
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
- Create ODBC DSN for OneDB. See the prerequisites of OneDB database before Campaign installation.
-
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
-
Test the connection using Campaign CxnTest utility.
Note: For cxntest utility test, users are required to use libodb4dDD.so library file.
- Deploy the Campaign WAR file in the application server.
-
Import OneDB datasource template.
configTool -i -p "Campaign|partitions|partition1|dataSources" -f full_path_to_directory_containing_your_Oracle_template\OneDBTemplate.xml
- Configure UA_SYSTEM_TABLES.
-
Start Unica Campaign listener.
Windows:
CAMPAIGN_HOME\bin\cmpServer.bat
Unix:
CAMPAIGN_HOME/bin/rc.unica_ac start