The Change data source activity is only available with the Access to external data (Federated Data Access) package. For more information on Adobe Campaign Classic built-in packages, refer to this page.
The Change data source activity allows you to change the data source of a workflow Working table. This provides more flexibility to manage data across different data sources such as FDA, FFDA and local database.
The Working table allows Adobe Campaign Classic workflow to handle data and share data with the workflow activities.
By default, the Working table is created in the same database as the source of the data we query on.
For example, when querying the Profiles table, stored on the Cloud database, you will create a Working table on the same Cloud database.
To change this, you can add the Change Data Source activity to choose a different data source for your Working table.
Note that when using the Change Data Source activity, you will need to switch back to the Cloud database to continue the workflow execution.
To use the Change Data Source activity:
Create a workflow.
Query your targeted recipients with a Query activity.
For more information on the Query activity, refer to this page.
From the Targeting tab, add a Change data source activity.
Double-click your Change data source activity to select Default data source.
The working table, which contains the result of your query, is then moved to the default PostgreSQL database.
Add another Change data source activity to switch back to the Cloud database.
Double-click your activity and select Active FDA external account then the corresponding External database external account.
You can now start your workflow.