How can I have a Quickbase front end to display and report for billing data that is hosted in a mySQL database in AWS.

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered

I have a mySQL data base that contains billing data (not PII).  I need to be able to provide finance access to that billing data without giving them access to AWS.  I would like Quickbase to provide the front end for the mySQL data so finance can log in to Quickbase, and let Quickbase pull the data from mySQL in AWS.

Photo of matthew

matthew

  • 0 Points

Posted 3 years ago

  • 0
  • 1
Photo of Keith

Keith, Champion

  • 1,092 Points 1k badge 2x thumb
one way is to use QuickBase CSV Sync.  You can have a process scheduled on your AWS server to create csv file(s) from your SQL data, store them in box, dropbox, or google drive.  Then use QuickBase CSV Sync to get that data into your QuickBase application.

The data will not sync back from QuickBase to your AWS SQL Dbase though so if changes are made in QuickBase they won't be reflected in SQL.

more info here:  http://quickbase.intuit.com/sync

Keith