Welcome back to our GUMU™ Sage 100 Web API blog series! Today, we are going to discuss an important topic – performance. So, How does Greytrix’s new GUMU Sage 100 WebAPI compare to SData (being decommissioned)?<\/p>\n\n\n\n
Continue reading to review examples of how the NEW WebAPI performs better.<\/p>\n\n\n\n
Importing Data: GUMU™ Sage 100 Web API vs. SData<\/strong><\/p>\n\n\n\n If you\u2019ve 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. <\/p>\n\n\n\n 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.<\/p>\n\n\n\n Posting Data: How GUMU™ Makes Life Easier <\/strong><\/p>\n\n\n\n With the SData API, there\u2019s 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\u2019ll 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. <\/p>\n\n\n\n Now, with the GUMU™ Sage 100 Web API, it\u2019s a whole different story. You can post all 100 lines at once, no problem! In fact, we\u2019ve successfully tested orders with over 300 lines in a single transaction – no delays, no splitting things up. It\u2019s faster, simpler, and much more efficient. <\/p>\n\n\n\n Quick Comparison: SData vs. GUMU™ Sage 100 Web API<\/em> <\/strong><\/p>\n\n\n\n The following statistics show several imports we have performed with both APIs. <\/p>\n\n\n\n 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. <\/p>\n\n\n\n And that\u2019s a wrap for today! We\u2019ll 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\u2019re just a message away. <\/p>\n\n\n\n About Us<\/strong><\/span><\/p>\n\n\n\n Greytrix \u2013 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.<\/p>\n\n\n\n Greytrix\u00a0has some unique integration solutions developed for Sage CRM with Sage ERPs namely\u00a0Sage X3,\u00a0Sage Intacct,\u00a0Sage 100,\u00a0Sage 500,\u00a0and\u00a0Sage 300. We also offer best-in-class\u00a0Sage ERP\u00a0and\u00a0Sage CRM\u00a0customization and development services\u00a0to\u00a0Business\u00a0Partners,\u00a0End\u00a0Users, and Sage PSG worldwide. Greytrix\u00a0helps in\u00a0the migration of Sage CRM from\u00a0Salesforce | ACT! | SalesLogix | Goldmine | Sugar CRM | Maximizer. Our Sage CRM Product Suite includes\u00a0add-ons like\u00a0 Greytrix Business Manager,\u00a0Sage CRM Project Manager,\u00a0Sage CRM Resource Planner,\u00a0Sage CRM Contract Manager,\u00a0Sage CRM Event Manager,\u00a0Sage CRM Budget Planner,\u00a0Gmail Integration,\u00a0Sage CRM Mobile Service Signature,\u00a0Sage CRM CTI Framework.Feature<\/em><\/strong> <\/td> SData<\/em><\/strong> <\/td> GUMU™ Sage 100 Web API<\/em><\/strong> <\/td><\/tr> Import Complexity<\/em> <\/td> Needs multiple imports for multi-level data<\/em> <\/td> One query can handle multi-level data<\/em> <\/td><\/tr> Query Flexibility<\/em> <\/td> Limited \/ basic queries only<\/em> <\/td> Supports complex and filtered queries<\/em> <\/td><\/tr> Order Line Limit<\/em> <\/td> 75 lines per transaction<\/em> <\/td> 300+ lines posted at once<\/em> <\/td><\/tr> Order Posting Speed<\/em> <\/td> ~35-40 seconds for 100 lines<\/em> <\/td> Much faster (tested with 300+ lines easily)<\/em> <\/td><\/tr> Bulk Update Support<\/em> <\/td> Not supported for existing orders<\/em> <\/td> Fully supported, including batch updates<\/em> <\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n Import Scenario<\/strong> <\/td> Sage 100 WEBAPI<\/strong> <\/td> Sage 100 Sdata<\/strong> <\/td><\/tr> \u202f <\/td> Time Taken (secs) <\/td> Job Started <\/td> Job Finished <\/td> Time Taken (secs) <\/td> Job Started <\/td> Job Finished <\/td><\/tr> Customer (220 records) <\/td> 40 <\/td> 2025-03-17T10:42:15.000 <\/td> 2025-03-17T10:42:55.000 <\/td> 52 <\/td> 2025-03-17T10:59:26.000 <\/td> 2025-03-17T11:00:18.000 <\/td><\/tr> Orders (257 records) <\/td> 35 <\/td> 2025-03-17T10:51:45.000 <\/td> 2025-03-17T10:52:20.000 <\/td> 58 <\/td> 2025-03-17T11:01:43.000 <\/td> 2025-03-17T11:02:41.000 <\/td><\/tr> Order Lines <\/td> 79 <\/td> 2025-03-17T10:54:52.000 <\/td> 2025-03-17T10:56:11.000 <\/td> 118 <\/td> 2025-03-17T11:25:41.000 <\/td> 2025-03-17T11:27:39.000 <\/td><\/tr> Products (72 records) <\/td> 12<\/td> 2025-03-17T10:57:41.000 <\/td> 2025-03-17T10:57:53.000 <\/td> 13\u00a0<\/td> 2025-03-17T11:18:06.000 <\/td> 2025-03-17T11:18:19.000 <\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n