DBSync's QuickBooks Connector provides an easy way to perform integration, data extraction or data loading into QuickBooks Desktop Accounting software. The connector connects directly to QuickBooks company data file (*.QuickBooksw). It allows a user to query, add, modify and delete various types of records including customers, Items, Vendors, Invoices, Sales orders, Purchase orders and much more. Furthermore, the connector uses the QuickBooks XML to move data in, and out of, QuickBooks desktop. Integrating with QuickBooks desktop consists of SOAP web service calls using an XML request/response made over an HTTPS connection.
To establish a connection to QuickBooks desktop, via DBSync's QuickBooks desktop connector, user must:
The table below represents parameters required for opening the connection to QuickBooks file.
The path of the QuickBooks file where it is hosted.
The file path can be obtained in the following way
you can choose the relevant version of your QuickBooks Desktop from available values.
The process name is the same process name in DBSync that is trying to access the QuickBooks file. The naming convention is as follows:
Steps to configure Web-Connector:
Uses Of QuickBooks Desktop Connector
Notes - Please note that for all QuickBooks desktop software, integration is supported only for Windows platform and not MAC or other operating systems.
Frequently Asked Questions
Q: Can I get a trial of DBSync?
A: DBSync is available free for 30 days trial after going through the Signup process.
Q: Can this connector be used for Bi-Directional sync?
A: Yes. Furthermore, if you so choose, you can also make it uni-directional.
Q: Is this connector available with, On-Demand or On-Premise, Versions?
A: This profile is available with both Versions.
Q: How Frequently can we perform Sync?
A: Sync can be performed every 5 minutes.