Forum Discussion

    • MikeKarp's avatar
      MikeKarp
      Qrew Member
      6 years ago
      It's really not complicated at all. 

      You really have three options:
      (1) Move the data into a SQL-based database, and then connect Tableau or any BI tool to that database.  There are data services (typically called "ETL") that will do this for you.  A good example is Stitch Data (example: https://www.stitchdata.com/integrations/quick-base/) depending on your volume that could even be free.  I'd recommend if you're not looking to spend a bunch of money, to either use Google Cloud's bigquery or Heroku's postgres as your database. 

      (2) Use an ODBC driver for Quickbase (example: https://www.qunect.com/) - Open Database Connectivity (ODBC) is a tool that can run on your machine or server and lets Quickbase "pretend" to be a database - and then just connect Tableau or other BI tool to that ODBC/translator-created database.

      (3) Use Tableau's Web Data Connector (WDC) framework to connect directly the Quickbase API - this approach is pretty similar to using an ODBC, but its just using less software and is specific to Tableau (example: https://www.quicktab.xyz/)

      Happy to follow up with pros/cons of each if you're still interested.
    • ArchiveUser's avatar
      ArchiveUser
      Qrew Captain
      6 years ago
      Out of curiosity, what makes you say it's not for the faint of heart?  
    • QuickBaseCoachD's avatar
      QuickBaseCoachD
      Qrew Captain
      6 years ago
      It's complicated to set up.  Too complicated for me to invest the time to learn.
  • DebbieTaylor's avatar
    DebbieTaylor
    Qrew Trainee
    7 years ago
    Emma -

    There are a bunch of options (eg quNECT, Amazon RedShift, APIs) for linking Quick Base to Tableau.  What's best depends on a few things:
    • The version of Tableau that you are using
    • How much data is involved
    • What (if any) other data source you are using
    • Whether you need to transform (re-arrange) the data to make the viz' you want
    CloudBase Services can recommend options and integrate the system.  In the end, you will have data automatically flowing from QuickBase into Tableau AND Tableau graphs on your Quick Base dashboards.

    Reach out to CloudBase Services through our website.

    And, thanks, Your Quick Base Coach!

    Debbie
  • SuryaExpert's avatar
    SuryaExpert
    Qrew Assistant Captain
    7 years ago
    Not sure about cloudbase as I haven't used it, but using Qunect, you can create an ODBC connection to QuickBase. Then you can connect to that ODBC connection with Tableau to read the data and generate the reports in Tableau. Another way, is to export the data from QuickBase to CSV files and then use them as your data source in Tableau.
  • DonLarson's avatar
    DonLarson
    Qrew Elite
    6 years ago
    We tackled this issue as well and have started Paasporter to make it easy for anybody else.   The secret is to extract Quick Base data to a real SQL DB.  Now Tableau or any other SQL compliant took can query, curate, optimize and splice the data to your hearts content.

    It is online at www.paasporter.com  

    Quick Base is king for business process but SQL rules reporting.

    ------------------------------
    Don Larson
    ------------------------------
  • KrunalLathiya's avatar
    KrunalLathiya
    Qrew Member
    5 years ago
    To connect with tableau, I use the Download Tool in Alteryx in combination with the Quickbase HTTP API and I have been trying to get this to work for some time.  Any further instructions that you might have would be super helpful!!

    There is one more solution but I don't know if it is working which is QuNect - which is a third-party ODBC driver for QuickBase.


    ------------------------------
    Krunal Lathiya
    ------------------------------