Forum Discussion

BasilEvans's avatar
BasilEvans
Qrew Member
2 years ago

Pipeline to Import data from SQL table to quickbase table

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 ...
PrashantMaheshw's avatar
PrashantMaheshw
Qrew Captain
2 years ago

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
------------------------------

  • BasilEvans's avatar
    BasilEvans
    Qrew Member
    2 years ago

    I'm trying to avoid the steps of moving to csv files, scheduling,moving creating ssis pacakges. I have the odbc connection to the database and access to the tables. So isn't there a way a pipeline can now use that data and move to quickbase tables? there has to be a way to avoid doing all the above steps.



    ------------------------------
    Basil Evans
    ------------------------------