Skip to main content
Solved

Write back into a database (MySQL)

  • January 21, 2022
  • 2 replies
  • 11 views

Hi,

 

we are working with a MySQL database as a source of our process data. After analyzing the process we have added projects to the action engine. Now we like to write back data into the MySQL database by executing UPDATE/CREATE (e.g. to set blocks or discounts for upcoming processes for a customer which are stored in a specific database table). How can we do this? We just found SAP HANA as a database to post SQL statements but not MySQL.

 

Best,

Clemens

Best answer by janpeter.van.d

Hi Clemens,

 

Did you checked the action flows? In here there is a MySQL connector that can update rows.

 

Please have a look in the documentation how to integrate them in skills:

https://help.celonis.cloud/help/x/2wMGAw

 

Kind regards,

Jan-peter

2 replies

janpeter.van.d
Level 12
Forum|alt.badge.img+26
  • Level 12
  • 496 replies
  • Answer
  • January 21, 2022

Hi Clemens,

 

Did you checked the action flows? In here there is a MySQL connector that can update rows.

 

Please have a look in the documentation how to integrate them in skills:

https://help.celonis.cloud/help/x/2wMGAw

 

Kind regards,

Jan-peter


  • Author
  • Level 2
  • 1 reply
  • January 21, 2022

Hi Jan-Peter,

 

tanks for your response. Now, I found it. Thanks for the link to the documentation!

 

Best regards,

Clemens