Sage 200 API and Integration Options

In the modern business world, it is very often a requirement that a business will wish to integrate disparate pieces of software to avoid duplication, re-keying and potential for error.

Many of the Sage 200 sites we currently support have a Sage integration of some sort with a third party system. A frequent example of this is a Sage 200 e-commerce website link (Sage 200 Magento integration is very common) but clients will often also wish to link the, best in class, Sage 200 Accounting Ledgers to an industry specific or bespoke commercial system.

Sage 200 has standard import capability ‘out of the box’ which will allow a CSV file in the required format (which we would provide) to be manually imported to the system by the user.

If your Sage 200 integration requires automating or has multiple, perhaps two way, integration points (which 90% of them do) then we would look to utilise our own Sage 200 API.

Traditionally, integrations with Sage 200 have involved deploying standard middleware such as Eureka Data Exchange Sage 200 to automate CSV or XML file transfer or specific bespoke development. Whilst both these solutions are still valid, are working happily in many sites and remain suitable for some scenarios, API technology is now becoming an industry standard for software of all sizes.

This method of integration is much more modern way of working and is significantly more efficient than file transfer. Particularly when handling large volumes of data or mapping fields from third party bespoke applications.

The API offers a new way of thinking and allows data to be stored in one place, Sage 200 where it belongs, and for third parties to query specific data quickly and easily rather than a mass sync.

Unlike the scheduled mass update approach of the past, the API is event driven. This allows Smith Cooper or third parties to interact with Sage 200 in smaller more manageable chunks of data, which in turn, leads to a more robust, performant solution.

The key premise of the tool is that we have a standard data model of the data to be imported in to Sage 200 good to go, ‘out of the box’. In simple terms this is a list of the Sage 200 fields and the rules of the data with which to populate them with. The data model has been designed by us to include the required field for each operation in Sage 200, but crucially it is also capable of also updating any analysis code or custom fields too, as required by your project.

Smith Cooper have integrated Sage 200 with many different platforms and applications already and will be launching various new standard plug-ins during the coming months.

We would be delighted to discuss your requirements in more detail so contact us now below or directly on 01332 587515 or to tell us more about your project.

Sage Integration FAQ's