HCL Unica Link Environment Support Details
HCL Unica Campaign and Journey 26.1.0 supports HCL Unica Link version 1.3.2 and earlier supported connectors.
26.1.0 introduces 11 new target connectors spanning CRM, Cloud Storage, Analytics, Email, Push, and Survey:
- CRM: HubSpot CRM and Zoho CRM enable bidirectional contact and lead sync.
- Cloud Storage: GCS, Amazon S3, and Azure Blob Storage for file-based data staging and exchange.
- Analytics: GBQ Event, GA4 User Events, and AppsFlyer for event tracking and mobile attribution.
- Channels: Infobip Direct Email, CT Push, and SurveyMonkey for email, push, and survey response capture.
| Application Server | Operating System | Kafka | Java/JRE |
|---|---|---|---|
|
|
Apache Kafka 3.4.0, 3.9.0 | openjdk "17.0.15" 2025-04-15 OpenJDK Runtime Environment Temurin-17.0.15+6 (build 17.0.15+6) OpenJDK 64-Bit Server VM Temurin-17.0.15+6 (build 17.0.15+6, mixed mode, sharing) |
- Refer to the NodeSource Node.js Binary Distributions page on GitHub for all supported versions of Node.js.
- Support for system and user databases:
- The environment guide does not include supported environments or system requirements for installation of HCL Unica supported databases. Refer to the vendor documentation for the respective databases.
- Support for Oracle database includes both Standard and Enterprise editions.
- JDBC or ODBC drivers are neither bundled nor shipped with Unica products; customers are required to procure and configure them.
- The following are the supported database drivers:
Database Supported Driver(s) MS SQL Server 2014 SP1, 2016 SP1, 2017, 2019, 2022 Version 11 (mssql-jdbc-11.2.4.jre11.jar) PostgreSQL 13.1 PSQL ODBC 13.02 driver (postgresql-42.5.4.jar) Oracle 12c Release (12.1.0.1, 12.1.0.2, 12.2.0.1) Oracle 19c Release (12.2.0.3)
Oracle 23ai
Oracle 12c Driver – 12.x (ojdbc8.jar) Oracle 19c Driver – 19.x (ojdbc8.jar)
Oracle 23.0.0.0.0 ODBC Driver (ojdbc8.jar)
IBM DB2 11.1.x, 11.5, 11.5.9, 12.1.4 DB2JDBC type4 driver (db2jcc4.jar) MariaDB 10.4.x, 10.5.9, 10.6 JDBC - MariaDB Connector/J for Java 8 version 2.5.2 ODBC - MariaDB ODBC Connector 3.1.6 for RHEL 8.6.x and Windows
ODBC - MariaDB ODBC Connector 3.2.2 (for RHEL 9.x)
ODBC - MariaDB ODBC Connector 3.1.9 for SUSE
Amazon Redshift Amazon Redshift ODBC driver (1.4.11.1000 – 64-bit) Amazon Redshift ODBC driver version 2.0.0.3
Unix ODBC driver manager-2.3.7
Actian Vector 5.1.0 Linux - actian-vector-client-6.0.0-129-free-linux-ingbuildx86_64.tgz Windows - same version as Linux
Google BigQuery SIMBA ODBC Driver – Version 2.1.23, 2.5.2.1004 Cloudera Impala ODBC Driver 2.6.13 Singlestore Singlestore ODBC Connector Driver 1.1.1 Trino Build 429 SIMBA ODBC Driver – Version 2.3.6.1000 Hive Database 3.x Hadoop 3.2.0 Hive ODBC Driver version 2.7.0.1002, 2.8.0.1000 Snowflake ODBC Driver 3.6.0
- Only RHEL 8.6.x and 9.x versions are supported in Unica 26.1. HCL Unica does not support RHEL running on IBM PowerSystems.
- This column is applicable for the Unica Campaign family of products. Unica Interact do not support Netezza, Teradata, Amazon Redshift, dashDB, HP Vertica, Databricks or Hadoop for customer profile tables. While using Interact, Campaign and Interact DBs must be of same type, for example, if Campaign system tables are in Oracle, all Interact DBs must also be in Oracle.
- Support for Unica Campaign uses data sources on Big Data platforms:
- Hive based Hadoop Big Data user data source is supported only on RHEL Operating Systems.
- Hadoop Big Data instance running on Hive version 0.14 or higher is supported for the
following vendors:
- IBM BigInsights
- Cloudera CDH
- MapR
- Apache HortonWorks
- Connections to Hive based Hadoop Big Data instances are supported using select type
of drivers and the drivers should be procured directly from the vendor. Following are
the supported drivers:
- Cloudera Hive ODBC Driver version 2.5.16 for Cloudera CDH
- HortonWorks Hive ODBC Driver for Hadoop (Driver version compatible with Hadoop version)
- Progress DataDirect Connect64(R) for ODBC Release 7.1.5 for other supported Big Data vendors
- Progress DataDirect Connect64(R), ODBC Release 7.1.5 version on AIX Operating Systemfor HortonWorks Big Data based on Hive
- Cloudera Impala ODBC Driver 2.5.41 or higher for Cloudera Big Data based on Impala
- The listed drivers are neither bundled nor shipped with Unica Campaign and the customer has to purchase/download and configure them.
- Unica Campaign supports only “TextFile” format with Hive/Impala based Bigdata user data source.
- Kerberos authentication is supported for Unica Campaign data sources on Hive/Impala based Cloudera Big Data platform and requires Campaign Analytical Server (listener) to be running on RHEL Operating system. Please refer to Unica Campaign installation guide for more details.
- Unica Campaign requires a 64-bit driver for DB2 on Windows. IBM DB2 11.1,11.5, 11.5.9 , 12.1.4 is supported for system tables and for Campaign user tables only with BLU turned off.
- DataBricks ODBC Driver Supported Driver(s) : 2.08.00.1002 (Windows) , 2.8.2.1013-1 (RHEL).
- HCL Unica version 26.1 supports RHEL 8.6.x and Rhel 9.3. HCL Unica does not support RHEL running on IBM PowerSystems.
- Unica Campaign supports HP Vertica with the following caveats:
- HP Vertica is supported only on RHEL operating system.
- Users must install the same version of HP Vertica client as the database version.
- IBM DB2 on z/OS is supported only as user data source with the following caveats:
- DB2 10.1 z/OS and 11.0 z/OS with RSU1205 and PUT1205 are supported only with “New Function” mode
- There is no out-of-the-box approach for Loaders on z/OS. Manually, the following
procedure can be followed:
- Set up USS Pipes on z/OS.
- Write a stored procedure to invoke the DSNUTILU and a script to invoke the stored procedure.
- Configure the loader to invoke the script.
- When leveraging temp tables, you must set the parameter “DB2NotLoggedInitially” to “FALSE” in the datasource properties for the database.
- IBM dashDB for Analytics is now known as IBM DB2 Warehouse on Cloud.
- Oracle database connectivity is also supported with ODBC connection, refer to Campaign
Install guide for more details. Oracle Database versions 12.2.x and 19c with native client
connectivity are supported with following caveats:
- On Oracle database server the following parameter needs to be added in “sqlnet.ora” file located under ORACLE_HOME/network/admin/:
SQLNET.ALLOWED_LOGON_VERSION_SERVER- Consult with your DBA for configuring an appropriate value for this parameter.
Please refer to below link for more details:
https://docs.oracle.com/database/121/NETRF/sqlnet.htm#NETRF2016
- Oracle 19c is also supported with ODBC connectivity, user would not be required to edit the sqlnet.ora parameters as mentioned above while connecting with ODBC.
-
Teradata Database versions 16.10, 16.20, 17.0 and 17.20 are supported for Unica Campaign user data source with the following caveat:
- The client and the database version of Teradata needs to be the same.
- Tomcat Application Servers v10.1.55 is supported with the following caveats:
- Oracle JDK/JRE v17 64 bit is required on Windows is required for deployment.
- MariaDB support has below considerations:
- MariaDB is not supported as system tables or user tables on AIX operating system.
- Unica Deliver supports MariaDB from v12.1.0.3 (FP3) onwards.
- Unica Journey supports MariaDB from version 12.1.0.3 (FP3) onwards.
- Unica Campaign supports Actian vector v5.1.0 database as user database from version 12.1.0.4 onwards for RHEL and Microsoft Windows.
- Unica Campaign supports Google BigQuery (multiple datasets are also supported) and Trino as user database, only on RHEL OS (versions 2.1.23, 2.5.2.1004). Unica Campaign supports Singlestore as a user database, only on Microsoft Windows and RHEL OS.
- Unica Campaign supports PostgreSQL version – 14.00.0000 as user database.
- PostgreSQL 13.1 and 14.1 Community PostgreSQL Edition is supported as system database for all Unica products except Insight Reports.