Now you can Create, Read, Update and Delete QuickBooks Enterprise data from within your AppSynergy applications. Query QuickBooks data from within your AppSynergy applications, perform searches by name, invoice number, etc. Build a custom web or mobile UI.
Create and update Customer data, use drag-n-drop UI widgets, automate processes with stored procedures, etc.
All of your QuickBooks data is instantly available including:
Additional information about the tables available from QuickBooks is available here.
To learn more about integrating AppSynergy with QuickBooks, please complete the following information.
The QuickBooks federated driver has configurable smart caching options that work by storing queried data into a local database on the same server as your federated database. Enabling smart caching creates a persistent local cache database that contains a replica of data retrieved from the remote source. The cache database is small, lightweight, blazing-fast and it can be shared by multiple connections as persistent storage. This powerful caching functionality increases application performance and allows applications to disconnect and continue limited functioning without writing code for additional local storage.
Maintains an automatic local cache of data on all requests.
Each row returned by the query will be inserted or updated as necessary into the corresponding table in the cache database.
With traditional approaches to remote access, performance bottlenecks can spell disaster for applications. Regardless if an application is created for internal use, a commercial project, web, or mobile application, slow performance can rapidly lead to a failed project. Accessing data from any remote source has the potential to create these problems.
The AppSynergy QuickBooks Federated Driver solves these issues by supporting powerful smart caching technology that can greatly improve the performance and dramatically reduce application bottlenecks.
Overcome common issues such as:
Hundreds of Functions
Hundreds of built-in functions for datatype conversion, string manipulation, regex, parsing JSON and XML, etc.
If you need to perform advanced transformations on your QuickBooks data you have access to hundreds of built-in functions PLUS the full power of SQL. Nothing is more powerful.
Our Federated Drivers undergo extensive testing and are certified to be compatible.