Home
Integration guides
Unica Campaign and Acoustic Campaign Integration Guide for IBM Marketing Cloud
Configuring the Unica Campaign and Acoustic Campaign integration
To ensure a successful integration of Campaign and Acoustic Campaign, the following products must be configured: Unica Campaign, Acoustic Campaign, IBM UBX, and IBM UBX Toolkit.
Creating response tracking tables for the integration
Creating response tables is a one-time task that is performed as part of the integration configuration. However, if you are using Unica Campaign version 10.0.0.1 or later, this step is not applicable for your setup. From Unica Campaign version 10.0.0.1 onwards, when you use Unica Campaign to download events, the response tracking tables are created automatically.

Integration guides
- Unica Campaign and Acoustic Campaign Integration Guide for IBM Marketing Cloud
  - Overview of the Unica Campaign and Acoustic Campaign integration
    The integration of Unica Campaign and Acoustic Campaign combines the marketing segmentation tools of Unica Campaign with the messaging capabilities of IBM Marketing Cloud.
  - Configuring the Unica Campaign and Acoustic Campaign integration
    To ensure a successful integration of Campaign and Acoustic Campaign, the following products must be configured: Unica Campaign, Acoustic Campaign, IBM UBX, and IBM UBX Toolkit.
    - Provisioning requirements for Unica Campaign, Acoustic Campaign, and UBX
      Before administrators can configure the integration, IBM Provisioning must prepare Acoustic Campaign, and UBX for integration. Unica Campaign also requires some configurations for integration.
    - Acoustic Campaign configuration requirements for Unica Campaign offer integration
      Unica Campaign offers are available in Acoustic Campaign. To enable integration you must provide the required information to your Acoustic Campaign Provisioning Team.
    - Configuring WebSphere for use with Acoustic Campaign
      Part of configuring the integration between Campaign and Acoustic Campaign involves configuring the Campaign web application server to communicate with Acoustic Campaign. Follow these instructions if Campaign uses WebSphere Application Server (WAS) as the web application server.
    - Configuring WebSphere for use with UBX
      Part of configuring the integration between Unica Campaign and IBM UBX involves configuring the Unica Campaign web application server to communicate with UBX. Follow these instructions if Campaign uses WebSphere Application Server (WAS) as the web application server.
    - Configuring WebLogic for use with Acoustic Campaign
      Part of configuring the integration between Unica Campaign and Acoustic Campaign involves configuring the Unica Campaign web application server to communicate with Acoustic Campaign. Follow these instructions if Unica Campaign uses WebLogic as the web application server.
    - Configuring a user account and data sources for Acoustic Campaign
      To allow Unica Campaign to access Acoustic Campaign, a Unica Campaign administrator must configure a user account with credentials to access the Acoustic Campaign integration services, then define data sources under that account.
    - Setting configuration properties
      You must set the configuration properties that control authentication and data exchange between Unica Campaign, Acoustic Campaign, and IBM UBX.
    - Registering Unica Campaign Endpoint as a Subscriber in UBX
      In an integrated environment, to download events from UBX, you must register Campaign Endpoint as a subscriber in UBX.
    - Installing and configuring UBX Toolkit for the integration
      To support response tracking from Acoustic Campaign to Unica Campaign, you must install and configure the UBX Toolkit. The UBX Toolkit installs behind your corporate firewall to securely connect Unica Campaign and its databases to UBX APIs and the IBM Commerce ecosystem.
    - Creating response tracking tables for the integration
      Creating response tables is a one-time task that is performed as part of the integration configuration. However, if you are using Unica Campaign version 10.0.0.1 or later, this step is not applicable for your setup. From Unica Campaign version 10.0.0.1 onwards, when you use Unica Campaign to download events, the response tracking tables are created automatically.
    - Configuring UBX for the integration
      This task involves using UBX to configure event producer endpoints and subscribe Campaign to events. This task is required to support response tracking from Acoustic Campaign to Unica Campaign.
    - Setting the sync field for audience information
      When you complete a test run or a production run, audience information is exported by Unica Campaign to Acoustic Campaign. For the Email and Push processes, you can specify the fields that must be used as sync fields for the audience information.
    - Unica Campaign and Acoustic Campaign integration logs
      When Unica Campaign and Acoustic Campaign are integrated, Unica Campaign Acoustic Campaign import service execution logs can be enabled in campaign_log4j.properties file available in the <Campaign_home>/conf/ folder.
  - Email: using Unica Campaign and Acoustic Campaign
    If Unica Campaign and Acoustic Campaign are integrated, you can use Unica Campaign to send personalized email communications from Acoustic Campaign.
  - SMS text messaging: using Campaign and Acoustic Campaign
    If Unica Campaign is integrated with Acoustic Campaign, you can you can use Unica Campaign to send SMS text messages from Acoustic Campaign.
  - Mobile push: using Unica Campaign and Acoustic Campaign
    If Unica Campaign and Acoustic Campaign are integrated, you can use Unica Campaign to send mobile push notifications from Acoustic Campaign.
  - Response tracking tables for the integration
    To support the Campaign and Acoustic Campaign integration, response tracking tables are required to store data about user responses to email, SMS, and push events.
- Unica Plan and Unica Campaign Integration Guide

Creating response tracking tables for the integration

Creating response tables is a one-time task that is performed as part of the integration configuration. However, if you are using Unica Campaign version 10.0.0.1 or later, this step is not applicable for your setup. From Unica Campaign version 10.0.0.1 onwards, when you use Unica Campaign to download events, the response tracking tables are created automatically.

Before you begin

The UBX Toolkit must be installed and configured.
You must have administrative access to install and configure files on the database server where you will create the tables.

About this task

Response tracking tables are required to store event data about customer responses. Events include information about customer actions such as opens, clicks, and bounces. The tables that you create will be populated when users run UBX Toolkit scripts to download and then import data. Unica Campaign can then access the populated tables as data sources in flowcharts.

Procedure

The UBX Toolkit provides DDL sample scripts for SQL, DB2, and Oracle. Use the appropriate script to create database tables in the desired format.

Tip: By examining the script files in a text editor, you can see the fields and data types that will be created, and you can easily identify the primary keys.
Use the database table mapping file (EventToDBTableMapping.xml) provided in the UBX Toolkit to match event data to field names in the database tables. This determines how data gets inserted into the tables.
To learn more about using and managing tracking tables, see Response tracking tables for the integration.
To see which events can be stored in the response tracking tables, see Email: Response tracking.

What to do next

The next step is to configure UBX. See Configuring UBX for the integration.

Have feedback?
Google Analytics is used to store comments and ratings. To provide a comment or rating for a topic, click Accept All Cookies or Allow All in Cookie Preferences in the footer of this page.