Unica Interact upgrade worksheet
Use the Unica Interact upgrade worksheet to gather information about the database that contains your Unica Interact upgrade system tables and about other Unica products that are required for upgrading Unica Interact.
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 required to upgrade the Unica Interact runtime environment
Gather information about your Unica Interact runtime installation before you run the Unica Interact runtime environment upgrade tools.
aciUpgradeTool_runtab
Collect the following information about the configuration of the target system:
- The directory where Unica Platform is installed.
- Full path of the Unica Interact configuration file (interact_configuration.xml). The file is in the conf directory under the Unica Interact installation.
If you connect to the runtime environment system tables by using the web application server, collect the following information:
- Host name
- Port
- User name
- Password
- For WebLogic: Full path and file name of the WebLogic JAR file
If you connect to the runtime environment system tables by using JDBC, collect the following information:
- Java™ class name for the JDBC driver
- JDBC URL
- Additional properties that are required by the JDBC driver
- Database user name and password
Collect the following information about the target runtime environment database:
- Catalog (or database) containing the target runtime environment system tables
- Schema
- Whether the tables are configured for Unicode
- If Learning is enabled, for version 2, using SampleMethod1, for version 1, using SampleMethod1.
- During the interact configuration process, system verifies if the setting are matching.
- During the interact offer treatment optimizer process in learning version2, the offer learning is handles based on SampleMethod1 and SampleMethod2 setting.
- The offer RWA is calculated based on SampleMethod1 and SampleMethod2 settings.
Collect the following information about the Unica Interact installation on the source system:
- Version of Unica Interact you are upgrading from
aciUpgradeTool_lrntab
Collect the following information about the configuration of the target system:
- The directory where Unica Platform is installed
If you connect to the learning tables by using the web application server, collect the following information:
- Host name
- Port
- User name
- Password
- For WebLogic: Full path and file name of the WebLogic JAR file
If you connect to the learning tables by using JDBC, collect the following information:
- Java class name for the JDBC driver
- JDBC URL
- Additional properties that are required by the JDBC driver
- Database user name and password
Collect the following information about the target learning database:
- Catalog (or database) containing the target learning tables
- Schema
- Whether the tables are configured for Unicode
Collect the following information about the Unica Interact installation on the source system:
- Version of Unica Interact you are upgrading from
aciUpgradeTool_crhtab
Collect the following information about the configuration of the target system:
- The directory where Unica Platform is installed
If you connect to the contact history tables for cross-session response by using the web application server, collect the following information:
- Host name
- Port
- User name
- Password
- For WebLogic: Full path and file name of the WebLogic JAR file
If you connect to the contact history tables for cross-session response by using JDBC, collect the following information:
- Java class name for the JDBC driver
- JDBC URL
- Additional properties that are required by the JDBC driver
- Database user name and password
Collect the following information about the target contact history tables for cross-session response database:
- Catalog (or database) containing the target contact history tables for cross-session response
- Schema
- Whether the tables are configured for Unicode
Collect the following information about the Unica Interact installation on the source system:
- Version of Unica Interact you are upgrading from
aciUpgradeTool_usrtab
Collect the following information about the configuration of the target system:
- The directory where Unica Platform is installed
If you connect to the user profile tables by using the web application server, collect the following information:
- Host name
- Port
- User name
- Password
- For WebLogic: Full path and file name of the WebLogic JAR file
If you connect to the user profile tables by using JDBC, collect the following information:
- Java class name for the JDBC driver
- JDBC URL
- Additional properties that are required by the JDBC driver
- Database user name and password
Collect the following information about the target user profile database:
- Catalog (or database) containing the target user profile tables
- Schema
- Whether the tables are configured for Unicode
Collect the following information about the Unica Interact installation on the source system:
- Version of Unica Interact you are upgrading from
Information required to upgrade the Unica Interact design time environment
Gather information about your Unica Interact design time installation before you run the Unica Interact design time environment upgrade tool.
aciUpgradeTool
Collect the following information about the configuration of the target system:
- The name of the partition you are upgrading.
- The directory where Unica Platform is installed.
- Full path to the Unica Campaign configuration file (campaign_configuration.xml). The Unica Campaign configuration file is in the conf directory under your Unica Campaign installation.
If you connect to the design time environment system tables by using the web application server, collect the following information:
- Host name
- Port
- User name
- Password
- For WebLogic: Full path and file name of the WebLogic JAR file
If you connect to the design time environment system tables by using JDBC, collect the following information:
- Java class name for the JDBC driver
- JDBC URL
- Additional properties that are required by the JDBC driver
- Database user name and password
Collect the following information about the target design time environment database:
- Catalog (or database) containing the target design time environment system tables
- Schema
- Whether the tables are configured for Unicode
Collect the following information about the Unica Interact installation on the source system:
- Version of Unica Interact that you are upgrading from