In GUMU™, Node-RED is used to fetch real-time data from Sage 100 and display it in Sage CRM Kendo grids, providing seamless query execution and live updates. This ensures that users can access critical ERP information directly within Sage CRM without delays.
What is Node-RED?
Node-RED is a flow-based development tool that allows users to visually build applications by connecting nodes, each representing a functional block that can receive, process, or send data. With its drag-and-drop interface, Node-RED simplifies workflow automation, making it widely used for IoT, API integrations, data processing, and dashboard visualizations.
Within GUMU™, Node-RED executes queries against Sage 100 to retrieve live data and populate CRM Kendo grids efficiently.
Benefits of Node-RED in GUMU™
- Simplified Workflows: Easier to understand, configure, and maintain
- Rapid Issue Detection: Quickly identifies and resolves data or workflow errors
- Faster Development: Reduces the need for complex programming, enabling faster deployment
- Data Integrity: Ensures consistent and accurate real-time data retrieval
Common Issues
At some client sites, Node-RED faced connection challenges:
- Credentials stored in Node-RED flows occasionally disappeared
- Even with correct SQL and CRM database credentials, Node-RED could not establish a connection
- These issues impacted real-time data retrieval and Kendo grid population
How to Fix Node-RED Connection Issues
The resolution involved upgrading Node-RED to version V18.12.1. This update addressed credential persistence bugs and database connection issues. Post-upgrade, Node-RED was able to:
- Maintain SQL and CRM credentials within flows
- Establish stable connections to the CRM database
- Ensure reliable real-time data retrieval from Sage 100
- Enable consistent and seamless Kendo grid updates
This approach improved workflow reliability, authentication handling, and overall data integrity in production environments.
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 X3, Sage Intacct, Sage 100, Sage 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 add-ons like Greytrix Business Manager, Sage CRM Project Manager, Sage CRM Resource Planner, Sage CRM Contract Manager, Sage CRM Event Manager, Sage CRM Budget Planner, Gmail Integration, Sage CRM Mobile Service Signature, Sage 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 sage@greytrix.com. We will be glad to assist you.