C. Configure the Impala ODBC Driver
This is the second step to integrate Unica Campaign with Impala-based Cloudera data sources. You must configure the driver that you installed (Cloudera Impala ODBC driver from Cloudera, Inc.).
Before you begin
Complete the Cloudera Impala ODBC driver installation that is described in “Installing the Cloudera ODBC driver"
Procedure
1. Modify the ODBC.ini file to specify the Impala connector information, using the values shown in the following example. Be sure to customize the items in bold to match your own configuration.
Note: Do not enable Native Query mode in the configuration.
[Cloudera Impala]
Description=Cloudera ODBC Driver for Impala (64-bit) DSN
Driver=/opt/cloudera/impalaodbc/lib/64/libclouderaimpalaodbc64.so
HOST=<Impala Host>
PORT=<Impala port - default is 21050>
Database=<Database name>
Schema=<Database schema>
AuthMech=3
UseSASL=0
UID=<impala user id>
PWD=<password>
SSL=0
TSaslTransportBufSize=1000
RowsFetchedPerBlock=10000
SocketTimeout=0
StringColumnLength=32767
UseNativeQuery=1
Note: The UID is the user ID of the Cloudera cluster database.
2. Assuming that your ODBC driver is installed in the following location /opt/cloudera/impalaodbc/lib/64/libclouderaimpalaodbc64.so
Make the following change in Campaign/bin/setenv.sh:
Set LD_LIBRARY_PATH (LIBPATH for AIX) to include Cloudera LIB and UnixODBC LIB as follows.
LD_LIBRARY_PATH=/opt/HCL/Campaign/bin:/opt/ibm/db2/V10.1/lib64/:/usr/lib:/lib:/opt/cloudera/impalaodbc/lib/64/:/usr/local/lib/
export LD_LIBRARY_PATH
ODBCINI=/usr/local/etc/odbc.ini # You can use the ODBC INI from Cloudera Impala ODBC Driver install location as well
export ODBCINI