Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

How we can schedule a remainder email in adobe campaign by using the data available in mysql Database or if data available in Adobe experience platform dataset?

vinayababu
Level 2
Level 2

Hi Team,

We want to schedule a reminder for the customers who booked the appointments. These data is available in MySQL database, we need to utilize the data from MySQL database to schedule the reminder emails.

1) How we can establish connection between MySQL database to Adobe campaign to pass the data.

2) In adobe campaign  where the extracted data should be stored and how can we use the same to schedule the reminder campaign.

Thanks 

Vinaya

 

 

 

1 Accepted Solution
Milan_Vucetic
Correct answer by
Community Advisor
Community Advisor

Hi @vinayababu 

create new external account with MySql type and set connection parameters (Administration/Platform/External Accounts/).

Finaly fetch prefered data in the workflow within Data loading (RDBMS) node. You probably do not need to store fetched data.

If yes, then create new table for it and add Update node after RDBMS node and adjust operation.

Regards,
Milan

 

View solution in original post

2 Replies
Milan_Vucetic
Correct answer by
Community Advisor
Community Advisor

Hi @vinayababu 

create new external account with MySql type and set connection parameters (Administration/Platform/External Accounts/).

Finaly fetch prefered data in the workflow within Data loading (RDBMS) node. You probably do not need to store fetched data.

If yes, then create new table for it and add Update node after RDBMS node and adjust operation.

Regards,
Milan

 

View solution in original post