Change data source change-data-source

The Change data source activity is a targeting activity. This activity allows you to change the data source used by your workflow’s Working table. This provides more flexibility by allowing you to manage data across your different databases and improve performances.

In workflows, data transported from one activity to another through transitions is stored in a temporary Working table. By default, Working tables are created in the same database as the source of the processed data. For example, when querying the “Profiles” table, stored on the Cloud database, a Working table is created on the same Cloud database.

In some cases, either data is not available on the current database or is not efficient enough to perform unitary operations. You may therefore need to force the workflow to use a different database to perform such operations by adding a Change data source activity.

Detailed information on Campaign architecture is available in Campaign v8 (client console) documentation

IMPORTANT
Please note that the Change Dimension and Change Data source activities should not be added in one row. If you need to use both activities consecutively, make sure you include an Enrichement activity in between them. This ensures proper execution and prevents potential conflicts or errors.

Configure the Change data source activity configure

Follow these steps to configure the Change dimension activity:

  1. Add a Change data source activity to your workflow.

  2. Define the data source where you want to move the Working table:

    • Default Campaign database (PostgreSQL): Use the default Campaign local database.

    • FDA external account: Use external Cloud databases connected to Adobe Campaign through Federated Data Access capability.

      note availability
      AVAILABILITY
      Campaign configuration and connection to external systems are restricted to advanced users and only available from the client console. Learn more
  3. Configure your workflow to perform the desired operations using the new data source.

recommendation-more-help
c39c2d00-ba9a-424b-adf9-66af58a0c34b