Message Center - Event History

Avatar

Avatar
Validate 10
Level 2
Jaspreet_Kaur1
Level 2

Likes

9 likes

Total Posts

26 posts

Correct reply

1 solution
Top badges earned
Validate 10
Validate 1
Boost 5
Boost 3
Boost 1
View profile

Avatar
Validate 10
Level 2
Jaspreet_Kaur1
Level 2

Likes

9 likes

Total Posts

26 posts

Correct reply

1 solution
Top badges earned
Validate 10
Validate 1
Boost 5
Boost 3
Boost 1
View profile
Jaspreet_Kaur1
Level 2

25-10-2017

Hello,

I need to extract the data from event history of the message center which is in the xml format and export it further to one of the sftps(This export is to run every 5-10 mints). Would like to know the best approach in terms of extracting the data from the event history,as this needs to happen in the real time, will it be good to extract from event history- insert into DB-export or extract from event history-export or anything else which will be the best. Any sample available for reference ?

Thanks,

Jas

Replies

Avatar

Avatar
Give Back 50
Level 10
florentlb
Level 10

Likes

237 likes

Total Posts

1,109 posts

Correct reply

239 solutions
Top badges earned
Give Back 50
Give Back 5
Give Back 3
Give Back 25
Give Back 200
View profile

Avatar
Give Back 50
Level 10
florentlb
Level 10

Likes

237 likes

Total Posts

1,109 posts

Correct reply

239 solutions
Top badges earned
Give Back 50
Give Back 5
Give Back 3
Give Back 25
Give Back 200
View profile
florentlb
Level 10

06-11-2017

Hi Jas,

Have you tried running an export workflow? By using a scheduler, a query to retrieve the data you need, and a data extract with a file transfer activities, you can automate the exports (although it is not recommended to run workflows less than every 10 minutes.

I'd recommend performing some test with this method, and see how long the workflow takes to execute (you don't want the workflow to run while its previous execution is not finished).

Let me know,

Florent