Home
Administrator Guides
Administrator Guide
Unica Campaign utilities
Administrators use the Unica Campaign utilities to manage listeners, sessions, and flowcharts, and perform other important administrative tasks.
Database testing utilities
Unica Campaign provides several command-line database testing utilities that you can use to test connections to a target database, execute queries, and perform a variety of tasks.
To use the odbctest utility
The odbctest utility allows you to test Open DataBase Connectivity (ODBC) connections to a target database and, once connected, to issue a variety of commands.

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.
  - 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.
    - Unica Campaign advanced search utility (advSrchUtil)
      Unica Campaign v10 introduces the ability to search flowcharts. However, flowcharts are not searchable until you index them. Use advSrchUtil to index all flowcharts in the specified partition.
    - Unica Campaign advanced search agent (advSrchAgent)
      Use advSrchAgent to automatically index flowcharts and make them available for the search function whenever flowcharts are modified.
    - Unica Campaign Listener Shutdown utility (svrstop)
      Use the Unica Campaign listener shutdown utility (svrstop) to shut down the Unica Campaign listener or the Unica Optimize listener.
    - Unica Campaign Server Manager (unica_svradm)
      The Unica Campaign Server Manager (unica_svradm) is a command-line server management utility.
    - Unica Campaign session utility (unica_acsesutil)
      Use the Unica Campaign session utility (unica_acsesutil) to perform the following tasks.
    - Unica Campaign cleanup utility (unica_acclean)
      Use the cleanup utility (unica_acclean) to identify and clean up temporary files and database tables in the current partition. The cleanup utility can be used on the Unica Campaign system tables database and user table databases.
    - Unica Campaign report generation utility (unica_acgenrpt)
      The unica_acgenrpt command-line report generation utility exports a flowchart cell report from a specified flowchart. The report is generated from the flowchart's .ses file.
    - Database testing utilities
      Unica Campaign provides several command-line database testing utilities that you can use to test connections to a target database, execute queries, and perform a variety of tasks.
      - To use the cxntest utility
        Use cxntest to test connections to a target database and to issue commands when connected.
      - To use the odbctest utility
        The odbctest utility allows you to test Open DataBase Connectivity (ODBC) connections to a target database and, once connected, to issue a variety of commands.
      - To use the db2test utility
        The db2test utility allows you to test connections to a DB2® database and, once connected, to issue a variety of commands.
      - Using the odbctest Utility to test connection with MariaDB
      - To use the oratest utility
        The oratest utility allows you to test connections to an Oracle server.
  - 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

Using the odbctest utility

The odbctest utility allows you to test Open DataBase Connectivity (ODBC) connections to a target database and, once connected, to issue a variety of commands.

About this task

This utility is supported on AIX®, Solaris, Windows™, and HP-UX systems (32-bit only). For Oracle and DB2® databases, use their native utilities.

Procedure

From a command prompt on the Unica Campaign server, run the odbctest utility.

The utility returns a list of databases that you can connect to, similar to the following:

Registered Data Sources:
		MS Access Database (Microsoft Access Driver (*.mdb))
		dBASE Files (Microsoft dBase Driver (*.dbf))
		Excel Files (Microsoft Excel Driver (*.xls))

Enter the following information exactly at the prompts:
1. The name of the database that you want to connect to (taken from the list of Registered Data Sources)
2. A database user ID
3. The password associated with the database user ID
The utility does not prompt for confirmation of your selections.

When you have successfully connected to the database, the utility prints out messages like the following and presents you with a command prompt:

Server ImpactDemo conforms to LEVEL 1.
Server's cursor commit behavior: CLOSE
Transactions supported: ALL
Maximum number of concurrent statements: 0
For a list of tables, use PRINT.

You can enter the following commands at the prompt:
- bulk [number_of_records]
  Sets the number of records to return, as specified by number_of_records. The default is 1.
- descresSQL_command
  Describes the columns returned by the SQL command specified by SQL_command.
- describepattern
  Describes the table or tables specified by pattern. Returns the corresponding type, data type, storage length, precision, and scale.
- exit
  Terminates the database connection and exits.
- help
  Displays a list of supported commands.
- print[pattern]
  Returns a list of tables. Can optionally specify a search pattern.
- quit
  Terminates the database connection and exits.
- SQL_command
  Executes any valid SQL command or series of SQL commands.
- typeinfo
  Returns a list of supported data types for the database.

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.