from my research it looks like there are basically 3 options.
1: Using COM
2: Using A Webservice and the web connector
3: Using a 3rd party component (and there appears to be quite a few)
Each of these options present a problem for me:
1: I was told I cant use COM
2: This solution seems very hokey to me since I am needing to integrate from a windows service
3: Some of these solutions are rather expensive.
I looks like I am going to have to go the 3rd party route and there are two front runners in my mind:
1: QODBC (http://www.qodbc.com/usa.html)
2: AccessBooks (http://www.synergration.com/AccessBooksUpdater/default.aspx)
My questions, dear reader, are as follows:
1: Which solution (com, web service, which 3rd party) would you use?
2: Why would you choose it over the other options?
3: Is there some other option that I have missed?
C is Cleared and would be from accepting a green match in the Review screen. R is Reconciled and means you have completed a reconciliation that includes that cleared item.
QuickBooks Online has two APIs that allow third party apps to connect, the QuickBooks Online Accounting API, which allows developers to connect to QBO and the QuickBooks Payments API, which allows developers to process credit card payments on an eCommerce site.
Your access to QuickBooks Desktop Payroll Services, Live Support, Online Backup, Online Banking, and other services through QuickBooks Desktop 2019 software will be discontinued after May 31, 2022.
I have decided to go with another product not mentioned above called "QuickBooks ADO.NET Data Provider" it is apparently made by the same folks who make the QuickBooks integrator product
The reasons I chose it...
1) It has a remote access component
You install the remote server, and you can access your QuickBooks data from anywhere on your network
2) The remote access component can run as a service
Nuff said
3) Provides a SQL style interface to the QuickBooks data
4) Does some auto magic caching to speed up the data access
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