Skip to main content
tristanr1339829
Level 2
Feb 21, 2017 9:30 AM UTC
Solved

Import of a data, which ist based on a external table, which is already accessible by FDA, into an custom table of Adobe Campaign by workflow.

Hello,

I have alreday done a FDA connection to a external database. This works fine.

Now I have created  a data schema based on this FDA connection, which contains the data of the recipients.

My job now ist, to create a worflow, which imports the recipients data of the external database to the customized recipients data schema.

If have checked, that I have only the possibility to import data from a file into Adobe Campaing, but not directly from one data schema to the another data schema of Adobe Campaign.

It this correct ?

Thanks in advance.

Tristan Roppel

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
vraghav
vraghavAccepted solution
Adobe Employee
Feb 24, 2017 10:29 AM UTC

Hi Tristan,

You can use the query activity. When defining filtering condition select targeting and filtering dimension to be you FDA schema.

Define a filtering query like primary key > 0 to fetch all records in one go.

Connect this query activity to an Update data activity

Hope this helps.

Regards,

Vipul

1 reply

vraghav
Adobe Employee
vraghavAdobe EmployeeAccepted solution
Adobe Employee
Feb 24, 2017 10:29 AM UTC

Hi Tristan,

You can use the query activity. When defining filtering condition select targeting and filtering dimension to be you FDA schema.

Define a filtering query like primary key > 0 to fetch all records in one go.

Connect this query activity to an Update data activity

Hope this helps.

Regards,

Vipul

Translate