OpenSync is a server based product designed to sync data between QuickBooks and an external database including Microsoft Access, MS SQL Server, MySQL, or Oracle. This provides a platform for building highly scalable applications that integrate with QuickBooks. Applications for this replication engine include web site inetgration, custom report generation and publishing, time tracking applications and Microsoft SharePoint integration.
With the OpenSync QuickBooks sync solution, you can avoid the overhead of learning the QuickBooks API and use standard database tools to read and update QuickBooks data. Performance bottlenecks inherent in the QuickBooks QODBC driver and the QuickBooks Web Connector are eliminated since the sync technology enables you to run your application against a true database server. Forget about import and export tools, OpenSync provides near real time database synchronization with QuickBooks.
It also provides the ability to synchronize multiple QuickBooks company files with multiple external Access, SQL Server, MySQL and Oracle databases. Changes made in QuickBooks are automatically replicated to the external database and changes marked in the database are automatically posted back to QuickBooks. In addition, memorized reports can be scheduled for automatic extraction to database tables.
OpenSync defines three fundamental concepts to support its operation. These are company files, databases, and tasks. Company files are QuickBooks company files and these must be configured within OpenSync. Databases are either Access, SQL Server, MySQL or Oracle databases loaded with the OpenSync schema. A task is the fundamental unit of work. Each task defines a company file, a database, an operation, and scheduling information. OpenSync's sync operation is defined by the configured tasks.
QuickBooks sync tasks can be run either interactively through the OpenSync configuration program or in the background by the OpenSync background processing service. The OpenSync service can be configured to run even without having to log on to the machine and can be controlled through the configuration program.
Please check our FAQ for any questions you may still have regarding OpenSync.
Supported QuickBooks Versions