How to connect to Amazon Relational Database Service with Toad for SQL Server

Hello out there in data land. My name is Robert Pound, and I'm a product technologist for Quest. This video will show how you can take advantage of Amazon's cloud database technologies in Toad for SQL. I will show you how to quickly access an instance of SQL running in Amazon's relational database service or RDS. Then walk through my experience with security. So I start with Toad for SQL server open. I need to open up the RDS dashboard. So from there I will choose instances and I will open up the desired instance that I want to connect to. In this case, my SQL server express instance. So from here I can copy the end point, which is what we use to connect. So I copy this. Then going back to Toad I will create a new connection, and I will copy in the end point into the server name. And I will remove the port number and the colon off the end of the string. And I will choose SQL server authentication and enter in the credentials administrator, as well as my password. And choose the default database. I'll just go with the default that's fine. And choose any other options. Connect on startup if I wish, but I'm going go ahead and just leave this the way it is and choose connect. And that's all we need to do to be able to connect to an RDS database. So that was pretty simple and straightforward. Now let's talk about the security aspects. So first of all, let's go ahead and switch back over to Toad World. And real quick what I'm going to do is just do a search of Amazon RDS and Toad World. It will bring up several results, but we what we want to look at is using my SQL in Oracle databases on Amazon RDS. That doesn't necessarily apply in our situation, but in this article the author talks about security groups, which was what I used to go ahead and set up my Amazon instance. There's a bunch of information out there as far as security settings etc., but you may need to set up a security group to connect into your instance running in the cloud. And just to show you what I did for the set up, so in the virtual private cloud dashboard I went under Security group settings and I chose my security group. And then modified my inbound rules for my SQL, and this is allowing all inbound traffic that may not be preferable for you, depending on how you have it set up. But that's just how I did it in this demo. And that's really all I had to share as far as connecting to RDS with Toad for SQL. Hopefully this helped you understand a little bit more about how you can leverage cloud technologies and Toad for SQL Server. For more information on this product go to www.quest.com/products/toadforsqlserver, or you can check out the community driven innovation going on at www.toadworld.com/products/toadforsqlserver. Thank you, and have a great day.