This topic explains how to install the Hortonworks driver for Apache Hive, which is a fully compliant ODBC driver that supports multiple Hadoop distributions. This topic explains how to install the Cloudera ODBC driver, which is a fully compliant ODBC driver that supports multiple Hadoop distributions. This topic explains how to install the DataDirect driver for Apache Hive, which is a fully compliant ODBC driver that supports multiple Hadoop distributions.
You must install either the DataDirect Hive ODBC Driver from Progress Software or the Cloudera Hive ODBC driver from Cloudera, Inc. This is the first step to integrate HCL® Campaign with Hive-based Apache Hadoop data sources. You must be familiar with the terminology and structure of the integration, and be able to access various resources that are available to support the integration. Integrating Campaign with Hadoop data sources demands extra software that is not part of the standard Campaign installation requirement. The following requirements and restrictions apply to using Hive-based Hadoop data sources with HCL® Campaign. Campaign uses the JDBC connections to access the required databases.įollow these guidelines to use a DB2® database on z/OS® as a data source for Campaign.įollow these guidelines to use a Vertica database as a data source for Campaign.įollow these guidelines to use Amazon Redshift as a data source for Campaign.įollow the steps below to enable Hive-based Apache Hadoop data sources to be used in HCL® Campaign Creating JDBC connections in the web application serverĬreate JDBC connections on each of the web application servers where Campaign is deployed.The location of the JAR file must be included in the class path of the web application server. This enables your web application to connect to the system tables. The web application server where you plan to deploy Campaign must contain the correct JAR file to support JDBC connections. Configuring the web application server for your JDBC driver.Create ODBC or native connections on the computer where you installed the Campaign server. Creating ODBC or native connections on the Campaign machineĬreate ODBC or native connections so that the Campaign server can access the Campaign database.
If you have multiple partitions, create data sources for each partition where you want to enable IBM Campaign. To ensure that the system tables will be mapped automatically, the ODBC name for that database must be UA_SYSTEM_TABLES. The empty database that you set up for the system tables can have any name.
The IBM® Campaign system tables hold application data. Creating database or schema for the Campaign system tables.The Campaign runtime environment uses data sources to store user and interaction data. Preparing data sources for HCL Campaign.When you plan your Campaign and Attribution Modeler installation, you must ensure that you have set up your system correctly, and that you have configured your environment to deal with any failures. Use the Installation Roadmap section to obtain a broad understanding about using the Installation Guide. The Installation Guide provides detailed information about installation and configuration.