QuickBooks Desktop Integration with Office 365, SharePoint and 100+

 

Intuit QuickBooks Desktop data can be integrated and synchronized codeless with various other data sources using the Layer2 Cloud Connector via our Quickbooks data providers. Please take a look at our Solution page for supported target systems and applications like various SQL databases, Microsoft Office 365, SharePoint, Exchange, Dynamics, and many others.​​

 

Intuit QuickBooks Integration and Synchronization with Office 365 and SharePoint

 

 

You can connect supported data sources to Quickbooks Desktop without code. To connect to Intuit QuickBooks Desktop, the data entity must be configured as follows in the Layer2 Cloud Connector Connection Manager:

Connection settings in the Layer2 Cloud Connector for Quickbooks Desktop integration


Fig. Example connection configuration to connect to Intuit QuickBooks Desktop customers list via Quickbooks data provider.

QuickBooks Desktop Specific Integration Settings

 

​Please note the following Intuit QuickBooks specific settings.

 

 

  • You will also need to install and configure the Remote Connector for QuickBooks. See the Remote Connector website for more instructions for how to configure this. Make sure this is running prior to testing the connection to QuickBooks from the Cloud Connector.
  • Choose the “QuickBooks” as Data Provider for your data entity (source and / or destination).
  • When you first connect, there will be a dialog in QuickBooks asking you to authorize the application. Once this is authorized, you will be able to execute commands to QuickBooks.
  • Follow the vendor instructions for setting up the connection string, for example:URL=http://myHost:2080; User=myUser; Password=myPassword;
  • You can make use of all SQL queries. If you want to see all available tables and views, use this following selects:

    SELECT * FROM sys_tables
    SELECT * FROM sys_views
  • Please make sure to define an appropriate primary key.
  • The Layer2 Cloud Connector only supports reading from QuickBooks Desktop. Write is not supported at this time.
  • You can map your data query fields to specific external fields in the Layer2 Cloud Connector. Please take care about data types (simple type conversions are supported).
  • No installation or changes are required with any data entity connected.
  • Data synchronization can be started manually in the Connection Manager, per command line or scheduled in background by the Layer2 Cloud Connector Windows Service. Only data changes are processed (no delete / bulk import).
  • No programming required for setup a connection and sync.
  • No need to open your local network for access from outside.

QuickBooks Desktop Integration - Known Issues and Workarounds

  • Both the ADO .NET and ODBC provider's write functions do not work with the Cloud Connector at this time. QuickBooks Desktop is supported as read-only.
  • If you have connection errors, make sure the Remote Connector is running and that your company file is open in a QuickBooks instance being run as "administrator".
  • You can either close QuickBooks after each synchronization or make sure that your company file is constantly open in multi-user mode. If you do not follow this requirement, the next synchronization might fail with the following error: "QuickBooks cannot currently be accessed."
  • If you want to access QuickBooks from a different machine, you have to run the Remote Connector on the QuickBooks system. Make sure the port is opened.

Step-by-Step Intros For Codeless QuickBooks Desktop Data Integration And Synchronization

 

Just some ideas what to connect next with to QuickBooks queries:

 

OAuthClientID=<your_client_id>;
OAuthClientSecret=<your_client_secret>;
InitiateOAuth=GETANDREFRESH;

 

Select Statement:

 

SELECT * FROM Messages WHERE ChannelID=’CBZVAAE6L’ AND SearchTerm Like ‘’;

 

You can get all available tables with:  

 

SELECT * FROM sys_tables;

 

You can get all available views with:  


SELECT * FROM sys_views;

Find related solutions here.

Learn more about similar solutions for data migration, backup, integration, and synchronization by vendor and topic.

Ready to go next steps?

Icon for Product Regsitration - Layer2 leading solutions

Register for free download.

Keep your Quickbooks Desktop in sync. Download and try the Layer2 Cloud Connector today.

Contact Us Icon for Layer2 leading solutions

Questions?

We are here to help. Drop us a short line with your enquiry using our contact form.