we are currently running SugarCRM community edition on MySQL server.
We have a separate program which is using MSSQL server to create our invoices.
The problem is that we want to integrate these 2 programs with each other, so a contact in sugarcrm should have invoices in the activities.
We can analyze the SQL queries the invoice program generates.
Does someone know how to start this?
Are there any plugins to make it easier to integrate foreign data to sugarcrm?
Thanks in advance!
CCModeler offers a way to enter basic information like entities, attributes and relationships and export them as yEd or erviz diagram. It also can import existing Access or SQL Server tables with relationships.
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…