长期愿望是SData 将提供完整的 CRUD 设施并简化不同 Sage 程序（其中有很多！）之间的集成，因此提供一致的 Web 服务，第三方应用程序也可以与之集成。
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.
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
我已经用 Sage Line 50 V9 做了很多工作（我知道有几个旧版本）。 Sage 提供了一个 ODBC 驱动程序，您可以愉快地与 ADO 和 ADO 进行交互。 ADO.NET。 然而，该驱动程序是只读的，这对您来说可能是问题，也可能不是问题。 不过，SQL 查询似乎确实存在一些限制 - 特别是双连接不起作用 (a JOIN b JOIN c) & 需要被压平。 此外，DISTINCT 关键字似乎无法被识别。 希望这有一些用处。
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.
Going back a few years, but Sage also used to provide a read-write API (not ODBC based) for accessing the data in their products.
I'm not surprised that you need to join the developer program - Sage is a traditional closed source commercial application - it's unlikly to have open source options available for it.
Joining the dev program used to be free for Sage customers, which the people you are working for should be, surely...?
发布评论
评论（4）
Sage 正在转向一种新的方法，称为 SData。 我认为您可以在 http://sdata.sage.com/ 阅读此内容
长期愿望是SData 将提供完整的 CRUD 设施并简化不同 Sage 程序（其中有很多！）之间的集成，因此提供一致的 Web 服务，第三方应用程序也可以与之集成。
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.
在 Sage UK 网站上，我发现了以下开发人员 SDK。
结果是，如果您想使用 SDK，则需要使用 .Net。
问题是 SDK 仅在开发者计划下提供，起价为 1500 英镑：这是手册。
然而，开发人员计划确实为您提供了用于开发目的的 Sage 软件的免费副本，因此如果您的业务是 Sage 集成，我可以看到好处。
另一种选择是 Sage 的插件，Sage 售价 299 英镑
http://shop。 sage.co.uk/pdf/connect_for_Sage_50.pdf
这提供了 XML 导入/导出工具，这可能足以满足我的目的。
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.
我已经用 Sage Line 50 V9 做了很多工作（我知道有几个旧版本）。 Sage 提供了一个 ODBC 驱动程序，您可以愉快地与 ADO 和 ADO 进行交互。 ADO.NET。 然而，该驱动程序是只读的，这对您来说可能是问题，也可能不是问题。 不过，SQL 查询似乎确实存在一些限制 - 特别是双连接不起作用 (a JOIN b JOIN c) & 需要被压平。 此外，DISTINCT 关键字似乎无法被识别。 希望这有一些用处。
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.
追溯到几年前，Sage 还曾经提供读写 API（不是基于 ODBC）来访问其产品中的数据。
我对您需要加入开发人员计划并不感到惊讶 - Sage 是一个传统的闭源商业应用程序 - 不太可能有可用的开源选项。
过去，Sage 客户可以免费加入开发计划，而你为之工作的人也应该是这样的……？
编辑-哎呀，不再免费了
Going back a few years, but Sage also used to provide a read-write API (not ODBC based) for accessing the data in their products.
I'm not surprised that you need to join the developer program - Sage is a traditional closed source commercial application - it's unlikly to have open source options available for it.
Joining the dev program used to be free for Sage customers, which the people you are working for should be, surely...?
EDIT - yikes, not free any more