Expand my Community achievements bar.

SOLVED

Using an external data source in Adobe Campaign v6

Avatar

Former Community Member

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!

1 Accepted Solution

Avatar

Correct answer by
Former Community Member

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.

View solution in original post

4 Replies

Avatar

Level 10

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#Crea...  which is part of the FDA process.

Florent

Avatar

Correct answer by
Former Community Member

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.

Avatar

Former Community Member

Your link did not work before but I think you may have answered the question with this info.

I'll take a deeper look as the link is now working.

Avatar

Former Community Member

Yes I think that is the answer. We were confused as to what FDA contained and thought that 'mapping' was a different function to FDA. Thanks. Good job.

The following has evaluated to null or missing: ==> liqladmin("SELECT id, value FROM metrics WHERE id = 'net_accepted_solutions' and user.id = '${acceptedAnswer.author.id}'").data.items [in template "analytics-container" at line 83, column 41] ---- Tip: It's the step after the last dot that caused this error, not those before it. ---- Tip: If the failing expression is known to be legally refer to something that's sometimes null or missing, either specify a default value like myOptionalVar!myDefault, or use <#if myOptionalVar??>when-present<#else>when-missing. (These only cover the last step of the expression; to cover the whole expression, use parenthesis: (myOptionalVar.foo)!myDefault, (myOptionalVar.foo)?? ---- ---- FTL stack trace ("~" means nesting-related): - Failed at: #assign answerAuthorNetSolutions = li... [in template "analytics-container" at line 83, column 5] ----