What is Sage Data Exchange?
Sage Data Exchange is a JSON and XML API for Sage 100 Standard, Advanced, and Premium. Web and Application developers use JSON or XML to post Sales Orders, Quotes, Customers, Vendors, almost any object in Sage 100. Developers can also define the data returned by a GET or the response from a POST. They can do all this without needing to know much about Sage 100.
How does Sage Data Exchange Work?
Sage Data Exchange resides on your server, listening for JSON or XML requests.
When a authorized request is received, Sage Data Exchange queries your Sage 100, and responds to the request.
Post requests (update and create) are handled by the Sage 100 native business objects.
Even User Defined Tables and Fields can be read, and written to, via Sage Data Exchange. Business Objects and object overrides, written by Sage 100 Developers, are available as well.
Who uses Sage Data Exchange?
We have many customers running Sage Data Exchange. Listed below are a few. We don't provide company names, but it may be helpful to know about the connections that are possible with Sage Data Exchange. If you are intereseted, please contact us through the Support page.
A Georgia customer produces and sells trade show and event equipment. Their products run the gamut on all things exhibition related.
They already had a Woo Commerce web store, but wanted a way to post the orders from the site directly into Sage 100. Working with their development staff, Woo Commerce now posts a JSON order document to Sage Data Exchange, which posts the order into Sage 100.
They are now working with a freight management system, gathering rates from several freight companies to get the best rate shipping their sales orders. Sage Data Exchange is used to gather infomation about the order, and create the Shipping Entry.
Another customer created their own custom web store that posts paid Sales Orders into Sage 100 through Sage Data Exchange.
The creators of the web store are Paya developers. The site charges the customers credit card online. When the order is posted to Sage 100, they include all the Paya transaction information.
Sage Data Exchange is running at national printing company that wanted to move off their EDI platform onto a new system managed by Coupa using cXML.
Their national customer has close to a thousand stores all ordering automatically through Coupa, posting orders into Sage 100.
With the success of receiveing orders through Coupa, they've added another connection for a printer supplies company to post their orders.
|A netting manufacturer created a button in Salesforce that posts CPQ quotes to Sage 100 through Sage Data Exchange.|
|A fireplace distributor in New York is working with Sage Data Exchange to pull data out quickly for custom reporting.|