We often get asked what is the best Synergration solution for integrating an existing application with desktop versions of QuickBooks. In the end it really comes down to your technical wherewithal and speed at which you’re looking to integrate.
OpenSync – our QuickBooks database replication engine can handle most of the heavy lifting for you, expediting your development effort and requiring minimal technical expertise. What it will do is, within mere minutes, automatically create a disparate database (MS Access, MySQL, SQL Server, or Oracle) or set of tables within an existing database, and populate that data with any or all QuickBooks data you require. From this external database you can query, add, and modify the data, with any changes automatically replicated in QuickBooks. OpenSync can be set up to run in an automated fashion, in the background, on a designated interval, so that what you see in QuickBooks is sufficiently in line with what’s in your database. Generally, when working against a SQL based database, you only need to install OpenSync on a single PC with a QuickBooks installation.
The downside to OpenSync is that it introduces an additional layer into your existing application architecture. You’ll be tasked with writing queries that move data between your existing application and the OpenSync database. Also, if this is an application you wish to distribute, it will require purchasing a license for each installation. We do offer reseller discounts however a cost to consider nonetheless.
Alternatively, CoreObjX, our flagship development library alleviates all those downsides. CoreObjX is an ActiveX wrapper for the tedious QuickBooks XML-based API so instead of throwing long XML strings back and forth you can work with a strongly-typed set of objects that allows you to create transactions and query lists with a few lines of code. Literally.
Compatible with any COM-compatible development environment, CoreObjX will allow you to directly integrate your existing application with QuickBooks alleviating the need for a proxy layer like OpenSync. It also can be distributed royalty-free, so there’s no need to call us for additional licenses in the event you roll your app out to a few thousand customers.
In the end though, as a programming library, it will obviously require some coding chops so if your college curriculum stopped at SQL statements, OpenSync may be the better play.
Both solutions are available as 30-day, fully-functional free trials in addition to a 30-day money back guarantee so we recommend you take one or both for a test-spin. If you have any questions, don’t hesitate to drop us a line on the forums or via our contact form.