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 Thomas Dueme... |
A directory server interface probably won't work because it won't support SQL... but a "classic" remote server based on CLASS 'ODBC' might work if there is an ODBC driver for OpenCMIS...
...and thus ends this WAG :)
What is WAG ?-)
That's just a wild [...] guess - cf. that page
http://en.wikipedia.org/wiki/Wag_%28disambiguation%29
and have a look at the first entry below "WAG may refer to:" :)
While I follow Breck's reasoning that a SQL-like "remote access API" would look like the classic remote servers, the output from a CMIS seems more like the directory/file results of a directory access server, it's not clear to me what similarity may be more relevant here... (yep, that's just another WAG).