Updating the database with external data
The following example shows the configuration of an Update data activity following a Load file activity. The aim of this workflow is to add or update profiles to the Adobe Campaign database with the data recovered from the file.
In this example, the reconciliation key used is the email address . The file loaded in the Load file activity is a .txt format file containing the following example data:
lastname;firstname;email;birthdate jackman;megan;firstname.lastname@example.org;07/08/1975 phillips;edward;email@example.com;09/03/1986 weaver;justin;firstname.lastname@example.org;11/15/1990 martin;babeth;email@example.com;11/25/1964 reese;richard;firstname.lastname@example.org;02/08/1987 cage;nathalie;email@example.com;07/03/1989 xiuxiu;andrea;firstname.lastname@example.org;09/12/1992 grimes;daryl;email@example.com;12/06/1979 tycoon;tyreese;firstname.lastname@example.org;10/08/1971
The Update data activity is configured as follows: