customize database storage?
Hello,
I am wondering if Nuxeo could fit my needs. My situation is the following: I have documents stored in an sql server database with a structure that is not the same as the Nuxeo database structure. In that database, documents are stored as binary blobs in a dedicated table. This database is also used for other purposes by an application (let's call it App). I would like to edit/modify my documents through a dedicated tool since it is not the purpose of App. So, my question is: do you think that Nuxeo can be easily customized to read and store documents in my database instead of its default one? I can eventually add columns to my Document table or even add tables to my database.
The terse answer - NO (it would not be easy). For that matter it wouldn't be recommended either since you lose the value of the core of Nuxeo. Depending on what App is, the better approach is to blackbox Nuxeo as your backend document repository (export your blobs out of your DB and import into Nuxeo) and use a REST api to interact with Nuxeo.