We are a QB 15 Enterprise Desktop environment and want to do sql queries against the QB company file. Intuit provides a customized ODBC which allows read access to the company file via apps like Access and Excel - but I was wanting to pull data out, and potentially into a Base database. Anyone done this? And is it a reasonable option?
The QODBC driver will allow Base to connect but all that it provides is read access to its’ tables (unless you get the full version). You can do queries and reports, but that is about all.
Since Base only allows one connection at a time, there is no way to store any extracted data into another database. So reading a QB database and writing that information to a another database is not currently possible with Base.
As an afterthought, it may be possible to use an intermediate such as TOra or SQL Workbench (and possibly others) to transfer data between databases. I have done this with SQL Workbench connecting two different types of DB’s and transferring data. Don’t know much about TOra - just some light reading.
If this answers your question please click on the (upper left area of answer).