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

About this task

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

Task Description
Install Cloudera Impala ODBC driver

You can install the Cloudera Impala ODBC Driver from Cloudera .

Configure Impala 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.

Import and Configure the BigDataODBCImpala template datasource in Unica Campaign

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

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

Configure SSH on 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.

Map the Impala Datasource in Campaign

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


You can now use your Impala based Cloudera 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.