Hi everyone
We are planning to perform a full refresh of the Adobe Campaign database using an external file that will be loaded through a workflow. Several attributes of the Recipient schema will be updated, along with their subscriptions. Missing accounts will be created too. The ideas is to request a full back-up to be taken before we start and stop all the pipelines that feeds data in and out of Adobe Campaign.
From the testing performed in staging for this bulk update, and some benchmarks of other similar updates we have done in the past, we know that the bulk upload workflow will take more than 10 hours to complete, probably around the 15 hour mark, which would effectively mean almost two days of interrupted operations for the various marketing teams.
Since all the pipelines will be stopped anyway, I was wondering if it is possible to proceed with the bulk update while the marketing teams send the campaigns. Will the delivery workflows lock the database and in turn lock the bulk update workflow and vice versa? There are around 4 campaigns that are executed daily.
Also, I am aware that in case of failure we would need to rollback which would mean that we would lose all the delivery/tracking info of all campaigns that were executed during the bulk update process. That's a risk that the business is willing to take and the way to mitigate is by exporting all the data before rolling back and then report externally.
Cheers
Hugo
