Is Amazon RDS available?

  • 252Views
  • Last Post 09 February 2018
0
votes
Lachlan Arthur posted this 09 February 2018

Hello

Your page for Google BigQuery states that it can integrate with Amazon RDS, but I cannot find the RDS connection in SkyVia.

https://skyvia.com/connectors/google-bigquery

Is an Amazon RDS connector available in SkyVia?

Attached Files

0
votes
Mariia Zaharova posted this 09 February 2018

Skyvia supports Amazon RDS databases: https://skyvia.com/connectors/amazon-rds

You can choose and configure the one that is the most suitable for you. For this, open Connections, click New -> Database and then select MySQL, PostgreSQL or SQL Server, and then specify connection parameters.

 

Some useful information how to configure your Amazon RDS database to allow connections from Skyvia:

1) Open Security Group that is specified for your server (you can open it directly from server by clicking it).

2) For the necessary Security Group click Actions and select Edit inbound rules

3) The rules editor will be opened, click Add Rule.

4) Select the necessary instance in the Type combobox, e.g. : MySQL

5) Protocol and Port will be assigned automatically

6) For Source please set 40.118.246.204/32

7) Save the changes and try your scenario again.

 

Please also refer to:

https://skyvia.com/resources/docs/index.html?relational_databases.htm

https://forums.aws.amazon.com/thread.jspa?threadID=102574 (the last answer)

https://social.technet.microsoft.com/Forums/azure/en-US/069eed59-67a8-4b47-b360-d43cbac398e5/cannot-connect-amazon-rds-instance-to-ms-sql-server-express?forum=sqldatabaseengine

http://docs.aws.amazon.com/AmazonVPC/latest/UserGuide/VPC_Internet_Gateway.html

 

Close