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?

Avatar

Avatar

vinayababu

Avatar

vinayababu

vinayababu

04-01-2021

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

 

 

 

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar

Milan_Vucetic

MVP

Avatar

Milan_Vucetic

MVP

Milan_Vucetic
MVP

04-01-2021

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

 

Answers (0)