Connecting Adobe Campaign hosted With External Database | Community
Skip to main content
Level 2
October 20, 2022
Solved

Connecting Adobe Campaign hosted With External Database

  • October 20, 2022
  • 2 replies
  • 1958 views

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.
Best answer by Shubham_Goyal__

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

 

 

2 replies

Adobe Employee
October 20, 2022

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

Level 2
October 20, 2022

Hi @costa_n11 ,

 

It's Adobe hosted .

Shubham_Goyal__
Shubham_Goyal__Accepted solution
Level 6
October 21, 2022

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

 

 

Level 2
October 21, 2022

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 ?

Level 2
October 21, 2022

Hi @himanshu-singh,

 

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

Br,

Shubham


Yeah That's what I thought.