Skip to main content
Question

Pipeline to Import data from SQL table to quickbase table

  • September 27, 2023
  • 0 replies
  • 570 views

Hi,

i'm having the hardest time getting data from my sql table (which i've configured and verified in pipelienes) to a quickbase table. 

All the tables have been created in quickbase the same as the tables and field names in sql server. I dont' know what the process is to just map column to column (as we do in SSIS). i was able to finally get odbc set up and i can connect to the sql server, but what are the steps to pull data from sql to quickbase using pipelines. I knw about qunect, we wont allowed to buy it, so i'm looking for a good alternative. people have pointed me to pipelines, but haven't been able to really help me get the data from sql to qb., 



------------------------------
Basil Evans
------------------------------
    This topic has been closed for replies.

    Forum|alt.badge.img+11

    You can install Google Drive or FTP on server. SQL does scheduling services which allow you to export query to CSV file . 

    • You can then use Connected Tables to sync the data . (I have done this for many years)
    • You can use pipeline to parse the CSV file on Google drive (I haven't done this yet)




    ------------------------------
    Prashant Maheshwari
    ------------------------------

    MarceloBenavide
    Forum|alt.badge.img+8

    Hi, I think the same as Prashant, I'm almost sure you can't connect SQL directly to Quickbase. I have accumulated experience in this type of integrations, using the APIs from an external service (odbc, etc.) will always count you in the annual API consumption which may have a cost after a few months. I designed a tool that waits for the call from Quickbase, returns the necessary data to Quickbase and updates the Quickbase tables. This avoids the API count, write to me at marbentor@gmail.com if you want more information.

    Thank you

    Marcelo Benavides Torres



    ------------------------------
    Marcelo Benavides
    ------------------------------
    Terms & ConditionsAccessibility statement