I am currently looking for a database backend solution for my small (environmental) consulting firm.
I am thinking:
1. Zimbra for e-mail and calendaring;
2. Alfresco for document management; and
3. MySQL for the database.
However, I need to store project data, client data, and some billing data in the database and have the ability to add, edit, etc. information in the database from my employees desktops (with controls on who can do what).
I need to be able to search globally (e-mail, files on the file server, calendar, etc.) and have e-mails stored by project and/or client regardless of who sent or received the e-mail.
Besides Ty.fresco (in beta), is there any unified approach to providing me what I need?
People have suggested Joomla, SugarCRM, etc. I am not real familiar with any of the CRM or CMS solutions, so I am asking for help/suggestions.
Yes, I have a budget and am willing to spend (within reason) to get what I want and to help the projects that participate in my solution.
Thanks for comments/suggestions.