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

edited February 2019 in Questions
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?

Comments

  • Zach McElrathZach McElrath Skuad
    edited October 2017
    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.
  • edited October 2017
    Thanks for the detailed response Zach. And very happy to hear that a generic SQL data source type is on the roadmap. Cheers!
  • David ForderDavid Forder Member
    edited January 2018
    I am having great success with a NoSql database (Amazon DynamoDB) on Skuid Platform is that helps )
  • Andy KallioAndy Kallio Member
    edited May 2017
    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!!
  • edited April 2017
    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
  • Greg JohnsonGreg Johnson Member
    edited July 2017
    Hey Zach - any idea how far away that SQL data source might be?  We'd also like to pull data from postgres.
  • edited July 2017
    +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 July 2017
    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 February 2019
    Looks like this was delivered
  • Zach McElrathZach McElrath Skuad
    edited February 2019
    Yes, you can now have Skuid connect to a SQL database (running on AWS RDS / Aurora, Azure, Google Cloud Platform, or even on-premise) and use that as a read-write transactional data source using one of Skuid's supported SQL Data Source Types:

    - PostgreSQL
    - MySQL / MariaDB
    - Microsoft SQL Server
    - OracleDB
    - Amazon Redshift

    Here is a quick Skuid Dive explaining Skuid's SQL data source connection capabilities:

    https://youtu.be/7Y0a_N2Uw9c?t=31

    And here is our docs landing page for SQL Data Source Types:

    https://docs.skuid.com/latest/en/data/sql/

    All SQL Data Source Types are supported on both Skuid Platform, as well as Skuid running on Salesforce.
Sign In or Register to comment.