The InterWeave integration is designed to streamline business processes by enabling seamless data exchange between QuickBooks and Salesforce. To understand how this works, let’s start with the basics—who FlexQuarters is and what QODBC does.
Who is FlexQuarters?
FLEXquarters.com Limited is an Intuit Partner that develops tools to automate connections and integrations with QuickBooks. They created the QODBC Driver, which is integrated (OEM’d) into your QuickBooks Desktop application in a “Read-Only” mode. InterWeave upgrades this license to “Read/Write,” allowing it to both read and create records in QuickBooks, enabling two-way communication between Salesforce and QuickBooks.
What is QODBC?
QODBC is an ODBC driver (DLL) for QuickBooks file formats. QuickBooks uses a proprietary database format, and the QODBC driver allows any ODBC-compliant application to read and write data within these QuickBooks files, just like any other ODBC-enabled database.
The driver works by converting SQL commands from applications into navigational XML commands, which communicate with the QuickBooks DBMS and return the relevant data. It’s important to note that QuickBooks is a flat-file database, and this driver does not convert it into a relational database. Instead, QODBC serves as a “wrapper” around the Intuit SDK, enabling developers to access QuickBooks data using standard database tools, thereby speeding up development time.