How to integrate data entry application with document management system?

Question

We have a simple web-based data entry application for domestic business. Now the business wants to be able to attach the document to a row in the database that represents the business object. The document can be Word, Excel, PDF.

How can we do this?

I think that creating another home document management system is not a good idea. Instead, we can try to use a third-party document management system and closely integrate our application. Ideally, the entire user interface will remain in the application without going to an external system. Can i use sharepoint or documentum? What other options are there?

Application Platform - Java / Websphere. We have both an available infrastructure of Windows and Unix.

Answer 1

I think that any document management system can do what you request. At one time, we did something similar with Sharepoint. Systems provide an API that allows you to request documents that are stored. Exactly how the integration happens depends on the solution for which you are going.

You need to consider the platform on which your current system is built when you choose, because different solutions support different integration technologies. For example, if your current system uses .NET, then Sharepoint will be easy to integrate.

- , ​​ SQL-, , - .

Answer 2

, , , , , API- .

(, ), , .

,

long: id long: form_id

blob: form

Varchar (2): form_path

. " ", , . , ,

: document_id

Answer 3

, EDRMS, , .

EDRMS, , :

• ( !) API, .
• , .
• - , , , . - EOL!

, "" ; , , .

EDIT: There is a similar question here : Subversion was popular.