Data transfer e-commerce SAGE 100c ? API ?

Question

Hi, 
 as a web developper I am currently tasked to automate orders transfert from our e-commerce Drupal 8 website to SAGE 100c. 
 I am a Drupal expert but complitly noob to sage so please bear with me. 
 I f I understood correctly our company connect to sage through a windows TSE server that use a heavy SAGE client. What is the correct way to approach this data transfer ? Idealy I'd use a web API, thanks in advance for any informations.

Kevin M · Answer

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.

T-Man · Answer

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.

Sage100User · Answer

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.

Sage 100

Data transfer e-commerce SAGE 100c ? API ?

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING