Skip to main content
himanshu-singh
Level 2
Oct 20, 2022 3:00 PM UTC
Solved

Connecting Adobe Campaign hosted With External Database

Hi All,

 

We have a hosted adobe campaign instance and we will like to export data from our data ware house hosted remotely to our Adobe Campaign instance.

I have been looking into the FDA provided by AC to achieve this , kindly suggest if it's possible and if yes then how can we do it?

Detail explanation will be helpful.  

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Shubham_Goyal__
Shubham_Goyal__Accepted solution
Level 6
Oct 21, 2022 6:33 AM UTC

Hi @himanshu-singh ,

 

As you mentioned it's 'Adobe hosted' (managed services) then only the following are the FDA types of connectors supported by Adobe Campaign: link

Now, if your DWH is connected to one of these databases then you can configure these connectors in external accounts. link 

If Not, then you can easily pass the data from DWH to Adobe's SFTP and can create an SFTP external account in Adobe campaign, and then import this data from this sFTP. link

 

Br,

Shubham

 

 

~Thanks - Shubham Goyal (Enterprise Architect)
View in thread

6 replies

Adobe Employee
costa_n11Adobe Employee
Adobe Employee
Oct 20, 2022 3:22 PM UTC

Hi @himanshu-singh 

When you say hosted? you mean installed on your premise as opposed hosted by Adobe?

It makes all the difference

thanks

Denis

Translate
himanshu-singhAuthor
Level 2
Oct 20, 2022 5:16 PM UTC

Hi @costa_n11 ,

 

It's Adobe hosted .

Translate
Shubham_Goyal__
Shubham_Goyal__Accepted solution
Level 6
Oct 21, 2022 6:33 AM UTC

Hi @himanshu-singh ,

 

As you mentioned it's 'Adobe hosted' (managed services) then only the following are the FDA types of connectors supported by Adobe Campaign: link

Now, if your DWH is connected to one of these databases then you can configure these connectors in external accounts. link 

If Not, then you can easily pass the data from DWH to Adobe's SFTP and can create an SFTP external account in Adobe campaign, and then import this data from this sFTP. link

 

Br,

Shubham

 

 

Translate
~Thanks - Shubham Goyal (Enterprise Architect)
    himanshu-singhAuthor
    Level 2
    Oct 21, 2022 9:50 AM UTC

    Hi @shubham_goyal__ ,

     

    So when you say configure SFTP you mean to get the data via excel file from sftp and consume in our ETL workflows or we can have a same View access like FDA provides us ?

    Translate
    Shubham_Goyal__
    Shubham_Goyal__
    Level 6
    Oct 21, 2022 11:38 AM UTC

    Hi @himanshu-singh,

     

    You are right, the files should be transferred and ingested into the campaign in CSV format.

    Br,

    Shubham

    Translate
    ~Thanks - Shubham Goyal (Enterprise Architect)
    Terms & ConditionsAccessibility statement

    Loading footer...