Database load utilities

Campaign offers support for using database load utilities to increase performance for pushing ID lists into temporary tables, and for exporting data back into the database. This functionality works with most common database load utilities, which are available directly from the database vendors. It is your responsibility to obtain licensed copies of these utilities.

The Campaign load support is controlled though a series of properties defined on the Marketing Platform Configuration page. For more information, see the Marketing Platform Administrator’s Guide.

When you use most database load utilities, you must also specify a control file. Campaign can generate this file dynamically based on a control file template that you configure. You only need to configure these files once; no changes are required from the user interface.

When Campaign needs to populate data to the database (for example, for a Snapshot process or a contact process such as MailList, or an ID list into temporary tables), it does the following:

1.	Creates a temporary data file as fixed width or delimited text.

If specified by the LoaderControlFileTemplate property, a temporary control file is dynamically created based on the template file and the list of fields that need to be sent to the database.

2.	Issues the command specified by the LoaderCommand property. This can be either a direct call to the database load utility executable or a call to a script that launches the database load utility.

3.	Cleans up the temporary data file and control file.

This functionality allows you to load data into a new or empty database table and append data to an existing database table.

Campaign does not support using load utilities to update records in an existing database table.

Fast loader repeated tokens