Home
Administrator Guides
Administrator Guide
Database table administration
Unica Campaign administrators must perform initial one-time tasks and routine administration tasks that pertain to database tables.
User table administration
Unica Campaign administrators typically perform the following tasks pertaining to user tables.
Mapping and unmapping user tables
User tables contain customer data for use in marketing campaign flowcharts. User tables must be mapped in Unica Campaign to make them available in flowcharts.
Guidelines for mapping user tables
Follow these guidelines when you create mapped table and field names.

Administrator Guides
- Administrator Guide
  - Unica Campaign administration overview
    The Settings menu provides access to most of the tasks that Unica Campaign administrators typically perform.
  - Security in Unica Campaign
    Security policies control user access to the objects and features in Unica Campaign.
  - Database table administration
    Unica Campaign administrators must perform initial one-time tasks and routine administration tasks that pertain to database tables.
    - Table administration concepts
      The following concepts pertain to system tables, user tables, flat files, and table mapping.
    - Initial table administration tasks
      Administrators must perform several initial table-related tasks after Unica Campaign is installed.
    - User table administration
      Unica Campaign administrators typically perform the following tasks pertaining to user tables.
      - Adding new user data sources to Unica Campaign
        Organizations can use their own databases and flat files as data sources in Unica Campaign flowcharts. For example, an organization might store customer names and addresses in DB2® and customer purchase history in SQL Server. Other organizations might have a distributed big data system, along with some flat files.
      - Creating new user tables through an output process
        You can create new user tables by exporting data from an output process, such as Snapshot, Call List, or Mail List.
      - Accessing data sources from within a flowchart
        To access user data from within a flowchart, ensure that you are logged in to each database that is acting as a data source.
      - Supported data types for user tables
        Before you map user tables in Unica Campaign, ensure that your tables use only the supported data types for each supported database. Data types that are not listed here are not supported.
      - Using Amazon Redshift user data sources with Unica Campaign
        Unica Campaign supports Amazon Redshift as a user data source. Redshift is not supported for system tables.
      - Using MariaDB datasources with Unica Campaign
      - Google BigQuery ODBC.ini configuration
        Navigate to /opt/simba/googlebigqueryodbc/Setup and Configure odbc.ini
      - Using Hive-based Hadoop big data sources with Unica Campaign
        Unica Campaign supports the ability to use Hive™ based implementations of Apache Hadoop® as a user data source.
      - Using Cloudera Impala-based Hadoop big data sources with Unica Campaign
        Unica Campaign supports the ability to use Cloudera Impala™ based implementations of Hadoop® as a user data source.
      - Mapping and unmapping user tables
        User tables contain customer data for use in marketing campaign flowcharts. User tables must be mapped in Unica Campaign to make them available in flowcharts.
        Guidelines for mapping user tables
        Follow these guidelines when you create mapped table and field names.
        To map a base record table to an existing database table
        Map a new base record table to make data accessible to processes in flowcharts. You can map a new base record table to an existing database table.
        To map a base record table to an existing fixed-width flat file
        Map a new base record table to make data accessible to processes in flowcharts. You can map a new base record table to an existing fixed-width flat file on the Unica Campaign server within your partition. The file must be located under your partition root.
        To map a base record table to an existing delimited file
        Map a new base record table to make data accessible to processes in flowcharts. You can map a new base record table to an existing delimited file on the Unica Campaign server within your partition. The file must be located under your partition root.
        To map a dimension table
        Map a new dimension table to make data that augments data in a base table, such as demographics based on postal codes, accessible to processes in flowcharts.
        To map a general table to a database table
        You can map a new general table to an existing database table. You map a new general table to export Unica Campaign data for use by other applications.
        To map a general table to a file
        You map a new general table to export Unica Campaign data for use by other applications.
        To configure profiling
        When you map a user table, you can either pre-compute the distinct values and frequency counts for specific fields, or allow users to perform real-time profiling of data in the base record table.
        To remap a user table
        You can remap a user table at any time.
        To unmap a user table
        You can unmap a user table at any time. Unmapping a user table causes any process in the current flowchart referencing that user table to become unconfigured. However, unmapping a table does not delete the original underlying data or affect any other flowchart.
      - Filtering the mapped user tables
        You can filter the mapped user tables that appear in the Table mappings window. The mapped user tables can be filtered by table name.
    - System table administration
      Unica Campaign administrators may perform the following tasks pertaining to system tables.
    - Data dictionary administrative tasks
      A data dictionary defines the format of data in a fixed-width ASCII flat file. You use data dictionaries in Snapshot processes to ensure that any fixed-width output files that you create adhere to a specific structure.
    - Table catalog administrative tasks
      A table catalog is a collection of mapped user tables. Administrators can create and load table catalogs and perform other operations to make table catalogs available to Unica Campaign users.
    - Setting up Unica Campaign to use Database load utilities
      You can improve performance by using a database load utility for all datasources.
    - Archiving campaigns and flowcharts
      The Unica Campaign application does not provide an automated way to archive retired marketing campaigns or flowcharts. However, you can back up the required files, then use the Unica Campaign user interface to delete unneeded campaigns and flowcharts.
  - Customizing campaigns
    Administrators can customize campaigns by using custom campaign attributes, initiatives, and products.
  - Offer template concepts
    Before administrators perform offer template management tasks, there are several important concepts to understand.
  - About audience level administration
    Unica Campaign is delivered with a single audience level called Customer. You can define any additional audience levels that you need. Audience levels let flowchart designers target specific groups, such as Households, in marketing campaigns.
  - Before you begin working with contact history
    Contact history is stored in the Unica Campaign system database in separate tables by audience level. Therefore, you need to set up audience levels before you begin working with contact history.
  - Response history administration
    Before you begin working with response history, you should read the audience level administration topics and set up required audience levels.
  - Monitoring and controlling flowchart runs
    Choose Campaign > Monitoring and use the All monitored runs page to view the status of all active flowcharts and suspend, resume, or stop flowchart runs.
  - Dimension hierarchy concepts
    A dimension hierarchy is a data construct that groups data into bins based on value ranges. Dimension hierarchies are the basis for a variety of reports.
  - Triggers administration
    Unica Campaign allows you to define inbound and outbound triggers that can be used in all flowcharts in a partition.
  - Unica Campaign log files
    Unica Campaign records information in several different log files.
  - JVM Parameters
  - About codes in Unica Campaign
    Each campaign, cell, offer, and treatment in Unica Campaign has an identifying code that is generated by code generators, and conforms to a specified format.
  - Accessing the Advanced settings
    When a flowchart is open for editing, administrators can choose the Advanced settings option on the Admin menu to make administrative changes that affect only the current flowchart.
  - Unica Campaign integration with other products
    Unica Campaign optionally integrates with a number of other products.
  - Unica Campaign listeners
    The listener is a key component of Unica Campaign. It provides an interface between front-end clients and back-end analytical server processes.
  - Unica Campaign utilities
    Administrators use the Unica Campaign utilities to manage listeners, sessions, and flowcharts, and perform other important administrative tasks.
  - Configuring the ACOOptAdmin tool
    Configure the ACOOptAdmin tool to run Unica Optimize sessions from the command line.
  - Non-ASCII data in Unica Campaign
    Unica Campaign supports the use of localized data and non-United States locales, including multiple user-preferred locales within the same installation of the application.
  - Configuration properties for Unica Campaign
    The configuration properties of Unica Campaign are located at SettingsConfiguration. For more details on the configuration properties, see the Campaign Administrator Guide.
  - About special characters
    Some special characters are not supported in any Unica Campaign object names. In addition, some objects have specific naming restrictions.
  - Introduction to character encodings
    This section provides information on character encodings and language-sensitive database considerations, and lists the encodings supported by Unica Campaign.
  - About Unica Campaign Error Codes
    Unica Campaign notifies users of error events when they occur with error messages that consist of a code number and error text.
  - Troubleshooting
- System Tables

Naming guidelines for mapping user tables

Follow these guidelines when you create mapped table and field names.

Do not include spaces in the name.
Begin the name with an alphabetic character.
Do not use any unsupported characters. For more information about unsupported characters and naming restrictions for Unica Campaign objects, see Special characters in Unica Campaign object names.
Do not to use function names or keywords from the Macro Language for column headings on tables mapped from a database or a flat file. These reserved words can cause errors if used in column headings on mapped tables. For details about these reserved words, see the Macros for Unica User's Guide.
Field names are not case-sensitive. If a field has been mapped, you can change the case in the field name without affecting the mapping.
Do not use the following reserved keywords to map user tables: AGF, DF, ICGF, UCGF PDF, ZN, UserVar. If the reserved keywords are already used to map tables, remap the tables by using different names.

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.