topic Re: How to link alfresco's database to another database?? in Alfresco Forum

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

cyrose22 — Mon, 26 Mar 2018 07:27:36 GMT

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

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

krutik_jayswal — Mon, 26 Mar 2018 07:36:59 GMT

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

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

mehe — Mon, 26 Mar 2018 07:39:52 GMT

...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.

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

cyrose22 — Mon, 26 Mar 2018 08:10:55 GMT

by the way PO's are (Purchased Orders)

Thanks