Could ACC write data into a external RDBMS directly? | Community
Skip to main content
Y
yueminspb
Level 3
November 16, 2020
Solved

Could ACC write data into a external RDBMS directly?

  • November 16, 2020
  • 2 replies
  • 1702 views

Hi Team,

Our client need ACC write some statistic data into client's data base. So we just want to know is there any activity node of workflow to achieve this?

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 Milan_Vucetic

Hi @yueminspb 

yes, it is posible but sometimes knwos to be buggy.

You must create table schema in AC with relevant information about external table and define external account of used RDBMS in it. Schema must be defined as a view in order to avoid to create new table in AC database. Finaly, use default Update node for inserting data and data will be reflected to external table.

Regards,

Milan

2 replies

Darren_Bowers
Darren_Bowers
Level 9
November 16, 2020

Hi @yueminspb - check out Federated Data Access (FDA) https://experienceleague.adobe.com/docs/campaign-classic/using/getting-started/accessing-external-database/about-fda.html?lang=en#getting-started

Activities you can use are here: https://experienceleague.adobe.com/docs/campaign-classic/using/automating-with-workflows/advanced-management/accessing-an-external-database--fda-.html?lang=en#automating-with-workflows

Cheers

Darren

Y
yueminspbAuthor
Level 3
November 16, 2020
Hi, dear Darren, I have read this link, but I found these activities can only query, split, enrichment and loading. If we can insert or update some data into external data base
Milan_Vucetic
Milan_VuceticAccepted solution
Level 9
November 16, 2020

Hi @yueminspb 

yes, it is posible but sometimes knwos to be buggy.

You must create table schema in AC with relevant information about external table and define external account of used RDBMS in it. Schema must be defined as a view in order to avoid to create new table in AC database. Finaly, use default Update node for inserting data and data will be reflected to external table.

Regards,

Milan

    Y
    yueminspbAuthor
    Level 3
    November 16, 2020
    Thanks for your answer, we would estimate that whether to adopt this approach
    Terms & ConditionsAccessibility statement

    Loading footer...