Export Historical data out of Adobe Campaign Standard

[shansjtrex]

Hello,

Is it possible to export the historical data of Campaigns, profile, etc out of Campaign? The business need is to replicate the behavior data, workflow on the operations internal database.

Thank you

shan

[pulkit2304]

shansjtrex You cannot replicate the entire ACS database. However, you can periodically export snapshots of tables and maintain a history of changes in an external database.

Thanks,

Pulkit

[shansjtrex]

thank you pulkit2304​ . The snapshots are done through Adobe Campaign API ?

[pulkit2304 · Accepted solution]

shansjtrex​ It can be done with API's but my recommendation, given the likely huge volume of records, will be flat-file/batch exports. ACS workflows allow you to extract the queried data into many widely used flat file formats.

Thanks,

Pulkit

[shansjtrex]

pulkit2304​ that makes sense. That was initial plan was looking to see if that is sufficient. Looks like it. Thank you for the information.