Schulz Consulting

Sage 100cloud Consulting

  • Home
  • Services
  • Contact

SDATA: Sage’s “Secret Sauce” In Communicating Between ERP Systems and The Web?

January 25, 2010 by Wayne Schulz

sdata sage custom extension.jpg

Through the years most ERP companies have grown through acquisition.

From humble single product beginnings we’ve seen many companies including Sage North America evolve from a relatively tiny one product company called State of The Art which evolved to a company named Best Software then Sage Software then ultimately Sage North America or simply Sage.

As software companies grow and add products with different code bases the single most difficult issue is making each product share data. Acquired products have different core programming code as well as sometimes incompatible data dictionaries.

A common issue is how to link product A whose customer numbers can be 15 characters with product B whose customer numbers might only be 5.

For example the Sage Extended Enterprise is made up of at least three different products: Sage MAS200 + SageCRM + Sage FAS. Through the magic of programming, and brute force, Sage gets all three products to work together and exchange data.

But what if there was a standard that was simple and didn’t require extensive custom programming to enable communication between different products. This is where Sage’s open sourced SDATA protocols and SDATA extensions might come into play.

Stephen Smith, Chief Architect Sage Software, has done a great job of sharing some details of Sage’s SDATA protocols. Stephen’s job (from his LinkedIn profile) is:

Work on defining the architecture and technology direction for the Sage Accpac ERP line of accounting products. Leading the effort to modernize Accpac into a state of the art web based ERP package. Developing a shared Sage technology platform to bring together a number of Sage products into a unified end to end package with Accounting, CRM, HRMS and other vertical solutions; all sharing a common look and feel as nice user friendly web based applications.

According to Stephen’s blog posts (read the full post here) SDATA is a major new feature of Accpac 6.0:

One of the big features in Accpac 6 is SData support. What is SData? SData is a web services protocol based on REST. What is REST? REST is a web services protocol that is very popular among Internet companies. There are basically two main competing standards for web services. One is SOAP which is promoted by Microsoft, Oracle and IBM; this is a fairly heavy duty protocol which requires a fair bit of infrastructure (which is provided by the companies promoting this protocol). The other is REST which was invented as a University Research project and basically uses existing Web Technologies such as HTTP and RSS to implement a web services protocol. The nice thing about REST is that it doesn’t require any extra middleware. You are basically doing everything via standard web URLs. The infrastructure that supports this is basically just the standard Internet. SData is just an extension to REST, similar to Google’s GData which is also based on REST. REST protocols are used by Google, Amazon, eBay, Yahoo and all the main Internet companies. Gartner estimates that 75% of web services in use on the Internet are REST based. REST/SData also provides a standard mechanism for performing CRUD (create, read, update, delete) on all records.

While it may be too early to know how widespread the adoption of SDATA will be within all of Sage’s products, Sage certainly appears to be making a major push for it’s use. Sage ACCPAC is one of the ERP products (Sage ERP X3 is the other) that Sage has stated will be marketed worldwide.

I’ll be asking Sage where we can expect SDATA technology to appear next. For now it’s seems like an exciting addition to the Accpac 6.x product and will enable significantly greater interaction between different applications as Stephen explains:

All the new Sage ERP Accpac 6 screens are written entirely using SData. This means the screen can access any Accpac Views via SData, but additionally they can access any SData feeds from any product. In Accpac 5.x, the screen controls were mapped via datasource controls to views and view fields. This was great, but it limited you to only connecting our standard controls to fields in Views developed in our SDK. Now that the controls are mapped to a standards based SData fields, it means they will be able to be connected easily to much more data than just Accapc data. Look for other Sage products to start providing SData interfaces in their coming versions.

Read more about SDATA on the Sage SDATA web site or visit Stephen Smith’s blog via Geni Whitehouse – Even A Nerd Twitter Stream

Share this:

  • Twitter
  • Facebook
  • Email
  • LinkedIn

Filed Under: Sage 100 ERP Tagged With: accpac, sage, sdata, stephen smith

About Wayne Schulz

Wayne Schulz is a Sage 100 Consultant located in Connecticut. He has worked with Sage 100 and Sage 100cloud ( Formerly Sage MAS 90 and MAS 200) since 1986 and provides advanced Sage 100 technical support to companies located in Connecticut, Massachusetts, Rhode Island, New York and throughout the United States. If you are experiencing an issue with Sage 100, and would like to schedule a support session - please request assistance here or call 833-724-3100.

Search Our Site

Sage 100cloud Latest News

  • What Are The Differences Between Sage 100 Perpetual and Subscription Licenses? January 11, 2021
  • Sage 100 Aatrix e-Filing Bug Erroneously Reports Bad SSN Matches for 2020 January 6, 2021
  • There is No Sage 100 IRD for 2020 January 6, 2021
  • Is Your Sage 100 Payroll Year-End Processing Slowly? January 5, 2021
  • Sage Announces Sage Partner Cloud December 16, 2020
  • What Happens When Your Sage 100 Subscription Expires? December 10, 2020
  • Sage 100 – 2020 eFiling Deadlines for W2, 1099 and ACA Released December 9, 2020
  • Sage 100 data conversion for version 2020.1 takes a long time or appears to hang on IM_LotSerialTransactionHistory when it contains a large number of transactions. December 8, 2020

Our sponsors

Contact Us

Schulz Consulting
Connecticut Office
Phone: 860.657-8544
Email Us
Locally serving all of Connecticut, Massachusetts, Rhode Island, Vermont,
New York, New Jersey. Available remotely nationwide.
We are a local branch of DSD Business Systems Connecticut.

Copyright © 2021 · Parallax Pro Theme on Genesis Framework · WordPress · Log in

loading Cancel
Post was not sent - check your email addresses!
Email check failed, please try again
Sorry, your blog cannot share posts by email.