Storing Variables to a different 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.

Guru

Hi

I am new to Alfresco and i need to know how to store the variables (as in ACT_HI_VARINST) to a different database in real time scenario. 

Kindly help me in this 

Regards,

Guru

openpj

I think that you can implement this behavior in different ways in APS:

• Adding a custom REST Task for callling an external service via REST: https://docs.alfresco.com/process-services/latest/using/process/bpmn/#rest-call-task. Your external service will be called with a POST call and a JSON body in the request where your service will get values to store on a different data source (MongoDB, other DBMS, file system and so on)
• Using Custom Data Models: https://docs.alfresco.com/process-services/1.9/develop/dev-ext/#custom-data-models
• Implementing your own Service Task as a Java Delegate with your own DAO classes, and here I suggest to use the Spring Framework using Spring Data or Spring JdbcTemplate: https://docs.alfresco.com/process-services/latest/develop/dev-ext/#custom-logic
• Implementing a Task Execution Listener attached to the end event for example with a similar implementation of the Service Task
• Remember that, if you are using a recent version, you can disable the persistence of some variables in the Activiti database: https://docs.alfresco.com/process-services/latest/using/process/persistence/

Hope this helps