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
Configure the Change data source activity configure
Follow these steps to configure the Change dimension activity:
-
Add a Change data source activity to your workflow.
-
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 ۶Ƶ 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
-
-
Configure your workflow to perform the desired operations using the new data source.