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

SOLVED

Could ACC write data into a external RDBMS directly?

yueminspb
Level 3
Level 3

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?

1 Accepted Solution
Milan_Vucetic
Correct answer by
Community Advisor
Community Advisor

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

View solution in original post

5 Replies
yueminspb
Level 3
Level 3
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
Darren_Bowers
Community Advisor
Community Advisor
Looking at the permissions required for FDA it looks like it is possible but I havent done it myself. Maybe someone else here can advise? https://experienceleague.adobe.com/docs/campaign-classic/using/getting-started/accessing-external-da...
Milan_Vucetic
Correct answer by
Community Advisor
Community Advisor

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

View solution in original post

yueminspb
Level 3
Level 3
Thanks for your answer, we would estimate that whether to adopt this approach