Coldfusion Rds Server in Eclipse

Cold Fusion RDS - Remote Development Services. Cold Fusion RDS is not designed for shared hosting environment and presents a high security risk if enabled on shared servers.

Steps to Integrate RDS In cfeclipse

1) During installation Process of Coldfusion enable the RDS and assign username and Password there.

2) If RDS is installed a icon is shown in my computer.




3) Enable Line Debugger in coldFusion administrator and it is ask of restarting of Coldfusuion Server.

4) In Eclipse (cfeclipse Perspective ) click on Window Menu (windowshow viewOthers )and click other from the submenu

5) Click the Coldfusion folder , here we can see few options here.

Click on RDS DataView

Up on Clicking on the RDS DataView we can View the RDS dataView Window. Right Click on the Icon and Set the RDS Configuration

And Password is the Password which You have given while installation Coldfusion


Now we can view the all the data sources which we are connected from cfadmin and default data sources (cfartgallery, cfdocexamples).

When we click the visual Query Button ,

There are a lot of Advantages here :


1) There is a drag and Drop facility of the table (Similar to MS Access).
2) We can have auto generated Query Comes when we drag and drop the table from the left Side pane
3) Here we can any kind of Joins here , just right on the blue button , a menu is generated with joining options.
4) No Need to Open the Sql Server Every time, when You just need to work on Select statements.




Disadvantage(s):

Here We can Work with Select Statements .Update, delete , create statements will not work here.
we cannot work with storedprocedures.


Imp Note :

RDS Server should Not be (Enabled) turned on it Production Servers.