QODBC Troubles
While working on a Proof of Concept for some integration between QB Enterprise 7.0 and MOSS 07 I've been monkeying around with the QODBC drivers. Enterprise comes with QODBC and so it ought to let me in there to look at tables, views and stored procedures. I took to doing just that, and each time I would load the ODBC driver and try to connect with like SQL Query analyzer, the whole SQL server would crash.
So now I went through the trouble of updating to R7 of QuickBooks Enterprise 7 and the latest QODBC Driver. Initially all looks well but I'll need to put it under some stress to see how it really performs.
So I just ran a simple select statement against the Customers table (129) rows and it took 6 minutes 21 seconds. That's not exactly blazing fast. I'll see if I can't make it a bit better.
The goal out of this is to create some Business Data Catalog tools that connect to QuickBooks data and allow for us to leverage that investment. We are looking to do this for several customers, especially those that, for example, may have employees don't need to interact with the QB data but rather just need to see a customers' balance or address and contact info.
So, on the second pass it only took 2 minutes 48 seconds. That is still unacceptable. I'll just try loading all that data into SQL and querying against that…
Thanks to some resources at Intuit, I was able to get some guidance and what not to get this far…be sure to consult this site: http://www.qdeveloper.com.au/
-bill