2022

Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Overview 

The 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 (*.qbwQuickBooksw). The connector will allow you 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. The Furthermore, the connector uses the qb XML 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.


Prerequisites

To establish a connection to QuickBooks desktop, via DBSync's QuickBooks desktop connector, user has to do the followingmust:

  • Have a valid license to DBSync QuickBooks desktop connector, username and password to connect to DBSync iPaaS platform.
  • Have QuickBooks Web-Connector should be configured to connect to DBSync to read from, and write to, QuickBooks desktop. you can download the web connector from Intuit marketplace by click clicking on the link and steps .  Steps to configure your web connector are followed in the latter section.
  • you must have Have QuickBooks administrative rights.

Connector Configurations

The table below table represent represents parameters required for opening the connection to QuickBooks file.

PropertyDescriptionRequired
QuickBooks File

The path of the QuickBooks file where it is hosted.

The file path can be obtained in the following way

  1. Open the QuickBooks file
  2. press the function F2 key from your keyboard
  3. you will find the QuickBooks file path


yesYes
QuickBooks Version

you can choose the relevant version of your QuickBooks Desktop from available values.

yesYes
Process Name

The process name is the same process name in DBSync which that is trying to access the QuickBooks file and the . The naming convention is as follows:

"processdefinition_processname.xml".

yesYes


Steps to configure Web-Connector:

  1. Click on Download Web Connector to download the .qwc file. Open this downloaded file with QuickBooks Web Connector.
  2. Click on OK button on  on the Authorization screen.
  3. Select the option 'Yes, always; allow access even if QuickBooks is not running' and . Then, click on continue.
  4. Click on Done to confirm Access.
  5. The DBSync integration process will be added to your Quickbooks QuickBooks Web-Connector. Once the process is added to the web-connector, add the DBSync account password in the highlighted section of the Web-Connector.
  6. This completes the process of configuring DBSync for integration with your QuickBooks company file.


Uses Of Quickbooks QuickBooks Desktop Connector

The following are the few uses you reap while using our QuickBooks Desktop connector

  1. Eliminate manual data entry by connecting QuickBooks to other systems which that are supported by usDBSync.
  2. Automate business process to increase efficiency across departments by reducing data reconciliation reconciliation. 
  3. Make your customer, item, vendor, invoice records as zero error prone as possible while moving in, and out of, QuickBooks.


Supported Versions

  • QuickBooks Desktop 2007 onwards.
  • Pro, Premier and Enterprise Editions.
  • US, Canada, and the UK.

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: Does Can this connector be used for Bi-Directional sync?

A: Yes. Furthermore, and if you also have the control to so choose, you can also make it uni-directional if you choose.

Q: Is this connector available with, On-Demand or On-Premise Version, Versions?

A: This profile is available with both On-Demand and On-premise VersionVersions.

Q: How Frequent Frequently can we perform Sync?

A: Sync can be performed every 5 minutes.