View what's in this topicWorking with Data Sources
A data source contains the campaign data, common to all documents. The data source schema must match the data schema defined by the campaign's plan file. Each campaign may have multiple data sources.
The following types of data sources are supported:
File-based data sources
-
MS Access (*.mdb and *accdb)
-
MS Excel (*.xls, *.xlsx, *.xlsb, *.xlsm)
Note that table names must not have leading or trailing spaces. Column (field) names must be unique, cannot be empty, and must not contain leading or trailing spaces.
-
Text Files (*.txt, *.csv, transactional csv).
Note that column (field) names must be unique, cannot be empty, and must not contain leading or trailing spaces.
-
XML (*.xml): MS Recordset only.
Server-based data sources
-
mySQL: versions 4.0 and 5.0
-
Oracle
-
MS SQL server: versions 2005-2012
-
IBM Informix
-
IBM DB2
-
SyBase
-
Generic String: if your data source type or version are unsupported by XMPie, you can define your own connection string.
XMPie proprietary data sources
-
Counter: a proprietary XMPie data source. This single-column database is used to store sequential numbers with predefined intervals.
Permanent and non-permanent data sources
You have the ability to determine whether a data source is permanent or non-permanent. This is essential if your system is GDPR compliant. To fulfill GDPR regulations, data sources that are set as non-permanent will be deleted by an automatic deletion mechanism.
You may set specific data sources, such as those that do not contain PII (Personally identifiable information), as permanent. This means that they will never expire.
For more details, see General Data Protection Regulation (GDPR).
More topics
Adding Recipient Tables and Mapping them to a Plan’s Recipient List Schema
Adding Recipients to the Local Data Source