Welcome
Installation Guides
Installation Guide
An installation of HCL Unica products is complete when you install, configure, and deploy the HCL Unica products . The Installation Guide provides detailed information about installing, configuring, and deploying the products.
Preparing data sources for Unica Campaign
The Unica Campaign runtime environment uses data sources to store user and interaction data.
Preparing DataBricks database as user database datasource for Unica Campaign

Unica Campaign
Release Notes
System Requirements
Installation Guides
- Installation Guide
  An installation of HCL Unica products is complete when you install, configure, and deploy the HCL Unica products . The Installation Guide provides detailed information about installing, configuring, and deploying the products.
  - Installation overview
    An installation of HCL Unica products is complete when you install, configure, and deploy the HCL Unica products . The Installation Guide provides detailed information about installing, configuring, and deploying the products.
  - Planning the Unica Campaign Installation
    When you plan your Unica Campaign and Unica Optimize installation, you must ensure that you have set up your system correctly, and that you have configured your environment to deal with any failures.
  - Preparing data sources for Unica Campaign
    The Unica Campaign runtime environment uses data sources to store user and interaction data.
    - Prerequisites of Oracle 12c or Oracle 19.x database before Unica Campaign installation
    - Creating database or schema for Unica Campaign system tables
      The Unica Campaign system tables hold application data. The empty database that you set up for the system tables can have any name. To ensure that the system tables will be mapped automatically, the ODBC name for that database must be UA_SYSTEM_TABLES. If you have multiple partitions, create data sources for each partition where you want to enable Unica Campaign.
    - Creating ODBC or native connections
      Create ODBC or native connections so that the Unica Campaign server can access the Unica Campaign database. Create ODBC or native connections on the computer where you installed the Unica Campaign server.
    - Configuring the web application server for your JDBC driver
    - Creating JDBC connections in web application server
      Create JDBC connections on each of the web application servers where Unica Campaign is deployed. Unica Campaign uses the JDBC connections to access the required databases.
    - Preparing datasource for Unica Campaign using ODBC Connection
    - Preparing MariaDB datasource for Unica Campaign
    - Preparing Postgres datasource for Unica Campaign
    - Preparing DB2 on z/OS user datasource for Unica Campaign
      Follow these guidelines to use a DB2® database on z/OS® as a data source for Unica Campaign.
    - Preparing Vertica datasources for Unica Campaign
      Follow these guidelines to use a Vertica database as a data source for Unica Campaign.
    - Preparing Amazon Redshift user data sources for Unica Campaign
      Follow these guidelines to use Amazon Redshift as a data source for Unica Campaign.
    - Preparing Apache Hadoop Hive user data sources for Unica Campaign
      Follow the steps below to enable Hive-based Apache Hadoop data sources to be used in Unica Campaign
    - Preparing Cloudera Hadoop Impala based user data sources for Unica Campaign
      Follow the steps below to enable Impala based Cloudera Hadoop data sources to be used in Unica Campaign
    - Preparing Cloudera BigData instance using Kerberos authentication
    - Preparing Actian Vector user data source for Campaign
    - Preparing DataBricks database as user database datasource for Unica Campaign
    - Preparing AWS Athena database as user database datasource for Unica Campaign
      Unica Campaign supports Athena as User databases. For AIX it is not supported.
    - Preparing Snowflake database as user database datasource for Unica Campaign
      Unica Campaign supports Snowflake as User databases. For AIX and SUSE we do not support Snowflake as a User Database.
  - Installing Unica Campaign and Unica Optimize
    You must run the Unica installer to start the installation of Unica Campaign and Unica Optimize. The Unica installer starts the product installer during the installation process. Make sure that the Unica installer and the product installer are saved at the same location.
  - Configuring Unica Campaign and Unica Optimize before deployment
    Before you deploy, create and populate the Unica Campaign , Unica Optimize, and Unica Deliver system tables and register Unica Campaign, Unica Optimize, and Unica Deliver manually.
  - Deploying the Unica Campaign web application
    You can deploy the Unica Campaign web application by using an EAR file or you can deploy the individual WAR files.
  - Configuring Unica Campaign and Unica Optimize after deployment
    After you deploy Unica Campaign, you must verify that the Unica Campaign listener is running, set up the Unica Campaign system user, set Unica Campaign configuration properties, and verify the Unica Campaign installation.
  - Configuring multiple partitions for Unica Campaign
    In the Unica family of products, partitions provide a way to secure the data that is associated with different groups of users. When you configure Unica Campaign or a related Unica application to operate with multiple partitions, users can see each partition as a separate instance of the application. There is no indication that other partitions exist on the same computer.
  - Configuring multiple partitions for Unica Optimize
    In the Unica family of products, partitions provide a way to secure the data that is associated with different groups of users. When you configure Unica Campaign or a related Unica application to operate with multiple partitions, users can see each partition as a separate instance of the application. There is no indication that other partitions exist on the same computer.
  - Configuring multiple partitions in Deliver
    Configure multiple partitions in Unica Deliver to isolate and secure data for different groups of Unica Deliver users. As each partition has its own set of configuration properties, you can customize Unica Deliver for each group of users.
  - Unica Platform utilities
    This section provides an overview of the Unica Platform utilities, including some details that apply to all the utilities and which are not included in the individual utility descriptions.
  - Uninstalling Unica Campaign and Unica Optimize
    Run the Unica Campaign and Unica Optimize uninstaller to uninstall Unica Campaign and Unica Optimize. When you run the uninstaller, the files that were created during the installation process are removed. For example, files such as configuration files, installer registry information, and user data are removed from the computer.
  - Unica Campaign web application clustering
    You can configure the Unica Campaign web application (J2EE application) in a cluster by completing additional tasks during the Unica Campaign installation.
  - Installing a clustered listener environment
    Follow these instructions if you want to install a clustered listener configuration. A listener cluster is a set of two or more listeners that act as a unit to provide load balancing and high availability. Unica Campaign listener clusters are Active-Active; meaning each node serves requests using the load-balanced approach. Each Unica Campaign listener provides an interface between front-end clients (such as the Unica Campaign web application) and back-end analytical server processes.
Upgrade Guide
User Guide
Unica Campaign is a web-based solution that enables you to design, run, and analyze direct marketing campaigns.
Administrator Guides
Troubleshooting and Tuning
Performance depends on many factors, including your database and web server configuration, network connectivity and other configurations.
API Guides
Reports
Developer Guides
Campaign and SPSSMA
Integration guides
GDPR Guide
There are several basic concepts that can help you understand how to use Unica Campaign to create and manage marketing campaigns.
Licensing Guide
PDFs
Glossary
Notices

Preparing DataBricks database as user database datasource for Unica Campaign

About this task

Unica Campaign supports DataBricks as User databases. For AIX and SUSE we do not support DataBricks as User Database.

DataBricks ODBC Driver Installation

Install the DataBricks ODBC Driver where the Unica Campaign analytical server (listener) is installed.

Windows DataBricks ODBC Driver : 2.08.00.1002
Download link : https://www.databricks.com/spark/odbc-drivers-archive
RHEL DataBricks ODBC Driver : 2.8.2.1013-1
Download link : https://www.databricks.com/spark/odbc-drivers-archive

Windows:

Create DSN for DataBricks User database in Windows ODBC Manager:
- Open ODBC Administrator GUI
- Click Add button
- From the list select Simba Spark ODBC Driver 2.08.00.1002 Driver.
- Click the Finish button. This will open a new windows Create a new Data Source to DataBricksDB.
- Mention DSN name in Data Source Name.
- Mention Spark Server Type
- Mention appropriate Host(s), Port and DataBase
- Mention User name and Password. Click Test button to check db connection
- Mention Thrift Transport as HTTP and give respective values to HTTP Options and SSL Options.
- Click on OK.
Import DatabricksTemplate.xml in Unica Campaign data source template.

Linux

Create ODBC DSN for DataBricks:

Sample example odbc.ini file entry

[Databricks]
Driver=<DRIVER_PATH>/libsparkodbc_sb64.so
Host=<HOST NAME>
Port=443
HTTPPath=<HTTP PATH>
SSL=1
ThriftTransport=2
Schema=<SCHEMA NAME>
AuthMech=3
UID=token
PWD=<TOKEN VALUE>

Setup up setenv.sh with below entries.

LD_LIBRARY_PATH=<CAMPAIGN_HOME>/bin:<DB HOME LIB PATH>:<DataBricks DRIVER LIB PATH>:<OS LIB PATH>
export LD_LIBRARY_PATH
ODBCINI=/etc/odbc.ini
export ODBCINI
ODBCINST=/etc/odbcinst.ini
export ODBCINST

Test the connection using isql or the Campaign CxnTest and odbctest utility.
Import DatabricksTemplate.xml datasource template for DataBricks and configure it.

Note: For DataBricks, we recommended you to use the DataBricks Loader to get optimum performance. To configure the loader, contact HCL Unica Support team for assistance.