How to link alfresco's database to another database??

[cyrose22]

How to link alfresco's database to another database??

We have a project that will link the alfresco database and our company database and compare the PO's inserted if it's inserted. Is there a way to do it?

Please help. Thanks

[krutik_jayswal]

Ideally you should not directly deal with the database.I suggest to make the webservice on alfresco side and do the comparison over there.Using this you will be able to access the other database as well.

Below link will help in how to create webscript in alfresco.

Introduction to the Web Script Framework | ECMArchitect | Alfresco Developer Tutorials 

Repository webscript in alfresco | Krutik Jayswal 

[mehe]

...for me, it's quite unclear what you want to do - link a database to another? what are POs?

But I'm quite sure, that the alfresco database model and the model of your company database are very different. So it seems not the right way to compare inserted objects on database level.

If I have to compare or check objects that should be imported to alfresco, I normally use an external ID, stored in an alfresco aspect. So I can checkup the IDs in alfresco and the other system with a simple script or web-service.

[cyrose22]

by the way PO's are (Purchased Orders)

Thanks