Re-point GUMU™ Sage CRM – Sage X3 Integration connection to different Sage X3 folder

By | December 30, 2017

There are many instances where client generally setup their Sage CRM server with TEST Sage X3 folder using GUMU™ integration for testing purpose and once they completes their testing, client can take same Sage CRM to Live by re-pointing to different Sage X3 folder (Live folder).

New Stuff: GUMU™Integration v/s Sage Integration for Sage CRM and Sage X3

For achieving this, user can follow below instructions.

  1. Take complete backup of Sage CRM system including DB.
  2. Take complete backup of Sage X3 system including DB.
  3. Below are the steps for pointing different Sage X3 folder from same Sage X3 server in Sage CRM GUMU configuration.

a. Let’s consider currently ‘TEST’ folder is integrated and now user want to point ‘LIVE’ folder in GUMU™ integration.
b. Delete all the records from Sage CRM database which are related to ‘TEST’ folder.

  1. To delete the records, login into Sage CRM SQL database server.
  2. Now user have to delete data from CUSTOM_CAPTIONS table, to delete it run the below query in SQL
    Update Custom_Captions set Capt_deleted=75′ where Capt_Code like ‘TEST%’ and Capt_Deleted is null
  3. Now delete all the TEST records created in CRM and which are associated with old Sage X3 folder from below tables of Sage CRM.
  • Company
  • Person
  • Address
  • Address_Link
  • PhoneLink
  • EmailLink
  • NewProduct
  • ProductFamily

c. Delete the Link server which is created in CRM SQL SERVER pointing to old TEST Sage X3 folder. Create the new link server which is pointing to the new Live Sage X3 folder.
d. Refresh the Sage CRM Metadata and RESET IIS.
e. Install all the Sage X3 patches on New ‘LIVE’ folder.
f. Re-configure GUMU™ from both Sage CRM and Sage X3 side and complete the testing.

For more information, you can always contact us at

About Us

Greytrix – a globally recognized and one of the oldest Sage Development Partners is a one-stop solution provider for Sage ERP and Sage CRM organizational needs. Being acknowledged and rewarded for multi-man years of experience and expertise, we bring complete end-to-end assistance for your technical consultations, product customizations, data migration, system integrations, third-party add-on development, and implementation competence.

Greytrix has some unique integration solutions developed for Sage CRM with Sage ERPs namely Sage X3Sage IntacctSage 100Sage 500, and Sage 300. We also offer best-in-class Sage ERP and Sage CRM customization and development services to Business Partners, End Users, and Sage PSG worldwide. Greytrix helps in the migration of Sage CRM from Salesforce | ACT! | SalesLogix | Goldmine | Sugar CRM | Maximizer. Our Sage CRM Product Suite includes addons like  Greytrix Business ManagerSage CRM Project ManagerSage CRM Resource PlannerSage CRM Contract ManagerSage CRM Event ManagerSage CRM Budget PlannerGmail IntegrationSage CRM Mobile Service SignatureSage CRM CTI Framework.

Greytrix is a recognized Sage Champion Partner for GUMU™ Sage X3 – Sage CRM integration listed on Sage Marketplace and Sage CRM – Sage Intacct integration listed on Sage Intacct Marketplace. The GUMU™ Cloud framework by Greytrix forms the backbone of cloud integrations that are managed in real-time for the processing and execution of application programs at the click of a button.

For more information on our integration solutions, please contact us at We will be glad to assist you.