Forum Discussion

Veritas's avatar
Veritas
New Member
9 years ago

Quickbooks

I want to develope a dashboard of financial statement data pulled from Quickbooks desktop.  What is the best way to pull in the data?  I would welcome guidance from any other users who have developed...
Need Help
BetterIdeaGroup's avatar
BetterIdeaGroup
Helper II
9 years ago

You can use the ODBC features in Enterprise. Not perfect by a long shot but it is a connection to give you some raw data if you want to fight thru getting the views connected (not obvious how to do it but possible). I have found the QODBC connector fails so if you want to get into reporting between PowerBi and QuickBook enterprise your best option is a 3rd party product called QQube  which extracts the QB data into a local sybase Database. The database model is optomized for reporting so really is PERFECT for using with PowerBi.  It  comes with PowerBi Templates (Desktop files) that cover nearly every area you would want to report on.

 

I am certified on the product so do let me know if you need help getting QQube or getting it working.

 

Ernest

 

Happyman's avatar
Happyman
New Member
8 years ago

Hi Ernest, do you have an email to write you about help on connect QQube to BI? or do you have a website where I can use the professional services for that service? 

Thanks

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      BetterIdeaGroup question regarding QQube.  Can I augment the data model of a template PowerPivot 2013 file from QQube with some of my own data / other queries?  Or am I confined to the data model as is?

      • BetterIdeaGroup's avatar
        BetterIdeaGroup
        Helper II
        8 years ago
        Absolutely ! A huge value of the QQUBE product is getting the information OUT of QuickBooks and into a structure for just that kind of work to be able to be done. The engine is SQL Anywhere and readonly userid/passwords get you to the tables/views. The Templates are a great start for basic users but as a developer myself I usually start with just pulling in the tables I need that make sense and then augment with alternate sources as needed in the use case.