When to use Change data source activity | Community
Skip to main content
P
pmchinchu
January 27, 2022
Solved

When to use Change data source activity

  • January 27, 2022
  • 2 replies
  • 1113 views

I'm trying to explore this new activity in V8 and while doing testing, I observed that the workflow is running without using Change data source activity. Below is the scenario that I was testing:

Created one schema in local and one in Cloud. Queried both schemas and intersected on email address field, which is the common field for both, keeping the primary set as cloud schema. The workflow ran successfully. 

 

But when I kept the primary set as local schema, it kept failing due to:

01/25/2022 3:07:08 AM union PGS-220000 PostgreSQL error: ERROR: COALESCE types integer and character varying cannot be matched LINE 1: ...yaltyBalance) SELECT DISTINCT Coalesce(Input1.iId,Input2.uId... ^ .

 

When do we actually need to use Change Data source activity? 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Craig_Thonis

Hi Chinchu,

 

The Change Data source activity should only be leveraged when pulling data from an external database connection. That said, your data types still need to match in order for them to be reconciled.

 

Activity documentation:

https://experienceleague.adobe.com/docs/campaign-classic/using/automating-with-workflows/targeting-activities/change-data-source.html?lang=en

 

If you are still having issues utilizing the activity, I would suggest opening a ticket with Campaign Support to review the error.

 

Regards,

Craig

 

2 replies

Craig_Thonis
Adobe Employee
Craig_ThonisAdobe EmployeeAccepted solution
Adobe Employee
February 1, 2022

Hi Chinchu,

 

The Change Data source activity should only be leveraged when pulling data from an external database connection. That said, your data types still need to match in order for them to be reconciled.

 

Activity documentation:

https://experienceleague.adobe.com/docs/campaign-classic/using/automating-with-workflows/targeting-activities/change-data-source.html?lang=en

 

If you are still having issues utilizing the activity, I would suggest opening a ticket with Campaign Support to review the error.

 

Regards,

Craig

 

    C
    Adobe Employee
    ChristopheProtatAdobe Employee
    Adobe Employee
    February 1, 2022

    Hi, 

    Here are a set of videos we just published and that could help you understanding the usage pattern for Change data source activity. 

      Terms & ConditionsAccessibility statement

      Loading footer...