Using flat files as data sources

Typically, most of the marketing data that you will access from a flowchart will reside in a database, but it may be convenient to access data directly from a flat file. Unica Campaign supports the ability to work with data stored in delimited ASCII flat files or fixed-width ASCII flat files with a data dictionary.

You can map flat files as base tables and access them from within a flowchart. You cannot map flat files as dimension tables.

Direct access to flat files removes the need to first upload data into a database to use with Unica Campaign. This is useful for data exported from third-party applications (such as Excel or SAS) and for transient, one-time use data (such as a campaign-specific seed list, last-minute suppressions, predictive model scores, and other uses).

For additional information, read about data dictionaries.