QuickBooks Plugin

The QuickBooks plugin allows AppSynergy to easily read and write data in QuickBooks.

This means you can use AppSynergy to build custom business systems that easily pull key data from QuickBooks for integration purposes. Importantly, changes to that data can easily be pushed back to QuickBooks in real time.

Typical use cases include pushing invoices and purchase orders that have been created in AppSynergy over to QuickBooks to eliminate the double entry of data.

All of your QuickBooks data can be integrated:

Sales Orders
Purchase Orders
Invoices
AR
AP
Vendors
etc. etc.

Features

Live Data. The plugin enables the reading and writing of live data. An update to a federated table connected to QuickBooks means the data in QuickBooks is changed immediately. Difficult syncing issues are therefore largely eliminated at the source.
SQL Interface. The plugin translates MariaDB SQL to the appropriate underlying API calls to the remote system. This means you can work (and think) in SQL without worrying about as many of the implementation details.
Caching. You can enable query caching to improve the performance of a slow remote system. The cache can be built and refreshed automatically at periodic intervals. In addition you can refresh select portions of the cache manually with a single line of PL/SQL code.
Over-The-Top Role Based Security. If the remote system has limited security features you can apply more granular security over-the-top using AppSynergy Security Roles. Our Security Roles enable control of select/insert/update/delete right down to the table/column/record level. This enables different users assigned to different roles to have differing access permissions even if the remote system doesn't provide such capability.

Specifications

Full read/write capability limited only by the capabilities and/or permissions of the remote system.
Full-featured and consistent SQL access to all supported data end points.
Codeless integration for reporting and dashboards.
Codeless integration for building applications that update QuickBooks data.
Full support for QuickBooks metadata discovery and automatic datatype mapping.
Includes enterprise-class security features such as TLS/SSL data encryption for all client-server communications.