将远程 PHP/Apache 服务器连接到 Quickbooks/Windows
我们有一个装有 Apache 的 Linux 机器，运行 PHP。 我们在网络中有一台运行 Quickbooks Enterprise Edition 9.0 的常规台式计算机。
我正在尝试构建一个托管在 Linux 机器上的自定义 Web 应用程序，该应用程序能够与 Quickbooks 通信。
我是 Quickbooks 的新手，这对我来说很困难。 环顾四周，我发现了很多技术，但没有一个看起来简单。 在我深入探讨之前，我想知道是否有人有这方面的经验并可以就第一步提供建议。
我听说过 Quickbooks SDK、QODBC、Web Connector 等... 对这些技术和其他可用技术的澄清将非常好。 另请记住，PHP 代码将在另一台计算机（Linux）上运行。
谢谢
。 我知道已经有其他与 Quickbooks 相关的帖子，但它们要么不够清晰，要么涉及与 Quickbooks 在同一台机器上运行的 Web 代码。
We have a Linux box with Apache, running PHP.
We have a regular Desktop computer in the network running Quickbooks Enterprise Edition 9.0.
I am trying to build a custom web application hosted on the Linux box that would be able to talk to Quickbooks.
I'm new to Quickbooks, which makes it hard for me.
While looking around I found many technologies, none of them looked simple.
Before I go ahead deep into it, I wondered if anyone has experience with this and could advise me on that first step.
I heard of Quickbooks SDK, QODBC, Web Connector, etc...
Clarifications on those technologies and other availables would be very nice.
Also keeping in mind that the PHP code will be running in a different computer (linux).
Thanks
PS. I know there are already other posts related to Quickbooks, but they were either not clear enough, or involved the web code running on the same machine as Quickbooks.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
首先，为您提供一些链接和术语...
QuickBooks SDK - 它包含用于与其他应用程序集成的所有 QuickBooks 相关文档，无论是通过 COM、SOAP、RPC 请求等。有用的测试和验证工具。 无论您选择什么路线，您都会想要下载它。
http://developer.intuit.com/
QuickBooks OSR - 这是向您展示所有内容的主要参考点您可以发送到 QuickBooks 的请求以及 QuickBooks 发回的响应。
https://developer.intuit.com/qbsdk-current /Common/newOSR/index.html更新链接：https://developer-static.intuit.com/qbSDK-current/Common/newOSR/index.html
QuickBooks PHP 框架 - 这是专门为 PHP 与 QuickBooks 通信而设计的框架。 免责声明：我是作者。 它旨在与 QuickBooks Web Connector 配合使用（稍后会详细介绍）：
https://idnforums.intuit.com/messageview.aspx ?catid=56&threadid=9164更新链接：https://github .com/consolibyte/quickbooks-php
QuickBooks Integration Wiki - 讨论 QuickBooks 集成的 Wiki。 免责声明：我是作者。 这里：
http://consolibyte.com/wiki/doku.php/quickbooks
QODBC - 这是 QuickBooks SDK XML 请求的包装器，它为 QuickBooks 数据提供 ODBC 驱动程序。 这是一个商业产品，但据说效果非常好。 我听说有时对性能有一些担忧，所以我会在你承诺之前尝试一下。
AccessBooks - 这可能是您的另一种选择，它提供了一种将 QuickBooks 数据镜像到 SQL 数据库的方法。 它是一种商业产品，关于它的实际效果，我听到过各种各样的说法。
QuickBooks Web 连接器 - 这提供了一种使用 SOAP 和 qbXML 向 QuickBooks 发送请求并从 QuickBooks 接收响应的方法。 您应该使用它来将 Apache/PHP 设置与 QuickBooks 链接起来。 这是唯一 Intuit 支持的将网站链接到 QuickBooks 的方法。
QBFC - 这是与 QuickBooks 通信的 Windows COM/DCOM 方式。 不适用于您，因为您使用的是单独的计算机并使用 Linux。
RDS - QuickBooks 的远程数据共享。 这不适用于您，因为它仅适用于 LAN 内。
IDN 论坛 - Intuit 开发者论坛是发帖寻求帮助的好地方：
http://idnforums.intuit.com/更新的链接：https://intuitpartnerplatform.lc.intuit.com
现在一些额外的想法/信息：
请记住，尽管 QuickBooks 是它由 SQL 数据库支持，但不允许您直接访问其内部 SQL 数据库。 所以，你不能只使用 SQL 来查询它。
相反，Intuit 提供了基于 XML 的请求/响应功能，使您可以将 XML 请求发送到 QuickBooks 并获取 XML 响应。 它相当全面，涵盖了您可以在 GUI 中执行的大部分（但不是全部）操作。
要从另一台计算机与 QuickBooks 通信，您需要使用 RDS、Web 连接器，或者自己构建一些东西。 RDS 是一场安全噩梦，并不是真正用于集成 Web 应用程序。 Web 连接器正是您正在寻找的东西，也是您应该研究的东西。 Web 连接器的全部目的是将一台计算机上的 QuickBooks 与另一台计算机上的 Web 应用程序链接起来。 它使用 XML 和 SOAP 请求的组合来完成其工作。
QuickBooks 集成并不简单。 由于多种原因，实现某些事情可能会很复杂：大量外键、依赖关系、税收规则、挑剔的 XML 解析器、奇怪的字段长度等。但是，它绝对是可行的，而且您不需要会计师或确实拥有超强的 QuickBooks 背景，能够完成大多数事情。
我的特定于 PHP 的建议：
First, some links and terms for you...
QuickBooks SDK - This has all of the QuickBooks related documentation for integrating with other applications, whether that be by COM, SOAP, RPC requests, etc. etc. etc. It also has several very useful testing and validation tools. You're going to want to go download this no matter what route you choose.
http://developer.intuit.com/
QuickBooks OSR - This is the main reference point which shows you all of the requests you can send to QuickBooks, and the responses that QuickBooks sends back.
https://developer.intuit.com/qbsdk-current/Common/newOSR/index.htmlUpdated link: https://developer-static.intuit.com/qbSDK-current/Common/newOSR/index.html
QuickBooks PHP Framework - This is a framework designed specifically for PHP to communicate with QuickBooks. Disclaimer: I'm the author. It's designed to work with the QuickBooks Web Connector (more on that later):
https://idnforums.intuit.com/messageview.aspx?catid=56&threadid=9164Updated link: https://github.com/consolibyte/quickbooks-php
QuickBooks Integration Wiki - Wiki that talks about QuickBooks integration. Disclaimer: I'm the author. Here:
http://consolibyte.com/wiki/doku.php/quickbooks
QODBC - This is a wrapper around the QuickBooks SDK XML requests which provides an ODBC driver to QuickBooks data. It's a commercial product, but supposedly works pretty darn well. I hear there are some concerns with performance sometimes, so I would try it before you commit to it.
AccessBooks - This might be another alternative for you, it provides a way to mirror QuickBooks data to an SQL database. It's a commercial product, and I've heard mixed things about how well it actually works.
QuickBooks Web Connector - This provides a way to use SOAP and qbXML to send requests to QuickBooks and receive responses from QuickBooks. This is what you should be using to link your Apache/PHP set up with QuickBooks. It is the only Intuit-supported method of linking websites to QuickBooks.
QBFC - This is the Windows COM/DCOM way to communicate with QuickBooks. Not applicable to you since you're on a separate computer and using Linux.
RDS - Remote Data Sharing for QuickBooks. This is not applicable to you as it's mean for use only within a LAN.
IDN Forums - The Intuit Developer Forums are a great place to post for help:
http://idnforums.intuit.com/Updated link: https://intuitpartnerplatform.lc.intuit.com
Now some additional thoughts/information:
Keep in mind that although QuickBooks is backed by an SQL database, it does not allow you any direct access to its internal SQL database. So, you can't just query it using SQL.
Instead, Intuit provides an XML-based request/response thing that lets you send XML requests to QuickBooks and get back XML responses. It's pretty comprehensive and covers most (but not all) of the things you can do in the GUI.
To talk to QuickBooks from another machine, you need to use RDS, the Web Connector, or build something yourself. RDS is a security nightmare and not really meant for integrating web applications. The Web Connector is exactly what you're looking for, and what you should be looking into. The entire point of the Web Connector is to link QuickBooks on one machine with a web application on another. It uses a combo of XML and SOAP requests to get its work done.
QuickBooks integration is not simple. It can be complex to implement certain things for a number of reasons: lots of foreign keys, dependencies, tax rules, picky XML parser, strange field lengths, etc. However, it's definitely do-able, and you don't need to be an accountant or really have a super-strong QuickBooks background to be able to do most things.
My PHP-specific recommendations: