Seven years ago, I wrote a custom document management system for my company. In a nutshell, we are a tax return preparation company and we store the tax return document (along with supporting documents) in the system. The system now has approximately 275,000 documents stored within the system. The main management purpose is to allow accountants a quick review of historical documents when preparing tax returns (search via meta data such as year, name, and numerous other tags/subjects).
The documents are also occasionally viewed externally by clients (with certain rights to view certain documents).
Many of the documents are automatically entered into the system via one of our custom tax return system. The system generates a tax return in PDF format. The PDF is then inserted into our document management system via a SQL update.
I am now at a point where I need to add additional functionality to the system including a web interface for both remote and local users, edit capability, versioning, etc. Rather than re-writing my code and adding a bunch of new functionality, I'm curious if Alfresco would be a viable alternative? Is it customizable enough where I can automate my insertions (along with permissions) from our own custom applications?
Due to security reasons, the database and documents must be hosted locally.
