Updating data based on an automatic file download updating-data-automatic-file-download
The load file activity mainly structures the data from a transfer file activity in order to integrate it into the existing data.
The following example shows the result of an automatically downloaded load file activity via a transfer file activity, followed by an update data activity. This workflow aims to enrich the Adobe Campaign database with new profiles or to update existing profiles using the data recovered from the imported file.
To build the workflow, follow these steps:
-
Drag and drop a Transfer file activity into your workflow.
-
Select the activity, then open it using the
-
Configure the activity in a way so that it recovers the file you would like. In the Protocol tab, select SFTP.
-
Select the Use connection parameters defined in an external account option.
-
Enter the name of the external account.
-
Enter the File path on the remote server.
-
Confirm your activity.
-
Drag and drop a Load file activity into your workflow and place it after the Transfer file activity.
-
Select the activity, then open it using the
-
In the File to load section of the Execution tab, check the Use the file specified in the inbound transition option.
-
Configure your activity as specified earlier.
-
Drag and drop an Update data activity into your workflow and place it after the Load file activity, then configure it.
Once the workflow has started, the data from the uploaded file is extracted and then used to enrich the Adobe Campaign database.