Could ACC write data into a external RDBMS directly?

Avatar

Avatar
Validate 10
Level 1
yueminspb
Level 1

Likes

0 likes

Total Posts

38 posts

Correct reply

0 solutions
Top badges earned
Validate 10
Validate 1
View profile

Avatar
Validate 10
Level 1
yueminspb
Level 1

Likes

0 likes

Total Posts

38 posts

Correct reply

0 solutions
Top badges earned
Validate 10
Validate 1
View profile
yueminspb
Level 1

15-11-2020

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?

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Contributor
MVP
Milan_Vucetic
MVP

Likes

166 likes

Total Posts

384 posts

Correct reply

135 solutions
Top badges earned
Contributor
Springboard
Shape 1
Validate 25
Validate 10
View profile

Avatar
Contributor
MVP
Milan_Vucetic
MVP

Likes

166 likes

Total Posts

384 posts

Correct reply

135 solutions
Top badges earned
Contributor
Springboard
Shape 1
Validate 25
Validate 10
View profile
Milan_Vucetic
MVP

16-11-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

Answers (1)

Answers (1)

Avatar

Avatar
Validate 1
MVP
Darren_Bowers
MVP

Likes

83 likes

Total Posts

284 posts

Correct reply

87 solutions
Top badges earned
Validate 1
Affirm 50
Establish
Give Back 3
Applaud 25
View profile

Avatar
Validate 1
MVP
Darren_Bowers
MVP

Likes

83 likes

Total Posts

284 posts

Correct reply

87 solutions
Top badges earned
Validate 1
Affirm 50
Establish
Give Back 3
Applaud 25
View profile
Darren_Bowers
MVP

15-11-2020