OpenSync 3.0

OpenSync 3.0

4.67 out of 5
(6 customer reviews)

$299.00–$499.00

OpenSync is a server based QuickBooks integration designed to perform a QuickBooks sync to and from an external database including Microsoft Access, MS SQL Server, MySQL, Microsoft Azure, or Oracle.  This provides a platform for building highly scalable applications that integrate with QuickBooks.  Applications for this replication engine include web site integration, custom report generation and publishing, time tracking applications and Microsoft SharePoint integration.

Click here for a brief video demonstration.

Click here for downloadable help documentation.

Download OpenSync version 2.x here

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).

Contact us regarding embedded licensing programs in order to bundle OpenSync with your application.

Login or register to download a 30-day free trial of OpenSync
Features

  • New to 3.0: Database schema now includes a sequence number field for all line item tables
  • New to 3.0: Database schema now includes a field call UserData which is preserved across update operations
  • New to 3.0: The configuration program now preserves the state of the tree view.
  • New to 3.0: The location of all configuration data has been changed to more accessible location
  • New to 3.0: Database schema has been modified to support fully typed columns and primary keys
  • Full QuickBooks 2018 Support
  • Bi-directional QuickBooks Synchronization
  • Automated Memorized Report Extraction to Database Tables
  • Synchronize with MS Access, Microsoft SQLServer, MySQL, and Oracle databases
  • Sync multiple QuickBooks files to individual databases
  • Automated background operation
  • Robust diagnostics and support services
  • Easy to use wizard interface for configuration
  • Integrated database browser
  • An effortless QODBC alternative
  • Import transactions into QuickBooks with ease
  • Now with Microsoft Azure support!   |   See details


Clear selection
SKU: n/a. Category: .

Product Description

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.

Release Notes

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.

Additional Information

Versions

OpenSync 3.0 License, OpenSync 2.0 to 3.0 Upgrade

FAQ

Click here to go to the full FAQ page.

Why can't I seem to get any records in my database to sync back to QuickBooks?
99.5% of the time it’s because you didn’t set the STATUS column to ADD or UPDATE. The former is for creating new records in QuickBooks the latter for modifying existing.
Can OpenSync run without having someone logged on to the server?
Yes, by configuring the OpenSync service to run at system startup there is no need to have a user logged onto the server.
Does OpenSync support international versions of QuickBooks?
Yes, OpenSync support the Canadian, UK, and Australian versions of QuickBooks.
Can OpenSync connect to a remote database server?
Yes. OpenSync only requires an ODBC connection to the database server.
I keep getting 'Data source name not found and no default driver specified' when I try to connect to my database.
This indicates that you do not have the ODBC driver for your database server installed.
Can my database server run on a non-Windows based machine?
Yes, as long as you can establish an ODBC connection to the database server OpenSync will work with it.
Is there help documentation I can view?
Absolutely. A help doc is packaged with the application however you can also view an updated PDF of it here
Is OpenSync a one time cost?
Absolutely. OpenSync is not a service. It is a standalone application that you install on any PC with a QuickBooks installation and let it sync away.
Does this have to run on a server?
Nope. You can install OpenSync on any PC with a QuickBooks installation. It doesn’t require any advanced technical know-how beyond the ability to log into a SQL database server – assuming you’re not using MS Access.

How does it work?
In short, it will create a database in any of the supported formats, flush with every field and tables the API currently provides access to, and then export any and all data you specify to it. Then, on an interval you designate, it will synchronize with QuickBooks to ensure all data is current. In the event that you add or modify data in the database, that information in QuickBooks will be created or updated respectively. It’s just that simple.

4.67 out of 5

6 reviews for OpenSync 3.0

Add Review  If you leave a review we will send you a 5% off coupon. We love feedback.


  1. gurtejsingh
    4 out of 5

    (verified owner) – :

    Great product.. only problem I faced to make filled for sync with qb

  2. jeff.clements
    5 out of 5

    (verified owner) – :

    Great product. Easy to configure. Exported to a SQL database for reporting. My only complaint is that it can be very difficult determining which fields are used to relate the tables.

  3. lars
    4 out of 5

    (verified owner) – :

    Does what it needs to. Would be four stars if transactions synced billable status without a repopulation.

  4. K Readle
    5 out of 5

    – :

    What a great tool. Solved our issues and was easy to setup.

  5. edgar
    5 out of 5

    – :

    amazing wish i found this earlier

  6. BTH
    5 out of 5

    (verified owner) – :

    OpenSync works great for us. We tried other ODBC tools and found they were very slow for a large QB data file

Add a review

Related Products

Copyright © 2013 Synergration Inc