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

About this task

Unica Campaign supports Apache Hadoop Hive for customer tables only, not system tables. For details about supported versions, see the Recommended Software Environments and Minimum System Requirements.

Task Description

A. Install a Hive ODBC driver

You can install the DataDirect Hive ODBC Driver from Progress Software, the Cloudera Hive ODBC driver from Cloudera, Inc., or the Hortonworks Hive ODBC driver from Hortonworks, Inc.

B. Configure the Hive ODBC Driver

Configuration includes modifying .ini files and setting path values and environment variables. Be sure to follow the appropriate instructions for the driver that you installed.

C. Map existing HBase tables to Hive (OPTIONAL)

This step is required only if you have existing tables that were created in Apache HBase.

D. Import and configure the BigDataODBCHiveTemplate data source template in Unica Campaign

Use the configTool utility to import the template BigDataODBCHive.xml into Unica Campaign.

Then go to Campaign|partitions|partition[n]| dataSources and create a datasource based on the imported BigDataODBCHiveTemplate.

E. Configure SSH on the Unica Campaign listener server

To enable data file transfers between the Unica Campaign listener (analytic) server and the Hive-based Hadoop big data instance, you must configure SCP and SSH seamless login.

F. Map the Hive datasource in Unica Campaign

Mapping user tables is the process of making external data sources accessible in Unica Campaign.


You can now use your Hive-based Hadoop big data system as a user data source for Unica Campaign. For example, create a marketing campaign flowchart that uses customer account data from your big data instance to target customers with specific account types and balances.