Unica Optimize system table mapping reference

To integrate Unica Optimize with Unica Campaign, map all the Unica Optimize system tables to the Unica Campaign tables.

You can exchange data between Unica Optimize and Unica Campaign by mapping the Unica Optimize tables in Unica Campaign. Map all the Unica Optimize system tables, contact history tables, and segment membership tables to the Unica Campaign tables.

Use the following table to get information about the Unica Optimize system tables and the corresponding database tables:

Table 1. Unica Optimize system table mapping

A two-columned table lists the name of the Unica Optimize system tables in one column, and the database table name in the second column.

Unica Optimize System Table Database Table

Optimize Session Table

UACO_OptSession

Optimize Process Table

UACO_OptimizeProcess

Optimize Run History Table

UACO_SesnRunHist

Optimize Session Segment Table

UACO_SesnSegment

Optimize Offer Segment Table

UACO_OfferSeg

Optimize Session Offer Table

UACO_SesnOffer

Optimize Rule Table

UACO_Rule

Optimize Exception Rule Table

UACO_RException

Optimize Exception Rules Constraint Table

UACO_RExConstraint

Optimize Rules Constraint Table

UACO_RConstraint

Optimize Rule OfferList Table

UACO_ROfferList

Optimize Rule Offer Table

UACO_ROffer

Optimize Rule Segment Table

UACO_RSegment

Optimize Proposed Contact Base Table

UACO_PCTBase

Optimize Proposed Attribute Base Table

UACO_POABase

Optimize Optimized Contact Base Table

UACO_OCTBase