I currently have a project where I need to retrieve Files from a DMS Server (Alfresco). I was able to use the SQLA HTTP Client Procedures with the Alfresco REST API to successfully retrieve my Document. As my system is now bound to the Alfresco API I searched for independedn DMS Api standard. I found the OpenCMIS Project that is also supported by Alfresco.
The goal of the OpenCMIS Project is to have a standard way to interact with (wide) range of DMS Systems http://chemistry.apache.org/java/opencmis.html
It would be great if I could declare in SQLA a directory Server to traverse the Documents and access them as I can currently do with a Directory Server on the Server File System.
As OpenCMIS is a SQL like Query Language probably a Interface would be not too complicated.
Here is a old sample from http://www.oldschooltechie.com/blog/2009/11/23/cmis-query-language
The Projact is already developed for 5 years it has not reached a full version but is used already by some Companies.
Thanks for reading.
asked 18 Feb '15, 06:34