Could ACC write data into a external RDBMS directly?

Question

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?

Milan_Vucetic · Accepted Answer

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

Darren_Bowers · Answer

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

Sign up

Login with SSO

Login to the community

Login with SSO