- REDSHIFT DATA TYPES TO STORE DECIMAL ARCHIVE
Therefore, you need to set up audience levels before you begin working with contact history.īefore you begin working with response history, you should read the audience level administration topics and set up required audience levels. Before you begin working with contact historyĬontact history is stored in the Unica Campaign system database in separate tables by audience level.Audience levels let flowchart designers target specific groups, such as Households, in marketing campaigns. You can define any additional audience levels that you need. Unica Campaign is delivered with a single audience level called Customer.
However, you can back up the required files, then use the Unica Campaign user interface to delete unneeded campaigns and flowcharts.Īdministrators can customize campaigns by using custom campaign attributes, initiatives, and products.īefore administrators perform offer template management tasks, there are several important concepts to understand.
REDSHIFT DATA TYPES TO STORE DECIMAL ARCHIVE
The Unica Campaign application does not provide an automated way to archive retired marketing campaigns or flowcharts. You can improve performance by using a database load utility for all datasources. Setting up Unica Campaign to use Database load utilities.Administrators can create and load table catalogs and perform other operations to make table catalogs available to Unica Campaign users. 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 is a collection of mapped user tables. Unica Campaign administrators may perform the following tasks pertaining to system tables.Ī data dictionary defines the format of data in a fixed-width ASCII flat file. The mapped user tables can be filtered by table name. You can filter the mapped user tables that appear in the Table mappings window. User tables must be mapped in Unica Campaign to make them available in flowcharts. User tables contain customer data for use in marketing campaign flowcharts. Unica Campaign supports the ability to use Cloudera Impala™ based implementations of Hadoop® as a user data source. Using Cloudera Impala-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 Hive-based Hadoop big data sources with Unica Campaign.Navigate to /opt/simba/googlebigqueryodbc/Setup and Configure odbc.ini Using MariaDB datasources with Unica Campaign.Redshift is not supported for system tables. Unica Campaign supports Amazon Redshift as a user data source. Using Amazon Redshift user data sources with Unica Campaign.Data types that are not listed here are not supported. To access user data from within a flowchart, ensure that you are logged in to each database that is acting as a data source.īefore you map user tables in Unica Campaign, ensure that your tables use only the supported data types for each supported database. Accessing data sources from within a flowchart.You can create new user tables by exporting data from an output process, such as Snapshot, Call List, or Mail List.
Creating new user tables through an output process.
Other organizations might have a distributed big data system, along with some flat files. For example, an organization might store customer names and addresses in DB2® and customer purchase history in SQL Server. Organizations can use their own databases and flat files as data sources in Unica Campaign flowcharts. Adding new user data sources to Unica Campaign.Unica Campaign administrators typically perform the following tasks pertaining to user tables. The following concepts pertain to system tables, user tables, flat files, and table mapping.Īdministrators must perform several initial table-related tasks after Unica Campaign is installed. Unica Campaign administrators must perform initial one-time tasks and routine administration tasks that pertain to database tables.
Security policies control user access to the objects and features in Unica Campaign. The Settings menu provides access to most of the tasks that Unica Campaign administrators typically perform.
