ODBC Connextion to Quickbooks

[alec1982]

hi all,

I have installed and configured the quickbooks connection within Qlik sense server. I am successfully connected when testing from ODBC admin side. I am also able to successfully create the connection on Qlik sense side with no errors. the account I use to connect to quickbooks have admin rights on quickbooks.

the issue I have is no database or owner shows to select from. any idea what could be wrong?

[alec1982]

anyone used quickbooks connections?

[NadiaB]

Hi @alec1982 

I don't have a quickbooks connection to test against but something you could try:

1. Verify that the user has full privileges to access to the DB.

2. quickbooks is SQL Standard, maybe an option instead of using the data preview, you could try to write a query to the table in the "Data Load editor" instead.

I found this documentation that has a list of tables that quickbooks has (not sure if that would be the one for the product you are using it seems there are different versions/capabilities available) https://http-download.intuit.com/http.intuit/CMO/qbes/resources/pdfs/CustomReportingODBCImplementati...

I also found this that is an example of using quickbooks with rest connector 

https://www.cdata.com/kb/tech/quickbooks-connect-qlikcloud.rst

Hope it helps!