Integrating different applications always requires a certain amount of "custom code" to bring them together. One thing I noticed about OpenGoo when I installed it, is you can specify a prefix for the names of the DataBase tables. When integrating LAMP applications, one common technique is to have the applications use the same database. Each app uses a different prefix for the table names so there can be no problems if the apps have the same names for tables. XRMS (an open source CRM app) and OWL (an oopoen source doc. storage app) were integrated to give XRMS greater doc. management capabilities, and that is what they did. You had to install both apps tables in the same DB.
Just as an aside, I'm moving away from XRMS to OpenGoo. XRMS is very powerful, but not really working for me. When I upgraded my server, I could not move my documents stored in XRMS. I don't know what the problem was, but it forced me to look elsewhere. The UI in OpenGoo is deceptively simple. I continue to be impressed with the thoughtful feature set. Document storage with versioning! I LOVE it!
- Paul