I'm not a developer so I generally refer synchronization tasks such as this to https://roi-consulting.com/ - [email protected].

If you don't need to synchronize data from Sage then you could explore using Visual Integrator to create an import of orders.

There are a lot of different ways to approach data transfers, and which is right for you depends on budget, timelines and technical requirements.

• eBWS (Sage add-on with very limited functionality).
• ODBC for data extraction / Visual Integrator for imports (can be scheduled).
• 3rd party programs / enhancements (InSynch, WSP, MBA...).
• BOI - do it yourself programming using the Sage program API.

Having a talk with your Sage Partner / consultant about which option is a good fit for you might be a good idea.

If you have a client to Sage 100, you can access Sage 100 through the BOI or Business Object Interface. Since you are looking for more of a Web API you would need to use something like e-Business Web Services which is an additional module but is very limited to Sales Order, Customer and Customer Contact. Other options are SDATA which will allow access to more things and is configurable. Development for Web Services and SDATA has not changed in many years. Sage has also introduced a connector for Microsoft 365 that opens access to Sage from the Microsoft ecosystem. It is limited in what it can do and is currently being developed but you have to be connected through O365.

Other options go into 3rd Party. There are a handful. InSynch (https://roi-consulting.com/) is a Sync tool not so much as an API interface but it is used for ecommerce Sites. Website Pipeline (CimCloud) offers an API (https://www.cimcloud.com/products/data-hubs.asp) access through their network. There is also Sage Data Exchange (http://www.sagedataexchange.com/) which is an API using JSON or XML and is customizable. There are others as well, but these are just a few. 

If you don't know much about Sage 100 then it would be wise to work with your Sage Partner or Consultant to help you find the right option to use.

At our company, we have an external shopping cart that downloads orders into a JSON file. The JSON file is translated into records which are then imported into Sage Sales Order using BOI (Business Objects Interface). This is done on a schedule every 10 minutes.

Terminal server has nothing to do with this. We have this automated task run on the server so it's hands-off to the users.