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?

Question

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 Answer

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

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded