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