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
Validate 1
Level 1
vinayababu
Level 1

Like

1 like

Total Posts

10 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Boost 1
View profile

Avatar
Validate 1
Level 1
vinayababu
Level 1

Like

1 like

Total Posts

10 posts

Correct reply

0 solutions
Top badges earned
Validate 1
Boost 1
View profile
vinayababu
Level 1

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
Contributor
MVP
Milan_Vucetic
MVP

Likes

166 likes

Total Posts

384 posts

Correct reply

135 solutions
Top badges earned
Contributor
Springboard
Shape 1
Validate 25
Validate 10
View profile

Avatar
Contributor
MVP
Milan_Vucetic
MVP

Likes

166 likes

Total Posts

384 posts

Correct reply

135 solutions
Top badges earned
Contributor
Springboard
Shape 1
Validate 25
Validate 10
View profile
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)