Schulz Consulting

Consulting and Upgrades

  • 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:

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

Secure cloud hosting for Sage 100
Call 1-888-244-6559 (toll-free)

About Wayne Schulz

Wayne Schulz is a Sage 100 Consultant located in Connecticut. He has worked with Sage 100 since 1986 and provides advanced support to companies located 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 860-657-8544.

Access Sage 100 in the cloud today. 3rd party applications supported Available 24/7 from anywhere. Dedicated hosts

Call 1-888-244-6559 (toll-free)

Search Our Site

Sage 100 Newsletter

Sage 100 News

  • How To Edit 1099 Totals In Sage 100
  • How to Reconcile Sage 100 Accounts Payable Detail to the General ledger
  • Sage 100 Year-End 2022 Training Series
  • Minimum Sage 100 Versions for E-Filing for Tax Year 2022
  • What Are The Differences Between These Sage Fixed Asset Versions: Lite, Single-User, Network and Premier?
  • Sage 100 Paperless Email Electronic Delivery Failing With Rackspace
  • How To Check Sage 100 Compatibility with Avalara’s TLS 1.2 Requirement
  • Sage 100 TLS 1.2 Compliance Update ( Nov 2022)
  • What Are My Sage 100 Mobile Sales Options?
  • Sage 100 Payroll Tax Update Set for 10/27/22 for New York State Health Care Workers Bonus Program (HWB)

Contact Us

Schulz Consulting
Connecticut Office
Click Here To Contact Schulz Consulting
Email Us
Available remotely nationwide.
We are a local branch of DSD Business Systems Connecticut.

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