Installation worksheet

Use the installation worksheet to gather information about the database that contains your system tables and about other Unica products that are required for the installation of Unica Interact.

Note: All the Interact data sources must be of the same type. For example, if your Unica Campaign system tables are in Oracle databases, all the other databases must be Oracle.

Runtime tables

Runtime tables contain deployment data from the design time environment, staging tables for contact and response history, and runtime statistics.

Enter the database information for each runtime environment in the following table:

Table 1. Information for the Unica Interact runtime environment

This two-columned table provides information about the database in one column. The second column is for the user. The user must enter information about the database in the second column.
Database information Notes®

Database schema 1

JNDI name 1

Contact response history tables

Contact response history tables are used when you implement cross-section tracking. The contact response history tables can be in the same schema as your Unica Campaign contact response history tables, or they can be in a different database server or schema.

Enter the database information for the contact response history tables in the following table:

Table 2. Information for the Interact contact response history tables

This two-columned table provides information about the database in one column. The second column is for the user. The user must enter information about the database in the second column.
Database information Notes

Database schema

JNDI name

Learning tables

Learning tables are used only if you want to use the Interact built-in learning feature. Learning tables are optional.

Enter the database information for the learning tables in the following table:

Table 3. Information for the Interact learning tables

This two-columned table provides information about the database in one column. The second column is for the user. The user must enter information about the database in the second column.
Database information Notes

Database schema

JNDI name

User profile tables

User profile tables contain customer data that is required by interactive flowcharts to place visitors into smart segments.

Enter the database information for the user profile tables in the following table:

Table 4. Information for the Interact user profile tables

This two-columned table provides information about the database in one column. The second column is for the user. The user must enter information about the database in the second column.
Database information Notes

Database schema

JNDI name

Test run tables

Test run tables are used for test runs of interactive flowcharts only. Test run tables contain data that is required by interactive flowcharts to place visitors into smart segments.

Enter the database information for the test run tables in the following table:

Table 5. Information for the Interact test run tables

This two-columned table provides information about the database in one column. The second column is for the user. The user must enter information about the database in the second column.
Database information Notes

Database schema

DSN (ODBC or native connection name)

JNDI name

Unica Platform database information

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:

  • Database type
  • Database host name
  • Database port
  • Database name or schema ID
  • User name and password for the database account
  • JDBC connection URL to the Unica Platform database

Information about the web component

Obtain the following information for all Unica products that have a web component, which you deploy on a web application server:
  • The name of the systems on which the web application servers are installed. You can have one or several web application servers, depending on the Unica environment you are setting up.
  • 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, example.com.