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]

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

[Milan_Vucetic · Accepted solution]

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

[vinayababu]

Hi Milan,

Thank you so much

vinaya