Forum Discussion

PrashantMaheshw's avatar
PrashantMaheshw
Qrew Captain
2 years ago

Re: Pipeline to Import data from SQL table to quickbase table

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

2 Replies

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