1

I am currently working with a feature in our Ionic/Backand app that needs to access data from an external database (RedShift Cluster). I am thinking of the best way possible to accomplish this, and since we are using Backand as our backend, I thought if it was possible to make an action that could access RedShift Cluster and make SQL queries to it. Any help would be appreciated. Thanks!

bolivar
  • 70
  • 4

1 Answers1

2

Here is one option is

  1. adding a generic lambda function to access AWS redshift,

  2. Use AWS API Gateway to expose this lambda to Back &, (it is as secure as you want it to be, utilizing API key and AWS secret and access tokens of the IAM user)

  3. Then calling this API in Back& server-side JS action by using $http object is a breeze

user3375230
  • 421
  • 2
  • 5