SQLA Directory Server with OpenCMIS Support

[thomas_duemesnil]

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.

CREATE SERVER server-name
CLASS 'CMISDIRECTORY'
USING 'http://dms.url.local/....'


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
SELECT ObjectId, SCORE() AS Relevance, Destination, DepartureDates
  /* The SELECT is required and specifies which Virtual Columns
      (or Properties) will be included in the results */
FROM TravelBrochure
  /* The FROM Clause is required and Specifies which Virtual
      Tables (Or Object Types) the query will run against */
WHERE CONTAINS(‘CARIBBEAN CENTRAL AMERICA CRUISE TOUR’)
  AND ‘2010-01-01’ < ANY DepartureDates
  /* The WHERE clause is optional and specifies which constraints
     the rows returned must satisfy */
ORDER BY Relevance DESC
  /* The ORDER BY clause is optional and specifies the order in
     which the rows must be returned


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. 

[Breck_Carter]

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 🙂

[thomas_duemesnil]

What is WAG ?-)

[VolkerBarth]

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