We are very excited about one of the new features in QuickBooks® Enterprise 2011! We haven’t really seen anything written about it yet so we thought we might as well take the opportunity to do so. The Intuit Press Release “ QuickBooks® 2011 Saves Small Businesses Time in the Back Office” mentions most of the new additions to QuickBooks® Enterprise, however, one thing is not mentioned, the new Open DataBase Connection (ODBC) Driver.
This is not a replacement to the QODBC driver that has been available for some time now from FLEXquarters. It is an additional tool that has been made available by the developers at Intuit. This tool provides direct access to the QuickBooks® database via table views. Alembic has been working with the Intuit development team since early in the development stages of this great tool and we have found it to be a very nice addition. This driver provides strictly read only access to the database, unlike the advanced driver available by FLEXquarters which provides both read and write access. However, when it comes to custom reporting read access is all we need and this driver is FAST! Unlike the QODBC driver that uses the QuickBooks® SDK to build a secondary database to work from, this new driver works directly with the data. We were able to develop a report that pulled thousands of records in just a few seconds.
In addition to being fast we also have access to data that is unavailable via the QODBC driver, due to limitations imposed by the SDK. An example of this improved access is that we can now report on budget information contained within the QuickBooks® file. In the past if we wanted to report on budget data we had to export the info into another program, such as MS Access, pull additional data in, and then develop our report off of that. It was a very tedious and time consuming process. With this new tool this will no longer be an issue!
Since this is a new tool it does take a little bit of getting used to. You must create a reporting user within QuickBooks®, the driver is a File DSN as opposed to a System DSN, and the QuickBooks® file must be opened when accessing the data. We were fortunate to work directly with the development team at Intuit, learning first-hand how tables are related to one another and what relationships are needed to get to the data correctly. It was a great jump start for us.
We look forward to using this great new addition to QuickBooks® Enterprise 2011, which will be available for purchase September 27, 2010. Contact us today to learn how you can purchase this #1 Rated financial solution.