Hello guys,
I am importing Recipient information by using FDA connector. My question is: is it better to link directly the Recipient table to the FDA Table Recipient (View) and change the Targeting Mapping or import the delta information via workflow and insert/update Recipient Table?
Thanks,
Luca
Solved! Go to Solution.
Adobe recommends the latter approach in general.
I would personally opt for acc to ingest recipient data and other kind of data can be kept at source and used on ad-hoc/scheduled basis.
Views
Replies
Total Likes
Adobe recommends the latter approach in general.
I would personally opt for acc to ingest recipient data and other kind of data can be kept at source and used on ad-hoc/scheduled basis.
Views
Replies
Total Likes
Hello @Luca_Lattarini ,
Best practice is to just "import" required data.
There are 3 main reasons:
1- performance is better on your local database: your WKF will
2- when you create a schema (so queryable) through FDA, there is a lot of intrusive objects that are created on the external database
a- AC will have to create the OOTB AC Stored Procedures (in order to have the query expressions to work)
b- AC will also create work tables (WKFxxxxxx) on the external DB when running a workflow that involve an activity on the schema
c- AC will connect to the external DB with the clean up and try to delete work tables + some lists... When 2 AC instances are linked in FDA, it can be a high risk if FDA accounts are not correctly set (tables from AC on server B that deletes required tables on server A)
3- having tables on different DB is less resilient: you do not just have a risk on your DB + network but also on each external DB involved + network route to your DB. If everything is on your AC DB, your workflow will run, even with outdated data
Views
Likes
Replies
Views
Likes
Replies