A. Install a Cloudera Impala ODBC driver

This is the first step to integrate Unica Campaign with Impala-based Cloudera data sources. You must install the Cloudera Impala ODBC driver from Cloudera, Inc.

Install the Impala ODBC driver on the system where you have installed the Unica Campaign Analytical Server. If the Analytical Server is installed in a cluster, install the Impala ODBC driver on each system.

Installing the Cloudera Impala ODBC driver. This topic explains how to install the Cloudera Impala ODBC driver, which is a fully compliant ODBC driver that supports multiple Hadoop distributions.

Procedure

1.Obtain the Cloudera Impala ODBC Driver for version 2.5.41 at https://www.cloudera.com/downloads/connectors/impala/odbc/ . Download and save the Cloudera Impala ODBC driver on the Unica Campaign listener (analytic server). The default location is /opt/cloudera/

2. Install and configure the Cloudera driver. Installation instructions are downloaded to where you install the driver. By default, the instructions are downloaded to /opt/cloudera/impalaodbc/Cloudera-ODBC-Driver-for-Impala-Install-Guide.pdf. The PDF file is also available online at www.cloudera.com.

3. Download and install UnixODBC Manager, unixODBC-2.3.2 on the Unica Campaign listener (analytic server). Download UnixODBC Manager from the unixODBC Project at http://www.unixodbc.org/. The UnixODBC Manager is available in a gzip, tar format. The steps to install UnixODBC are available at http://www.unixodbc.org/download.html. To create a unixODBC directory that contains the required source files:a. Copy the unixODBC-2.3.2.tar.gz file to the Unica Campaign listener (analyticserver).b. gunzip unixODBC-2.3.2.tar.gzc. tar xvf unixODBC-2.3.2.tar

4. On the Unica Campaign listener, run rpm -ivh ClouderaImpalaODBC-2.5.41.1029-1.el6.x86_64.rpm.