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 installation 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.
Field | Notes® |
---|---|
Database type | |
Database name | |
Database account user name | |
Database account password | |
JNDI name | JourneyDS, JourneyReportDS |
ODBC name |
Fields | 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) |
- 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>
DB2
-
Database Driver:
db2jcc4.jar
-
Default port: 50000
-
Driver class: com.ibm.db2.jcc.DB2Driver
-
Driver URL: jdbc:db2://<your_db_host>:<your_db_port>/<your_db_name>
Checklist for Unica Platform database
- JDBC connection URL
- Database host name
- Database port
- Database name or schema ID
- User name and password for the database account
Checklist for Unica Platform deployment on the web application server
- 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
- hostname - The name of the system on which Journey web application will be installed.
- The port on which the application server listens. If you plan to implement SSL, obtain the SSL port.
- The network domain for your deployment system. For example,
mycompany.com
.