Has anyone connected the R package to QuickBooks? I know there is an ODBC driver than can be bought. Just wondering if anyone has already gone down this road.
Any insight will be much appreciated!
~ Brock
+3
A:
Hi Brock,
Google QODBC. It allows you to access Quickbooks via ODBC.
However, it works through creating an interface to XML files. For large QB files it can be painfully slow if you don't properly use indices and limit the data to exactly what is necessary. It's also very quirky. Lastly, not all tables are exposed (Quickbooks fault, not theirs) such as some payroll tables.
What I often ended up doing for large QB files is exporting the data at night via the QODBC driver into a sql database so that ad hoc analysis could be run quickly without compromising the performance for QB users during the day.
Good luck!
Robert
2010-04-26 00:08:41
Thanks for your help. I knew QODBC was out there, but wondering about performance. I definitely will throw it into a database before hitting it with R. Much appreciated.
Btibert3
2010-04-27 22:40:23