Menu
I have recently been asked to develop an application that will have to integrate with Sage Line 50 financial software.
I've done some googling and I am surprised at the lack of info on interfacing with Sage from Java or .Net.
Is Sage such a black box that you need to sign up to a Sage Developer program before you get any info?
Are there any open source options to allow apps to talk to Sage?
Any info appreciated.
Cheers
Paul
274
It's an aging industry, full of traditionalists so those who started with Sage have mostly stayed with Sage. 90% of accountants in the UK recognise the Sage format because of this, either using it in the past or still use it today, passing it on to their employees and the next generation of accountants.
Discontinuation of older versions of Sage 50 Accounts and Sage50cloud accounts from September 2022. Accounting software provider Sage has recently advised that after 30 September 2022, Sage 50 Accounts and Sage 50cloud Accounts v26. 2 and below will no longer be accessible.
In 2017, Intacct Corporation was acquired by the British multinational accounting software company, The Sage Group PLC, for $850 million and was subsequently rebranded as Sage Intacct.
If you have antivirus software on your computer, check if the software has quarantined any Sage files or folders. If so, add those Sage files and folders to the antivirus exception list, then either restore the quarantined files from within the antivirus software, or reinstall Sage 50cloud Accounts.
Looking on the Sage UK site I found the following Developer SDK.
Upshot is that you need to use .Net if you want to use the SDK.
Problem is that the SDK is only available under the Developer programme which starts at £1500: Here's the brochure.
However the developer programme does give you free copies of the Sage software for development purposes, so I can see the benefits if your business is Sage integration.
Another option is an addon for Sage which is sold by Sage for £299
http://shop.sage.co.uk/pdf/connect_for_Sage_50.pdf
This gives an XML import/export facility, this may be enough for my purposes.
31
Theres a new methodology Sage are moving to called SData. I think you can read about this at http://sdata.sage.com/
The long term aspiration is that SData will provide full CRUD facilities and simplify integration between different Sage programs (of which there are many!) and therefore provide a consistent web service that 3rd party applications can be integrated with too.
79
I've done quite a bit with Sage Line 50 V9 (a couple of versions old, I know). Sage provide an ODBC driver which you can happily talk to with ADO & ADO.NET. The driver is however read-only which may or may not be an issue to you. There do seem to be some limitations with SQL queries though - in particular, double joins don't work (a JOIN b JOIN c) & need to be flattened-out. Also, the DISTINCT keyword doesn't seem to be recognised. Hope this of some use.
27
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
