How to connect QB data to the SQL database ? | Discussions

Expand all | Collapse all

How to connect QB data to the SQL database ?

  • 1.  How to connect QB data to the SQL database ?

    Posted 05-19-2015 12:20
    Your questionPlease phrase as a question with at least 15 characters and 3 words.156 Add more details (optional)
    • hello everyone, I am trying to connect SQL server dabase using SSIS and C# code to the Quickbase tables. If anyone have solution for this please reply or mail me ganesh.sanap@ellicium.com
    • Thanks In advance.


  • 2.  RE: How to connect QB data to the SQL database ?

    Posted 05-19-2015 15:16
    I use QuNect (www.qunect.com) which creates an ODBC connection to QuickBase


  • 3.  RE: How to connect QB data to the SQL database ?

    Posted 05-21-2015 04:12
    Thanks dwhawe QuNect is not open source or free. Is their any other free connector ? or if you have code for this please      help me.


  • 4.  RE: How to connect QB data to the SQL database ?

    Posted 03-08-2017 23:40
    Have either of you used the API to extract table data from QuickBase?  I need to pull data to use in PowerBI.  I am getting data from using the API but it is not consumable by PowerBI yet (format of the XML being returned).


  • 5.  RE: How to connect QB data to the SQL database ?

    Posted 04-20-2017 19:06
    Stephen... you would have to parse it in a format that PowerBI can can consume. I take the xml and convert it to json. Not sure what format PowerBI takes.


  • 6.  RE: How to connect QB data to the SQL database ?

    Posted 05-17-2018 19:06
    I know that this is a year old, but you can use a web data source in Power Bi and then just run an API query to download a .CSV file. Works for me in Power Bi pretty well.