Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
The RDS Data view and File view allow you to view data sources and files directly on your ColdFusion server. In order to make these items work, you must have RDS enabled, which is discouraged on a production system, and you may not have checked that box when you installed your local ColdFusion 9 server. So, make sure that you're working on a secure system before enabling RDS and in order to check and make sure that you have RDS enabled, you can right-click on the server in your Servers view and choose Launch Admin Page. Now, this opens a ColdFusion Administrator directly inside of CF Builder.
So, I'm going to type in my password here and once we are inside the ColdFusion Administrator, if you click on the Security section here at the bottom of the left-hand side, you should see RDS. If you don't see RDS, then that means that RDS was not enabled on your system when you've installed ColdFusion. Unfortunately, there's no way to enable RDS directly through the ColdFusion Administrator. So, there is an Adobe TechNote that will show you how to do that and that is TechNote number 17276.
Unfortunately, if I scroll down here, you can see that it involves a bunch of editing of XML files and restarting your server. It's not too bad, but you will need to go through and edit those XML files and restart your server before you can continue with the rest of this video. So, let's go back to ColdFusion Builder. Now that I know that I have my RDS enabled, I know my password, I can close this, and we're back at our regular ColdFusion Builder view. Depending on the setup on your local machine, the CFCs displayed may differ from those shown here.
And over here in the RDS Data view, we can expand our Local CF9 node and I can see all of the data sources that exist on that server. I can also expand each of these data sources and look into any tables, views and all the other resources on this database. I can even expand the individual tables and see every single column and their data types. The other great thing about the RDS Data view, especially if you're on a Mac and connecting to a SQL Server database, or you're on a Windows machine and you don't have MySQL or SQL Server installed locally or don't have the tools to connect directly to your database, you can actually run queries directly from the RDS Data view.
This little button here is the RDS Query Viewer. I'm going to click that and I can actually start writing queries directly in here to look at the data on my server. So, at the top, I can choose the server that I want, the data source, we'll look into cfartgallery, and I can type some SQL, I can click Execute and I can take a look at all the data inside of that table directly from inside CF Builder. So, we'll close the RDS Query Viewer and if we go back over here, we can also see that I can right-click on the table names and show the table contents or edit the RDS configuration.
I can refresh the RDS Server if I've made changes to datasources that I need to show up. The Go Into option also allows me to drill down into a smaller subset of data. Let's do this, for example. If I'm working on the cfartgallery database, I might not want to see all this other stuff. So, I can right-click on cfartgallery and choose Go Into. Now, all I'm seeing is the cfartgallery Tables, System Tables, Views, and Synonyms. If I need to get back up to the top because I want to see all the datasources, I can click on the Home button and now I can see everything on that server.
Now, if I need to change something about my RDS configuration, I can click this button right here, which will open up the RDS Configuration dialog. I can choose the server that I'm working on and then I can adjust the user name and the password. Well, I wanted to prompt me for a password and a few other options. So, go and cancel this dialog and that's about all there is to the RDS Data view. The View Setting right next to that one is the RDS File view. This allows me to look at all the files on my "remote system." Now I'm actually using my local system as my remote system so I can see everything on my Mac hard drive directly through the RDS File view.
So, if I click on Applications, I'll find ColdFusion9. I'll choose Go Into and now go down to the wwwroot. I'll Go Into here and then I can see everything that I can also see in my navigator. RDS integration was something I've used a lot of in Dreamweaver and sorely missed when I switched over to CF Eclipse. It's great to have the feature back in a dedicated ColdFusion IDE. Just make sure that you only use the RDS access on your local development or secure staging servers and never enable RDS in a production environment.
Get unlimited access to all courses for just $25/month.Become a member
61 Video lessons · 99455 Viewers
56 Video lessons · 112690 Viewers
71 Video lessons · 81510 Viewers
131 Video lessons · 39132 Viewers
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.