Unica Journey installation worksheet

Use the Unica Journey installation worksheet to gather information about the Unica Journey database and about other Unica products that are required for the upgrade of Unica Journey.

Use the following table to gather information about the empty database that was created for the Unica Journey system tables. The empty database that you set up for Unica Journey can have any name.
Table 1. Checklist for Journey System table schema:
Field Notes
Database Type
Database Name
Database account user name
Database account user password
Database Server Name (if OneDB)
Database Port
Database JNDI Name
Table 2. Checklist for Journey Reports table schema:
Field Notes
Database Type
Database Name
Database account user name
Database account user password
Database Server Name (if OneDB)
Database Port
Database JNDI Name

If you are doing installation

Oracle

For oracle database create a system user account and a report user for creating Report schema. The system user account must have the following rights:
  • CREATE TABLES
  • CREATE VIEWS (for reporting)
  • CREATE SEQUENCE (Oracle only)
  • CREATE INDICES
  • ALTER TABLE
  • INSERT
  • UPDATE
  • DELETE
Note: Report user also have the above mentioned rights. In addition, report user have to grant permission to system user for accessing the Report schema table. Run the following command

GRANT ALL PRIVILEGES TO (SYSTEM_SCHEMA_USER_NAME)

Table 3. Checklist for Application Server details:
Field Notes
Application Server type
Application server port to run
Journey web
Application server http protocol
Table 4. Checklist for Kafka Server:
Field Notes
Kafka server host
Kafka server port
Kafka server certificate (if Kafka is SSL enabled)
Kafka server - user id (if Kafka connection is SASL plaintext)
Kafka server - user password (if Kafka connection is SASL plaintext)

Checklist for Unica Marketing Platform:

The installation wizards for each Unica product must be able to communicate with the Unica Platform system table database to register the product. Each time that you run the installer, you must enter the following database connection information for the Unica Platform system table database:
Field Notes
Marketing Platform deployment host
Marketing Platform deployment port
Domain name
Marketing Platform HTTP protocol
JDBC connection URL
Database host name
Database port
Database name or schema ID
User name and password for the database account
  • Protocol: HTTP, or HTTPS if SSL is implemented in the web application server.
  • Host: The name of the machine on which the Unica Platform will be deployed.
  • Port: The port on which the web application server listens.
  • Domain name: The company domain of each machine where HCL products are installed. For example, example.com. All HCL products must be installed in the same company domain, and you must enter the domain name in all lower-case letters.

If there is a mismatch in domain name entries, you might encounter problems when you attempt to use Unica Platform features or navigate among products. You can change the domain name after the products are deployed by logging in and changing values of the relevant configuration properties in the product navigation categories on the Settings > Configuration page.

Checklist for Unica Journey Installation:

The installation wizards for each Unica product must be able to communicate with the Unica Platform system table database to register the product. Each time that you run the installer, you must enter the following database connection information for the Unica Platform system table database:
Field Notes
Marketing Platform deployment host
Marketing Platform deployment port
Domain name
Marketing Platform HTTP protocol
JDBC connection URL
Database host name
Database port
Database name or schema ID
User name and password for the database account
  • Protocol: HTTP, or HTTPS if SSL is implemented in the web application server.
  • Host: The name of the machine on which the Unica Platform will be deployed.
  • Port: The port on which the web application server listens.
  • Domain name: The company domain of each machine where HCL products are installed. For example, example.com. All HCL products must be installed in the same company domain, and you must enter the domain name in all lower case letters.

For more details, see Deployment Diagram

Oracle

  • Database Driver: oracle.jdbc.OracleDriver
  • Default port: 1521
  • Driver class: oracle.jdbc.OracleDriver
  • Driver URL: "jdbc:oracle:thin:@<Host>:<Port>:<SID_NAME>"
<?xml version="1.0"?>
<Context docBase="<Journeys_Install_Path>/Web/journey.war">
<Environment name="journey.web.home" value="<Journeys_Install_Path>/Web/" type="java.lang.String"/>
<Resource name="JourneyDS" type="javax.sql.DataSource" factory="com.hcl.journey.tomcat.util.JourneyTomcatDSFactory"
maxActive="30" maxIdle="10" maxWait="10000"
username="<your_db_user_name>" password="<your_db_user_password>" driverClassName="oracle.jdbc.OracleDriver"
url="jdbc:oracle:thin:@<Host>:<Port>:<SID_NAME>"/>
<Resource name="JourneyReportDS" type="javax.sql.DataSource" factory="com.hcl.journey.tomcat.util.JourneyTomcatDSFactory"
maxActive="30" maxIdle="10" maxWait="10000"
username="<your_db_user_name>" password="<your_db_user_password>" driverClassName="oracle.jdbc.OracleDriver"
url="jdbc:oracle:thin:@<Host>:<Port>:<SID_NAME>"/>
</Context>

SQL Server

  • Database Driver: com.microsoft.sqlserver.jdbc.SQLServerDriver

  • Default port: 1433

  • Driver class: com.microsoft.sqlserver.jdbc.SQLServerDriver

  • Driver URL: jdbc:sqlserver://<your_db_host>\\<named_instance>:<your_db_port>;databaseName=<your_db_name>

  • Properties: Add user=<your_db_user_name>

<?xml version="1.0"?>
<Context docBase="<Journeys_Install_Path>/Web/journey.war">
<Environment name="journey.web.home" value="<Journeys_Install_Path>/Web/" type="java.lang.String"/>
<Resource name="JourneyDS" type="javax.sql.DataSource" factory="com.hcl.journey.tomcat.util.JourneyTomcatDSFactory"
maxActive="30" maxIdle="10" maxWait="10000"
username="<your_db_user_name>" password="<your_db_user_password>" driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDriver"
url="jdbc:sqlserver://<your_db_host>\\<named_instance>:<your_db_port>;databaseName=<your_db_name>"/>
<Resource name="JourneyReportDS" type="javax.sql.DataSource" factory="com.hcl.journey.tomcat.util.JourneyTomcatDSFactory"
maxActive="30" maxIdle="10" maxWait="10000"
username="<your_db_user_name>" password="<your_db_user_password>" driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDriver"
url="jdbc:sqlserver://<your_db_host>\\<named_instance>:<your_db_port>;databaseName=<your_db_name>"/>
</Context>

OneDB Database

  • Database Driver: com.informix.jdbc.IfxDriver

  • Default port: 9088 <User Defined Database Port>

  • Driver class: javax.sql.DataSource

  • Driver URL: jdbc:Informix-sqli://host:port/database_name:informixserver=servername;

  • Properties: Add user=<your_db_user_name>

<?xml version="1.0"?>
<Context docBase="<Journeys_Install_Path>/Web/journey.war">
<Environment name="journey.web.home" value="<Journeys_Install_Path>/Web/" type="java.lang.String"/>
<Resource name="JourneyDS" type="javax.sql.DataSource" factory="com.hcl.journey.tomcat.util.JourneyTomcatDSFactory"
maxActive="30" maxIdle="10" maxWait="10000"
username="<your_db_user_name>" password="<your_db_user_password>" driverClassName="javax.sql.DataSource"
url="jdbc:Informix-sqli://host:port/<database_name>:informixserver=<servername>"/>
<Resource name="JourneyReportDS" type="javax.sql.DataSource" factory="com.hcl.journey.tomcat.util.JourneyTomcatDSFactory"
maxActive="30" maxIdle="10" maxWait="10000"
username="<your_db_user_name>" password="<your_db_user_password>" driverClassName="javax.sql.DataSource"
url="jdbc:Informix-sqli://host:port/<database_name>:informixserver=<servername>"/>
</Context>

MariaDB Database

  • Database Driver: org.mariadb.jdbc.Driver

  • Default port: 3306

  • Driver class: org.mariadb.jdbc.Driver

  • Driver URL: ="jdbc:mariadb://host:port/<DB_USER_NAME>"

  • Properties: Add user=<your_db_user_name>

<?xml version="1.0"?>
<Context docBase="<Journeys_Install_Path>/Web/journey.war">
<Environment name="journey.web.home" value="<Journeys_Install_Path>/Web/" type="java.lang.String"/>
<Resource name="JourneyDS" type="javax.sql.DataSource" factory="com.hcl.journey.tomcat.util.JourneyTomcatDSFactory"
maxActive="30" maxIdle="10" maxWait="10000"
username="<your_db_user_name>" password="<your_db_user_password>" driverClassName="org.mariadb.jdbc.Driver"
url="jdbc:mariadb://host:port/<DB_USER_NAME>"/>
<Resource name="JourneyReportDS" type="javax.sql.DataSource" factory="com.hcl.journey.tomcat.util.JourneyTomcatDSFactory"
maxActive="30" maxIdle="10" maxWait="10000"
username="<your_db_user_name>" password="<your_db_user_password>" driverClassName="org.mariadb.jdbc.Driver"
url="jdbc:mariadb://host:port/<DB_USER_NAME>"/>
</Context>