Adobe campaign classic FDA

[SivaK]

Does the FDA feature in campaign classic complement the data in campaign database? Meaning, is FDA is used to enrich additional data from external sources aling side the core recipient data in the campaign database and NOT to be used as a core campaign database (including recipient data) from external sources? Please clarify.

[Jonathon_wodnicki]

Hi,

Yes, you can also query directly (non-enrich) or write to FDA as desired.

You can't install Campaign on an FDA db, though it will install its sql functions there.

Thanks,

-Jon

[SivaK]

Thanks Jon. So if I've contact data in an external database like an Oracle DB, I still need to import these records into Adobe campaign recipient table(both initial and incremental load)  to use in segmentation and personalization, correct?

[Jonathon_wodnicki]

That's the opposite of what I wrote, but you're still correct on a deeper level. Generally you want to use FDA as an ETL vehicle, periodically sync'ing demographic data and leaving activity data in place. There aren't any technical limitations on using an FDA table as an external recipient table afaik, though it's not a great idea for the usual reasons plus the FDA reasons (availability, complexity, perf).