Welcome back to our GUMU™ Sage 100 Web API blog series! Today, we are going to discuss an important topic – performance. So, how does the GUMU™ Sage 100 Web API measure up compared to SData?
Let’s break it down and see!
Importing Data: GUMU™ Sage 100 Web API vs. SData
If you’ve worked with SData, you probably know it has some limitations – especially when dealing with complex data. For instance, if you need to bring in Orders, their Order Lines, and maybe Lot/Serial information, SData makes you work a little harder. You often need two or more separate import routines just to get the complete data related to order. It doesn’t support more than two level of queries or fetching multiple layers of related data in one go.
With GUMU™, you can run advanced queries that pull in multi-level data – like Orders, Lines, Lots, and more – all in one go. That means fewer API calls, less hassle, and a big improvement in performance. In most cases, it makes the whole process a lot faster and way more efficient compared to using Sdata.
Posting Data: How GUMU™ Makes Life Easier
With the SData API, there’s a limit to how much data you can post at once. Typically, you can post about 75 order lines when creating a new order. So, if you have an order with 100 lines, you’ll post the first 75, and then you need to post the remaining 25, one by one. That means you are making 26 separate API calls just to post 100 order lines. Based on our testing, posting an order with 100 lines through SData can take around 35 to 40 seconds.
Now, with the GUMU™ Sage 100 Web API, it’s a whole different story. You can post all 100 lines at once, no problem! In fact, we’ve successfully tested orders with over 300 lines in a single transaction – no delays, no splitting things up. It’s faster, simpler, and much more efficient.
Quick Comparison: SData vs. GUMU™ Sage 100 Web API
| Feature | SData | GUMU™ Sage 100 Web API |
| Import Complexity | Needs multiple imports for multi-level data | One query can handle multi-level data |
| Query Flexibility | Limited / basic queries only | Supports complex and filtered queries |
| Order Line Limit | 75 lines per transaction | 300+ lines posted at once |
| Order Posting Speed | ~35-40 seconds for 100 lines | Much faster (tested with 300+ lines easily) |
| Bulk Update Support | Not supported for existing orders | Fully supported, including batch updates |
The following statistics show several imports we have performed with both APIs.
| Import Scenario | Sage 100 WEBAPI | Sage 100 Sdata | ||||
| Time Taken (secs) | Job Started | Job Finished | Time Taken (secs) | Job Started | Job Finished | |
| Customer (220 records) | 40 | 2025-03-17T10:42:15.000 | 2025-03-17T10:42:55.000 | 52 | 2025-03-17T10:59:26.000 | 2025-03-17T11:00:18.000 |
| Orders (257 records) | 35 | 2025-03-17T10:51:45.000 | 2025-03-17T10:52:20.000 | 58 | 2025-03-17T11:01:43.000 | 2025-03-17T11:02:41.000 |
| Order Lines | 79 | 2025-03-17T10:54:52.000 | 2025-03-17T10:56:11.000 | 118 | 2025-03-17T11:25:41.000 | 2025-03-17T11:27:39.000 |
| Products (72 records) | 13 | 2025-03-17T10:57:41.000 | 2025-03-17T10:57:53.000 | 12 | 2025-03-17T11:18:06.000 | 2025-03-17T11:18:19.000 |
Note: These performance results are based on testing in a controlled environment, so things may vary a little bit when working in production system. Factors like system setup, data volume, and network speed can all play a role. But one thing is clear – GUMU™ Sage 100 Web API offers a big boost in performance and flexibility over SData, especially when handling large volumes of data or complex transactions.
And that’s a wrap for today! We’ll be back soon with more tips, insights, and deep dives on how the GUMU™ Sage 100 Web API can make your Sage 100 integrations faster and easier. Curious to learn more or want to see it in action? We’re just a message away.
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.
