Unica Journey installation worksheet

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. Supported Database
This two-columned table provides a checklist of the various types of information that you must gather about the database in the first column and provides space to note the information in the second column.

Currently we are supporting two schemas (System User and Report User).
Field	Notes®
Database type
Database name
Database account user name
Database account password
JNDI name	JourneyDS, JourneyReportDS
ODBC name

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)

For more details, see Unica Journey deployment (on page 30)

Table 2. Information about the Kafka InstanceIf you are planning to use existing Kafka instance you will need to gather below information:
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)

SQL Server

Database Driver: com.microsoft.sqlserver.jdbc.SQLServerDriver
Default port: 1433
Driver class: journey.datasource.driver-class-name=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>

<Context  docBase="<Journey_Install_Path>/Journey/journey.war" >
	<Environment name="journey.web.home" value="<Journey_Install_Path>" type="java.lang.String"/>
	<Resource name="JourneyDS" type="javax.sql.DataSource"
                          maxActive="30" maxIdle="10" maxWait="10000"
                          username="" password="" 
						  driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDriver"
                          url="jdbc:sqlserver://host:port;databaseName=journey"/>		

	<Resource name="JourneyReportDS" type="javax.sql.DataSource"
                          maxActive="30" maxIdle="10" maxWait="10000"
                          username="" password="" 
						  driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDriver"
                          url="jdbc:sqlserver://host:port;databaseName=report"/>
</Context>

OneDB Database

Database Driver: com.informix.jdbc.IfxDriver
Default port: 9088
Driver class: journey1:informixserver=onedb_1;CLIENT_LOCALE=en_us.57372;DB_LOCALE=en_us.57372;
Driver URL: jdbc:Informix-sqli://host:port/database_name:informixserver=servername
Properties: Add user=<your_db_user_name>

<Context  docBase="<Journeys_Install_Path>/Web/journey.war" >
	<Environment name="journey.web.home" value="<Journeys_Install_Path>/Web/" type="java.lang.String"/>
	<Resource name="JourneyReportDS" type="javax.sql.DataSource"
              maxActive="30" maxIdle="10" maxWait="10000"
              username="" password="" 
			  driverClassName="com.informix.jdbc.IfxDriver"
			  url="jdbc:informix-sqli://host:port/report:informixserver=onedb;CLIENT_LOCALE=en_us.57372;DB_LOCALE=en_us.57372"/>		

	<Resource name="JourneyDS" type="javax.sql.DataSource"
              maxActive="30" maxIdle="10" maxWait="10000"
              username="" password="" 
			  driverClassName="com.informix.jdbc.IfxDriver"
			  url="jdbc:informix-sqli://host:port/journey:informixserver=onedb;CLIENT_LOCALE=en_us.57372;DB_LOCALE=en_us.57372"/>
</Context>

MariaDB Database

Database Driver: org.mariadb.jdbc.Driver
Default port: 3306
Driver class: org.mariadb.jdbc.Driver
Driver URL: ="jdbc:mariadb://10.134.45.113:3306/<DB_USER_NAME>"
Properties: Add user=<your_db_user_name>

<Context docBase="D:\Journey\workspace\Journey\server\journey\build\libs\journey-0.0.1-SNAPSHOT.war" >
	<Environment name="journey.web.home" value="D:\Journey_Web\" type="java.lang.String"/>
	
	<Resource name="JourneyDS" type="javax.sql.DataSource"
                          maxActive="30" maxIdle="10" maxWait="10000"
                          username="" password="" 
						  driverClassName="org.mariadb.jdbc.Driver"
                          url="jdbc:mariadb://<server>:<port>/journey"/>		

	<Resource name="JourneyReportDS" type="javax.sql.DataSource"
                          maxActive="30" maxIdle="10" maxWait="10000"
                          username="" password="" 
						  driverClassName="org.mariadb.jdbc.Driver"
                          url="jdbc:mariadb://<server>:<port>/report"/>
</Context>

Checklist for Unica Platform database

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:

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

Obtain the following information before deploying Unica Platform:

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

Obtain the following information to install Unica Journey's different components.

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.