An Adobe Campaign Classic Developer needs to set up a workflow that imports customer data from an S3 bucket on a daily basis. The records must be stored in an existing Campaign table. Which sequence of workflow activities should the Developer use?

This sequence represents a standard and robust pattern for a daily data import and update process in Adobe Campaign Classic.
1. Scheduler: Initiates the workflow on a recurring daily basis.
2. File transfer: Securely downloads the data file from the external Amazon S3 bucket to the Adobe Campaign server. This activity is designed for various protocols, including S3.
3. Data loading (file): Reads the downloaded file, parses its contents, and loads the data into a temporary worktable within the workflow.
4. Update data: Uses the records from the worktable (passed through the transition) to perform a mass insert or update operation on the final, existing Campaign table, reconciling records based on a specified key.

A. File collector is less appropriate than File transfer for accessing an S3 bucket; it's primarily for monitoring a local or SFTP directory.
C. Data extraction is incorrect. This activity exports data from the Campaign database to a file, which is the opposite of the required import operation.
D. This option contains two incorrect activities. File collector is not the best choice for S3, and Data extraction performs an export, not an import.

1. Adobe Experience League | Campaign Classic v7 Documentation

Workflow Activities

File transfer: This document specifies that the File transfer activity "lets you receive or send files... It can be used with various protocols

including Amazon S3

" confirming it as the correct choice for retrieving the file.

2. Adobe Experience League | Campaign Classic v7 Documentation

Workflow Activities

Data loading (file): This source describes the activity's function: "The Data loading (file) activity lets you directly access a data source in order to import it into the database." This validates its use for processing the downloaded file.

3. Adobe Experience League | Campaign Classic v7 Documentation

Use cases

Updating data with data from a file: This official use case guide outlines a workflow to "update the data in the database with the content of a file." The described process involves loading the file's content and then using an Update data activity to "link the data from the file to the data in the database and to update the chosen fields

" directly supporting the Data loading -> Update data sequence.

4. Adobe Experience League | Campaign Classic v7 Documentation

Workflow Activities

Data extraction (file): The documentation states

"The Data extraction (file) activity... lets you extract data and store it in a file." This confirms it is for exporting and thus incorrect for this import scenario.