Import data into Quickbase table via SQL Query

  • 0
  • 1
  • Question
  • Updated 4 months ago
  • In Progress
How to Import data into Quickbase table via SQL Query, currently i am using Oracle database
Photo of Sneha Wankhede

Sneha Wankhede

  • 244 Points 100 badge 2x thumb

Posted 4 months ago

  • 0
  • 1
Photo of Braller

Braller

  • 80 Points 75 badge 2x thumb
https://qunect.com/  I haven't tried that application but it connects quickbase to sql server using ODBC and has been available for years. Worth testing. You can also write your own application that connects to QuickBase using the API which will give you fine grained control but is a bit of work. 
There's also a zap at zapier that may be worth exploring:  https://zapier.com/apps/quickbase/integrations/sql-server
Photo of Sneha Wankhede

Sneha Wankhede

  • 244 Points 100 badge 2x thumb
Thanks Braller, so is it free the qunect?
Photo of Jana

Jana

  • 324 Points 250 badge 2x thumb
Sneha,  I have been using the QuNect for SQL Server product since 2013.  I did just upgrade to where i am now Importing and Updating information!  It has been wonderful.  I'm self-taught in SQL so i'm sure the ODBC driver could do waaaay more than my skill level allows!  LOL  It's worth the investment in my opinion.  Good luck in what you decide.
Photo of Drew

Drew

  • 432 Points 250 badge 2x thumb
qunect is basically an ODBC driver for quickbase.  We use it extensively to move data back and forth from a MSSQL server.  He has a lot of good documentation on his website, and I would encourage you  to check it out.