How do I create a restricted database for Transact?

Transact (both XML and SMTP) uses a restricted database. This database is used specifically for Transact sends. Org admin and standard users with permission can create a restricted database.

This database is the contact source for your Transact sends. The database is not a permanent collection of data. Contact details remain active for 60 days, but are available in aggregate reports beyond that time frame.

Note: The database that you create must be in a Shared folder (you can create it in a Private folder and move it to a Shared folder).

To create a Transact database, use the following procedure.

  1. To open the Create Database/List page, go to Data > Database > Create .
  2. Select the database type.
  3. Click Select and choose a Public folder as your save location.
  4. Click Nextto display the Create Database/List Add Fields page.
  5. Create the SPOP UI field:
    1. In Field Name, type SPOP.
    2. In Field Type, select Text.
    3. Click Add Field.
  6. Click Edit Unique Identifiers.
  7. Clear the Email field and check the SPOP field. Click Save when done. (It is possible to use a different field so long as it would only contain a data element that would never be used again such as a transaction_id.)
  8. Click Create.

Your Transact enabled database is created.