且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

通过odbc用php连接到quickbooks数据库?

更新时间:2023-02-04 21:26:12

第三个选项可能对您有用.

The third option might work for you.

选项1-QODBC::如果您正在寻找简单性,如上所述的Qodbc是实现此目的的主要产品,而且确实要花钱.

Option 1 - QODBC: If you're looking for simplicity, Qodbc as mentioned above is the main product that does it, and it does cost money.

选项2-Quickbooks SDK::如果可以使用SDK并使用其XML结构,可以在开发人员网络上找到一些不错的资源.该SDK的帐户是免费的,您可以很轻松地使用它.

Option 2 - Quickbooks SDK: If you're okay working through the SDK and using their XML structures, you can find some great resources on the developer network. Accounts are free for the SDK and you can work your way through it fairly easily.

这归结为一件事,如果您想要免费,则可能无法按自己的方式去做..QODBC在我上次检查时定价合理.

This boils down to one thing, if you want it free, you might not be able to get it your way.. QODBC is reasonably priced the last time I checked.

这两种方法都需要注意的一件事-确保要在Quickbooks中写入数据的表可被SDK和QODBC使用.

The one thing that is important to be aware of with either approach -- ensure the tables you wish to write data into in Quickbooks are available by the SDK and QODBC.

随着Quickbooks越来越老,对某些表的访问已消失.例如,由于它与Intuit的薪资服务竞争,因此无法直接直接写入薪资扣除表.

As Quickbooks has gotten older, access to some tables have disappeared. For example, it's not possible to write directly to the payroll deductions table directly as it competes with Intuit's Payroll Service.

选项3-直接SQL操作: Intuit在其SQL数据中加密其数据,使其无法直接访问.

Option 3 - Direct SQL manipulation: Intuit encrypts their data in their SQL data making it unavailable for direct access.

选项4-Quickbooks Web连接器 SOAP包装器,它与Quickbooks一起位于计算机上并与您进行交互.也免费.

Option 4 - Quickbooks Web Connector SOAP wrapper that sits on the computer with Quickbooks and interacts with it for you. Also free.

祝你好运!