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

cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Active Member II

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

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

3 Replies
Highlighted
Senior Member II

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

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 

Highlighted
Senior Member II

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

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

Highlighted
Active Member II

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

by the way PO's are (Purchased Orders)

Thanks Smiley Happy