updating db table of other database

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

jrady

Hi, first of all i apologize if this has been asked before
(i did think so, but could not find any matching topics)

I would like Alfresco to update a 3rd party database based on folder actions (add a node, update a node, delete a node etc).
what do i have to do for this?

i assume i need to write some code to encapsulate my sql statement
and then attach this code to a folder watch attribute?

or am i waay off with this approach ?



thanks,
Joe

afaust

Hello,

basically, that is how you would do it. I'd use a policy or action (or both in cooperation) to react to changes in my content model and then trigger the update. For the SQL layer, you could use the MyBatis framework already included in Alfresco and create your own DAOs to talk to your 3rd party database.

Please keep in mind that while access to a 3rd party database is quite simple, transaction handling across both databases (Alfresco and 3rd party) is totally different story and fully up to you, e.g. you would have to put in place the necessary mechanisms to handle rollbacks and commits correctly yourself, if you want to have transactional consistency / atomicity across both systems.

Regards
Axel