TroubleShooting Tips in Sage 500- Sage CRM GUMU Integration

By | February 22, 2017

GUMU™ for Sage CRM – Sage 500 application is a real time bi-directional integration link. Using GUMU™ integration, you can integrate front and back office data. Using GUMU™, a user can promote Sage CRM Company, promote sales order from Sage CRM to Sage 500 . In addition to this, all the information for Sage 500 customer flows between Sage CRM – Sage 500 on real time depending on your configured settings option in GUMU™ configuration.

New Stuff: New Feature in Sage 50- Sage CRM Integration – Additional Address

Today in this blog, we will discuss about troubleshooting tips for resolving an error message related to ‘Data Source Name GUMUMAS500’ while configuring GUMU from Sage CRM side in GUMU™ Sage CRM – Sage 500 integration link.
Error Message: While configuring GUMU integration for a Company Code, user may come across an error message saying “Data Source name GUMUMAS500 not found. Please specify valid data source name”.
Refer below image for error.

User will not be able to save the Configuration details when this error occurs.
Reason: This issue generally occurs when GUMUMAS500 DSN is not properly configured OR SQL details in DSN configuration is either not proper or using windows authentication for logging to SQL for DSN.
1.Check the DSN configuration from the path, C:\Windows\SysWOW64 and open “odbcad32.exe”.

2.Check if correct database name is entered.

3.Select SQL Server authentication instead of Windows authentication and enter the SQL Details as shown below.

4.This should resolve the issue and user should be able to configure GUMU from Sage CRM.
If the issue still persists you can always contact Greytrix ( for help.
About Us
Greytrix is one stop solution provider for Sage ERP and Sage CRM needs. We provide complete end-to-end assistance for your technical consultations, product customizations, data migration, system integrations, third party add-on development and implementation expertise.
Greytrix has some unique integration solutions for Sage CRM with Sage ERP’s (Sage X3Sage 100Sage 500 and Sage 300). It also offers best-in-class Sage ERP customization and development services to Business Partners, End Users and Sage PSG worldwide. Greytrix helps in migrating to Sage CRM from ACTGoldmine and other CRM’s.