Sugar CRM get data from other SQL DB

Posted on 2011-05-06
Last Modified: 2016-03-18

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!
Question by:penthese
    LVL 2

    Accepted Solution

    You have two options really,

    1) develop a syncronisation tool to copy the data from the MSSQL database into the sugarCRM database through the sugarCRM api. This is likely to be a bit tricky, as you'll need some way of identifying the users from the invoicing system within SugarCRM.

    2) develop a plugin to sugarCRM to show the invoices from the invoicing application. This will also need a way of identifying the invoicing account related to the SugarCRM account.

    Both of these should be possible, but aren't likely to be simple plug and play, unless of course someone has already developed a sugarcrm plugin for the invoicing application you are using. Take a look on as it is possible.


    Author Comment

    Thanks for your answers, i've found a solution called Apatar which is able to connect all data sources to sugarcrm, great opensource solution for these kind of connections.

    Author Closing Comment

    Not the final problem solved.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    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.
    Creating and Managing Databases with phpMyAdmin in cPanel.
    Video by: Steve
    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…

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now