Can AWS securely host a SQL database and allow access to it for Skuid?

  • 1
  • Question
  • Updated 1 year ago
  • Answered
Question regarding the capabilities of the Skuid Platform - wondering if someone from the Skuid Team is able to shed light on this.

Can AWS securely host a SQL database and allow access to it for Skuid?
Photo of mB Roman Melnik

mB Roman Melnik

  • 2,802 Points 2k badge 2x thumb

Posted 2 years ago

  • 1
Photo of Zach McElrath

Zach McElrath, Employee

  • 49,056 Points 20k badge 2x thumb
Roman, currently the answer is no. To access data in a SQL database stored in AWS, e.g. a Postgres RDS instance, you would need to create a REST API on, say, EC2 to securely allow access into the desired SQL database's tables, authenticating requests as appropriate. One approach to doing this is to use something like PostgREST, which automatically generates a sophisticated REST API around selected PostgreSQL tables and provides extremely past performance: http://postgrest.com/en/v0.4/

A generic SQL Data Source Type is, however, on the Skuid product roadmap, so stay tuned.
Photo of Greg Johnson

Greg Johnson

  • 602 Points 500 badge 2x thumb
Hey Zach - any idea how far away that SQL data source might be?  We'd also like to pull data from postgres.
Photo of mB Roman Melnik

mB Roman Melnik

  • 2,802 Points 2k badge 2x thumb
+1 vote. I know it's on the roadmap Zach. So don't mean to place unnecessary pressure.

Simply, there is a real need for this and would open many doors for potential new business/clients for many Skuid Partners.

Recently a couple of old posts on connecting Wordpress with Skuid's REST API resurfaced and another during Bonzai's release about Heroku, so it's been on my mind again.. DynamoDB with NoSQL is supported, but frankly, not familiar with it. MySQL and Postgres would open up a whole new world. :)
(Edited)
Photo of mB Roman Melnik

mB Roman Melnik

  • 2,802 Points 2k badge 2x thumb
Also @Greg Johnson, Zach is a busy guy I'm sure hehe. So I found a recent response of his that I think answers both our questions.

Source: https://community.skuid.com/skuid/topics/connection-to-mysql-database-hosted-with-rackspace
Skuid cannot currently connect directly to SQL databases - direct SQL connections are on our near-term roadmap.

For Skuid to connect to a SQL database right now, you would need to setup a REST or OData API to serve as a middle layer between Skuid and the database. The easiest way to do this would be to go through an integration vendor such as Progress DataDirect or Mulesoft.
(Edited)
Photo of mB Roman Melnik

mB Roman Melnik

  • 2,802 Points 2k badge 2x thumb
Thanks for the detailed response Zach. And very happy to hear that a generic SQL data source type is on the roadmap. Cheers!
Photo of David Forder

David Forder

  • 2,144 Points 2k badge 2x thumb
I am having great success with a NoSql database (Amazon DynamoDB) on Skuid Platform is that helps )
Photo of Andy Kallio

Andy Kallio

  • 182 Points 100 badge 2x thumb
Hello. I am brand new to skuid.  I wonder if this has changed at all since last release (Brooklyn), which looks like it came out around the same time as this question. I am a salesforce admin currently evaluating salesforce connect, which we want to use to expose a Postgres db hosed on aws  in our salesforce org. In order to do that, we need to make our postgres db and OData producer. The latest skuid docs indicate this can be done with sql server: http://help.skuid.com/m/models-conditions-filters/l/378311?data-resolve-url=true&data-manual-id=...

Why can't these steps be followed for a postgres db on aws?

Thanks!!
Photo of Bill McCullough

Bill McCullough, Champion

  • 12,436 Points 10k badge 2x thumb
Andy,

If you can get OData setup on Postgres, that should work well.  Just make sure that the OData 'service' supports whatever Skuid supports.

If you are not 'set' on using Amazon, you could setup an Azure instance of SQL and get rolling.  Azure supports OData out of the box.

Thanks,

Bill