Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

FDA - Export data from campaign to External DB

Avatar

Avatar
Validate 1
Level 1
gokulak21678186
Level 1

Likes

2 likes

Total Posts

5 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 1
View profile

Avatar
Validate 1
Level 1
gokulak21678186
Level 1

Likes

2 likes

Total Posts

5 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 1
View profile
gokulak21678186
Level 1

19-02-2018

Hi All,

Is it possible to export data from campaign to external database? If yes kindly let me know the procedure to implement in a local instance. I have installed postgre SQL DB and also created FDA.

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Validate 10
MVP
Amit_Kumar
MVP

Likes

329 likes

Total Posts

649 posts

Correct Reply

231 solutions
Top badges earned
Validate 10
Validate 1
Establish
Give Back 50
Give Back 5
View profile

Avatar
Validate 10
MVP
Amit_Kumar
MVP

Likes

329 likes

Total Posts

649 posts

Correct Reply

231 solutions
Top badges earned
Validate 10
Validate 1
Establish
Give Back 50
Give Back 5
View profile
Amit_Kumar
MVP

14-03-2018

Hi Gokul,

As Florent mentioned that there is no OOTB way to export the data back to FDA, but there are few options that you can implement.

Option 1: Create an extract csv file for data segment you want to export and use FTP to transfer that file to the external server and use that file to import that data into your external system.

Option 2: Look for some APIs exposed by your Data provider for bulk updates, i.e., SOAP or REST-based APIs and write a custom connector to post that data to that third party system from a technical workflow.

Option 3: Use OOTB SOAP web services exposed by Adobe campaign and consume that data in a third party system(Don't forget to check your license for API calls with Adobe)

Regards,

Amit

Answers (4)

Answers (4)

Avatar

Avatar
Validate 1
Level 2
dikshac45201755
Level 2

Likes

2 likes

Total Posts

8 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 1
View profile

Avatar
Validate 1
Level 2
dikshac45201755
Level 2

Likes

2 likes

Total Posts

8 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 1
View profile
dikshac45201755
Level 2

09-04-2018

Hi,

I am trying to use the data present in PostgreSQL database (which is installed on my local machine) and adobe console is also present in my local machine so i am trying to use the data from DB but i am not able to create external account. is it possible??

Thanks,

Diksha

Avatar

Avatar
Validate 1
Level 1
gokulak21678186
Level 1

Likes

2 likes

Total Posts

5 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 1
View profile

Avatar
Validate 1
Level 1
gokulak21678186
Level 1

Likes

2 likes

Total Posts

5 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 1
View profile
gokulak21678186
Level 1

14-03-2018

Thanks for your solution Amit !

Avatar

Avatar
Validate 1
Level 1
gokulak21678186
Level 1

Likes

2 likes

Total Posts

5 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 1
View profile

Avatar
Validate 1
Level 1
gokulak21678186
Level 1

Likes

2 likes

Total Posts

5 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 1
View profile
gokulak21678186
Level 1

13-03-2018

Hi,

Thanks for your update.

Is there any alternate way to export campaign data and importing that into external database ?

Consider the below scenario,

I am inserting some data in campaign FDA schema, that data need to be reflected in an external database also. i.e basically a reverse process insert data into external DB from campaign

Regards,

Gokul

Avatar

Avatar
Give Back 50
Level 10
florentlb
Level 10

Likes

236 likes

Total Posts

1,109 posts

Correct Reply

239 solutions
Top badges earned
Give Back 50
Give Back 5
Give Back 3
Give Back 25
Give Back 200
View profile

Avatar
Give Back 50
Level 10
florentlb
Level 10

Likes

236 likes

Total Posts

1,109 posts

Correct Reply

239 solutions
Top badges earned
Give Back 50
Give Back 5
Give Back 3
Give Back 25
Give Back 200
View profile
florentlb
Level 10

13-03-2018

Hi,

By default FDA is designed to read or get some data from an external data base, not really the other way around (at least it is not recommended).

What you can try is creating a workflow and use a data update to write on your fda schema.

Florent