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.
Field | Notes |
Database Type | |
Database Name | |
Database account user name | |
Database account user password | |
Database Server Name (if OneDB) | |
Database Port | |
Database JNDI Name |
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
- CREATE TABLES
- CREATE VIEWS (for reporting)
- CREATE SEQUENCE (Oracle only)
- CREATE INDICES
- ALTER TABLE
- INSERT
- UPDATE
- DELETE
GRANT ALL PRIVILEGES TO (SYSTEM_SCHEMA_USER_NAME)
Field | Notes |
Application Server type | |
Application server port to run | |
Journey web | |
Application server http protocol |
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:
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
page.Checklist for Unica Journey Installation:
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>