Making Quickbase work with Sql Server

  • 1
  • 1
  • Question
  • Updated 7 months ago
  • In Progress
Hi
Thanks to GDPR and Data Privacy acts, I need to keep critical customer and employee data on a SQL server hosted in our company's data center. I have three needs and would want opinion from experts on how to move forward:
1)- In a QB form, if i enter a employee number, I want the form to reach to the SQL server and extract the employee data and show it in quickbase form. I don't want the data which I have pulled to be saved in Quickbase.
2)- In the QB form, how can  i build a search screen for all employee.
3)-  In the Quickbase Report, how can i pull the data while report of a record is being listed. To explain better, the record which i would save in form in step 1 will have the employee id. Now in report I want to show employee name and other related fields. How do i construct a report in such a scenario ? I am willing to try something outside quickbase for the same.

Thanks
Dinesh Rampal
Quickbase Enthusiast
Photo of Dinesh

Dinesh

  • 202 Points 100 badge 2x thumb

Posted 7 months ago

  • 1
  • 1

I've done something similar with Ruby SDK and Rails framework. This will provide a new front end with QB and SQL Server as the backend databases.