How to Use Amazon AWS Credentials to Access/Query Tables in AWS RDS Instance through Mobile App

+1 vote

I've been quite confused for a couple of weeks. Did a ton of research on how to actually connect to an AWS RDS SQL Server Instance through my mobile app and no cigar.

At this point, I can do the following: I can connect to it using SQL Management Server Client with no problem. I am using AUTH0 to get the AWS Credentials, Session Token, Secret Access Key, ARN of the assumed role, etc...

How do I use the AWS credentials to access and query an RDS Database Instance? I know I have to use some kind of HTTP/REST to request information but how? In what format? Can you give me an example? Do I need to use EC2 to access it? I am so confused, but I think at this point I am really close, so please help. I am currently using C# (XAMARIN) to code my Android App.

Thank you for looking!

Aug 28, 2018 in AWS by bug_seeker
• 15,360 points
53 views

1 answer to this question.

0 votes

You should make your backend functions to do this. I use Node.js and the 'serverless' framework, which can be downloaded through npm. You can execute SQL commands through the node.js code. Then upload the function to AWS Lambda. Finally you make an endpoint via API Gateway and you can download their pre-generated sdk to access your functions through your client (the mobile app). Check out this channel, https://www.youtube.com/watch?v=fSUEk6iMW88

answered Aug 28, 2018 by Priyaj
• 56,960 points

Related Questions In AWS

0 votes
1 answer

How to auto-scale MYSQL database in AWS EC2 instance?

You could always use the Amazon RDS ...READ MORE

answered Aug 24, 2018 in AWS by Archana
• 4,110 points
552 views
0 votes
1 answer

How to add IAM role to an existing instance in aws?

As of AWS CLI v1.11.46,  you can ...READ MORE

answered Sep 6, 2018 in AWS by Archana
• 4,110 points
203 views
0 votes
1 answer

How to allocate IP address in VPC to RDS instance?

The instance will already have an IP ...READ MORE

answered Oct 31, 2018 in AWS by Archana
• 5,580 points
329 views
+1 vote
2 answers

How to launch and access an instance using AWS-CLI?

aws ec2 run-instances --image-id ami-id --key-name yourkeyname ...READ MORE

answered Feb 23 in AWS by Shashank
• 1,350 points
172 views
+13 votes
2 answers

Git management technique when there are multiple customers and need multiple customization?

Consider this - In 'extended' Git-Flow, (Git-Multi-Flow, ...READ MORE

answered Mar 26, 2018 in DevOps & Agile by DragonLord999
• 8,380 points
250 views
0 votes
1 answer
0 votes
1 answer

In Amazon Data Pipeline, how to make sure only once instance of a pipeline is running at any time?

On the CopyTablesActivity, you could set a lateAfterTimeout attribute ...READ MORE

answered Sep 19, 2018 in AWS by Priyaj
• 56,960 points
403 views
0 votes
1 answer

how to access AWS S3 from Lambda in VPC

With boto3, the S3 urls are virtual by default, ...READ MORE

answered Sep 28, 2018 in AWS by Priyaj
• 56,960 points
2,282 views