Using an external data source in Adobe Campaign v6

Question

Hello,

Can someone remind me of the name of the feature in Adobe Campaign which allows me to map to an external database? I’m not referring to FDA, I understand that it’s possible to map to a table/column in a external DB (hosted on the same DM instance as the Campaign Data Mart) and to use that mapping when I create segments, personalize content etc.

I can’t remember the name of the feature. If anyone can remind me that would be great.

Thanks a lot!

Anonymous · Accepted Answer

Ok thank you.

I can inform you that it is possible to map any table in the Adobe Campaign V6 database to any table in an external database. I just cannot remember the name of the feature. I wanted to review the official tech doc on this.

We only use the Adobe Campaign database to store tracking and other AD generated technical data. ALL of our recipient data transactions etc etc are stored in an external SQLServer database. This database is populated using and ETL tool. We do not use any of the AC import tools.

You perform the mapping in the XML for the recipient model (and any other table) using the console as usual.

This is not FDA. We also use FDA for other use cases.

The only 'limitation' is that the external database has to be in the same instance as the AC database.

florentlb · Answer

Hi,I'm not aware of any feature allowing to do this besides FDA. What you describe seems a lot like this: https://docs.campaign.adobe.com/doc/AC6.1/en/PTF_Connectors_Accessing_an_external_database.html#Creating_the_data_schema which is part of the FDA process.Florent

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded