AnsweredAssumed Answered

Query property data from external database

Question asked by crankyelephant on Aug 1, 2014
Hello Everyone, To start off, I'm attempting to integrate Alfresco with Ephesoft. The problem I have run into is that Ephesoft stores data into a Mysql database, that it can't natively export with CMIS. So I was hoping I could setup Alfresco to query this external database, and stick this returned value into a document property field in Alfresco. I really just don't know where I should begin? I have played around a bit in the folder rules and they would work perfectly, but I don't think I can query a database using javascript. I can write a java class, but where would I put that code? Im new to both programs, so maybe am I way off base? If anyone could point me in the right direction, it would be very helpful.

System Info
-Both Ephesoft and Alfresco are run off the same server
-Both now use Mysql databases
-We are running Alfresco Community 5.0.a
-The System is running windows server 2012