Bi-directional QuickBooks Sync Made Easy
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 perform a QuickBooks sync with multiple company files with multiple external Access, SQL Server, MySQL, Oracle, and now Microsoft Azure databases. Changes made in QuickBooks are automatically synchronized to the external database and changes marked in the database are automatically synchronized 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, Oracle, or Microsoft Azure 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.
Click here for a brief video demonstration.
If you want to get a feel for the database that OpenSync creates and maintains for you, click here to download a populated sample database (in Microsoft Access .MDB format).
Note: If you’re having issues syncing data back to QuickBooks, make sure the STATUS column of your parent record is set to ADD or UPDATE.