Action Custom and Conect External Database SQL Server

[marcog]

Good Morning.

I am extremely new to development and I have a mission critical in JAVA that I need emergency help.

I created a custom action that performs an ERP SQL Server search and needs to return the SQL client name field to write as metadata in Alfresco. A single JAVA class was created that performs all this service.

This custom action was based on the model and example of Jeff Potts

[kalpesh_c2]

Hi Marco , 
Please refer this documentation Adding new actions to the Document Library | Alfresco Documentation or Creating Custom Actions in Alfresco | ECMArchitect | Alfresco Developer Tutorials  to create custom in alfresco share,
In this action you can call java classes and you can create connection to your external database and execute query , get client name and update your metadata using java api.

Thanks,

Kalpesh,
ContCentric