Avatar

Level 4

Hi,

Option #1 is the recommended approach since it will include large data (promotion history/send history data). We have implemented a similar approach and it works well.

There is option #3, if you have a hybrid ACC implementation, the ACC system tables (mart) will reside in a relational DB on your side. your DBA and/or DB developer can create their own ETL to pull the data incremental from ACC mart to any destination (flat files, another DB, etc.).

Option #2 I don't recommend.

Thanks.