REST API web service

Question

I've seen some tools mentioned: Web Services (eBM) and sData; would these tools allow to retrieve information (i.e. items) from sage100Advanced and export it and also importing to sage; is BOI appropriate for this? and do I need to be a partner to use any of these?

T-Man · Answer

BOI is a great built in option to interface to Sage from other applications if you are local to the server. There are a handful of other 3rd party options related to getting data in and out from Sage. While it isn't a REST API you have In-Synch that will synchronize the data between two systems. CIMCloud has an option that Syncs data and has an API with their Data Hub and API Interface . Then you have SDE that provides a JSON and XML API for Sage 100. These are just a couple of them. Each has their positives and negatives. This is just so you know there are options, even though they are not built in by Sage and have an additional cost.

Kevin M · Answer

If you just want to retrieve information, ODBC is easiest, but Advanced requires the Providex ODBC driver be installed where you are running the query..

Kent Mackall · Answer

Greetings, 
 Please look at using BOI for this. SData is no longer being updated at this point and eBM Web Services are limited. 
 If you are new to BOI, please take the Object Interface training course available from Sage University. This course teaches the basics of BOI and gives you a foundation for doing BOI development. 
 If you are not familiar with the Sage 100 Data files or want a refresher, you may also want to take the Data Files Structure training. Understanding the data structure is helpful when working with the business objects. 
 Thanks, Kent Mackall

Kevin M · Answer

Not directly, no. T-Man 's suggestions are common ways to bridge to the internet, unless you want to build your own bridge using BOI.

Kevin M · Answer

The 3rd party tools exist for a reason: building a bridge is not easy, with a high learning curve (for working with Sage 100's internal processing logic... and each type of transaction you want to work with). If you want to do one or two things, DIY may be cheaper, but if you are looking for a feature rich integration you may want to look at an existing solution.

Sage 100

REST API web service

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING