- Mark as New
- Follow
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report
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.