Discussions

 View Only
Expand all | Collapse all

Export Quickbase data and use as a source for other BI tools

  • 1.  Export Quickbase data and use as a source for other BI tools

    Posted 10-27-2014 17:58

    I Like to Export Quickbase data and load it to Qlikview Reports. Let me know if any suggestions!

    Thanks!



  • 2.  RE: Export Quickbase data and use as a source for other BI tools

    Posted 10-28-2014 12:48
    Typically, most systems are able to use Excel or at least a csv file to import and export data.  I suggest you start there.


  • 3.  RE: Export Quickbase data and use as a source for other BI tools

    Posted 10-28-2014 13:46
    Do you want to live BI reports or ones that are done on demand by uploading data files into it like CSV.

    If you want live data, look into the Quickbase API SDKs available.  I am currently working on a BI dashboard on my own domain and I have achieved live data using the PHP SDK.


  • 4.  RE: Export Quickbase data and use as a source for other BI tools

    Posted 11-12-2014 21:29
    B- do you know any BI tools that support Quickbase API for reporting (without having to build it ourselves?) Thanks!!


  • 5.  RE: Export Quickbase data and use as a source for other BI tools

    Posted 11-12-2014 21:32
    I don't, sorry.  I know there are some tools out their like Zapier and itDuzzit they may offer some help integrating data.  But I think your best bet if you dont want to build a custom system is to follow Mark's advice above and go the CSV/Excel import route as most BI software accepts these formats.  

    Maybe create a set of reports to export just for this purpose.


  • 6.  RE: Export Quickbase data and use as a source for other BI tools

    Posted 11-12-2014 21:45
    Thanks for the quick response. I plan to check out Elastic Intelligence as Intuit purchased it last year and it says it can be a SaaS link for these types of reporting needs. If anyone has integrated with that, I'd be interested in hearing about it!


  • 7.  RE: Export Quickbase data and use as a source for other BI tools

    Posted 11-12-2014 21:50
    I can't seem to find EI since Intuit got involved. They became ConnectionCloud, but that site goes to invalid Intuit pages. Not sure if anything will come out of it, as I heard Intuit also acquired itDuzzit too and I haven't seen any new feature releases with these "connectors" or similar.

    I also checked Intuit Labs website and nothing there either.

    What happens to companies/tech when acquired by Intuit?


  • 8.  RE: Export Quickbase data and use as a source for other BI tools

    Posted 11-12-2014 21:56
    Good question!! I'm having the same issues trying to find the actual tools after the press release. What QB really needs is a connection to fully functional reporting tools, as those included are definitely lacking in native.

    One to look out for: Domo - they say they can integrate with QB API - so fingers crossed!


  • 9.  RE: Export Quickbase data and use as a source for other BI tools

    Posted 11-29-2017 01:24
    Did you ever try DOMO?


  • 10.  RE: Export Quickbase data and use as a source for other BI tools

    Posted 11-13-2014 16:04
    You can use QuNect as the connector between Quickbase and Qilkview.....via ODBC...very easy to set-up and use....Qilkview may allow you to schedule an auto refresh of your Quickbase data....I know Tableau does....


  • 11.  RE: Export Quickbase data and use as a source for other BI tools

    Posted 11-18-2014 16:20
    I just noticed this one called Easy Insight by Quickbase partner Advantage Integrated Solutions - looks great - plus free trial and inexpensive. Has anyone tried it out?


  • 12.  RE: Export Quickbase data and use as a source for other BI tools

    Posted 10-14-2019 12:33
    Palanee,

    We had the same problem and have built a product to get data out of Quick Base into a SQL compliant DB.  The tool is called Paasporter.

    www.paasporter.com

    It gives you a real SQL DB which Business Intelligence packages can natively connect to.  Your Quick Base data is now a SQL source to be used with all the other data in the company like marketing or ecommerce DBs.

    Let me know if I can help.

    ------------------------------
    Don Larson
    ------------------------------