Obtain data list properties from external services

[jeaolucas]

I using Alfresco comunitty to obtain a implemetation of a ECM service.

I use the data model to define mi metadata for files in the Alfresco repository, in this model have a lot of datalist to obtein from a catalogs in external service with a db in external source (no Alfresco db). 

I require to obtain a list of diferent metadata from model but this list come from external service exposed via db to put the información in the repository when sabe the information by id, an then view the information in the share view with the description of the catalog an not for the id in the metadata.

This because the catalogs of this data is upgrade every 6 months an then when I try to show cant show becose the information can stay in Alfresco.

Can any one can do this in Alfresco repository  5.2 ce.

[jpotts]

Yes, you can do a lookup against an external database. You can store those values in metadata on documents.

There are many ways to do this.

You could choose one of these options:

  (1) Write a custom form control that queries the service via REST

  (2) Write a web script that queries the service via REST

  (3) Write a web script that uses Java to connect to a database via JDBC

  (4) Write an action or a behavior that places a message on a queue and then have an app that is listening for messages on the queue access the database and write the metadata back to the object in Alfresco.

It is not clear what is the best option for your specific case.

Perhaps you could try one of these options and tell us if you get stuck.