Preparing Apache Hadoop Hive user data sources for Campaign

Follow the steps below to enable Hive-based Apache Hadoop data sources to be used in HCL® Campaign

About this task

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 Campaign	Use the configTool utility to import the template BigDataODBCHive.xml into Campaign. Then go to Campaign\|partitions\|partition[n]\| dataSources and create a datasource based on the imported BigDataODBCHiveTemplate.
E. Configure SSH on the Campaign listener server	To enable data file transfers between the IBM 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 Campaign	Mapping user tables is the process of making external data sources accessible in Campaign.

Results

You can now use your Hive-based Hadoop big data system as a user data source for HCL 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.