What's new in IBM Campaign 9.1.2

All product documentation is now available in the IBM Knowledge Center at:

http://www.ibm.com/support/knowledgecenter/

You can browse or search within or across product families to find the topics that you need. To search within a single product, expand a product family in the Table of Contents, select a product, then enter your search term. Click the X in the toolbar to clear the Search Filter. For more information, click the Help icon at the top right of the toolbar.

IBM Campaign v9.1.2 supports the Traditional Chinese locale.

Users can also select Traditional Chinese when installing IBM EMM products.

IBM Campaign v9.1.2 has the following flowchart tab design change.

If a campaign has many flowcharts, they are displayed in a single row, in a tabbed interface. Use the icons (First, Previous, Next) to the right of the tabs to navigate to other flowchart tabs. To see all flowchart tabs, click the Expand icon (+), then use the Collapse icon (-) to return to the single-row view.

You can use the browser search function (for example, Ctrl+F) to search for a flowchart tab. You may need to expand the view (+) in order to see the highlighted search result.

IBM Campaign v9.1.2 introduces a REST API for interacting with campaigns, offers, offer lists, attributes, and target cell objects.

Information about the IBM Campaign REST API is provided in the IBM Knowledge Center.

IBM Marketing Platform provides the security framework for the API. Choose Settings > Configuration and use the configuration properties in the IBM Marketing Platform | Security |API management category.

IBM dashDB is supported as a user data source for IBM Campaign v9.1.2.

IBM dashDB is a fully managed cloud data warehousing service that is available through Cloudant and Bluemix platforms.

IBM dashDB uses the existing DB2Template.xml in IBM Campaign. The dashDB data structure is similar to IBM DB2 BLU.

HP Vertica is supported as a user data source for IBM Campaign v9.1.2.

Use the existing PostgreSQLTemplate.xml. All basic (standard) data types are supported. The COPY command is not supported in the current version of this release.

Amazon Redshift is supported as a user data source, using the PostgreSQL ODBC driver.

Use the newly introduced PostgreSQLTemplate as the data source template in IBM Campaign.

Amazon Redshift user database with Campaign is supported on Windows and Linux operating systems only. Amazon Redshift database is not supported for system tables.

For information about using Amazon Redshift as a data source, see the following documentation or search the IBM Knowledge Center:

Document	Information about Amazon Redshift support
IBM Campaign Release Notes	Changes to IBM Campaign configuration settings for 9.1.2 Known issues and limitations
Recommended Software Environments and Minimum System Requirements	Details about supported versions
IBM Campaign Installation Guide	Preparing Amazon Redshift user data sources for Campaign
IBM Campaign Administrator's Guide	Using Amazon Redshift user data sources with IBM Campaign Supported data types for Amazon Redshift Configuration settings for PostgreSQLTemplate (Campaign|partitions|partition[n]| dataSources)

Apache Hadoop Hive is supported as a user data source, using either the Cloudera ODBC Driver for Hive or the DataDirect Apache Hive ODBC driver.

Use the newly introduced BigDataODBCHiveTemplate as the data source template in IBM Campaign.

Hive-based big data integration with Campaign is supported on the Linux operating system only. Campaign and Hive-based big data as a user database is not tested with Campaign installed on MS Windows. Big data Hive-based database is not supported for system tables.

For information about using Apache Hadoop Hive as a Campaign data source, see the following documentation or search the IBM Knowledge Center:

Document	Information about Hive support
IBM Campaign Release Notes	Requirements and restrictions for Hive-based Hadoop data sources Configuration settings related to Hive support Known issues and limitations related to Hive support
Recommended Software Environments and Minimum System Requirements	Details about supported versions.
IBM Campaign Installation Guide	Requirements and restrictions for Hive-based Hadoop data sources Preparing Apache Hadoop Hive user data sources for Campaign, including installing and configuring a Hive ODBC driver, importing and configuring the BigDataODBHHiveTemplate data source in Campaign, mapping the Hive data source in Campaign, and configuring SSH on the Campaign listener server. Overview of the Campaign integration with Hadoop Integration architecture Terminology and resources for Hive Hadoop
IBM Campaign Administrator's Guide	Using Hive-based Hadoop data sources with Campaign Exporting data from Campaign to a Hive-based Hadoop system Hive query language conformance Supported data types for Apache Hadoop Hive Configuration settings for BigDataODBCHiveTemplate (Campaign|partitions|partition[n]| dataSources)

The following requirements and restrictions apply to using Hive-based Hadoop data sources with IBM Campaign.

• One of the following drivers is required. The customer is responsible for obtaining the driver.
  • DataDirect Apache Hive ODBC driver from Progress.com: DataDirect Connect64(R) for ODBC Release 7.1.5.
  • Cloudera ODBC Driver for Apache Hive Version 2.5.16 for Apache Hadoop Hive from Cloudera, Inc.
• The following Hadoop distributions are supported, with Apache Hive as the connection point: Cloudera, Hortonworks, IBM BigInsights ™, MapR.
• Minimum supported Hive version: 0.14
• The integration is currently supported on Linux RHEL 6.3 or higher.
• Hive-based Hadoop is supported as a user data source only. It is not supported for Campaign system tables.
• The integration does not currently support the IBM Campaign Cube, Optimize, or Interact List process boxes or eMessage Landing Pages in an Extract process box.
• You can use a Hive-based Hadoop user data source on an IBM Campaign system that is integrated with IBM SPSS-MA Marketing Edition and also with an IBM Campaign and Digital Analytics integration.

To support Apache Hadoop Hive and Amazon Redshift as user data sources, two new data source XML templates were added, and related changes were made to the Campaign|partitions|partition[n]|dataSources|<dataSourcename> configuration settings.

Two new data source XML templates were added:

• To support Amazon Redshift as a user database: ..Campaign\conf\PostgreSQLTemplate.xml
• To support Hive-based big data as a user database: ..Campaign\conf\BigDataODBCHiveTemplate.xml

The following configuration changes are related to the new templates. To access configuration settings, choose Campaign > Settings and select Campaign|partitions|partition[n]|dataSources|<dataSourcename>.

For details about configuration settings, see the IBM Campaign Administrator's Guide.

• A new configuration property called HiveQueryMode was added. This property is used only for Hive-based Hadoop data sources (BigDataODBCHiveTemplate). It provides a way to switch between the DataDirect and Cloudera drivers. For DataDirect, select Native. For Cloudera, select SQL.
• New configuration properties called LoaderPreLoadDataFileCopyCmd and LoaderPostLoadDataFileRemoveCmd were added. These properties are only for Hive-based Hadoop data sources (BigDataODBCHiveTemplate). These properties are used to copy and remove temporary data files as part of the Campaign and Apache Hive-based Hadoop big data integration.
• For DateFormat, note the following information if you are using Hive-based Hadoop big data data sources: All Date strings (Date, DateFormat, DateTimeFormat, DateTimeOutputFormatString) must use the dash "-" character to format dates. Hive does not support any other characters for dates. Example: %Y-%m-%d %H:%M:%S
• Hive-based Hadoop does not support the Tab (/t) character as a LoaderDelimiter value.
• The LoaderDelimiter value must match the ROW format delimiter that was used when the big data database table was created. This applies to both Hive and Amazon Redshift. In the following example, a comma is used:

  ROW FORMAT DELIMITED FIELDS TERMINATED BY ',' ;"

• The Type property supports two new types for customer tables: BigDataODBC_Hive and PostgreSQL.
• The UseExceptForMerge property must be FALSE for Hive-based Hadoop big data. Hive does not support the EXCEPT clause, so a setting of TRUE can result in process failures.