There are few ways to make your SugarCRM module to read from another application.
The easiest way which is very well documented is to modify your module’s vardef, add few fields and add a logic hook. when you load your sugar module, you will load additional data with you logic hook.
This works fine for most cases, but how do you search this data?
Another solution is to synchronize your databases. You can use Triggers(application level or Database level) to synchronize information between sugar’s database and another database. This is a bit ugly.
There is another solution with its own limitations.
you can create a view in SugarCRM’s database, so sugar reads its data from your View, as far as saving you will call your applications save routine, for example soap call.
This solution will let you treat your module like any other SugarCRM module and have complex search and display functionality.
Your view doesn’t have to be simple, you may create it by joining few tables.
Tags: Integration, MySQL, SugarCRM