Instead of defining a DB connection it should just use the RDS connection. Once you have entered the values for the RDS connection into the application panel in DW you should be able to select from any of the datasources available on the server from within the wizard.
The other server models use special connection files to connect to the data, but ColdFusion just connects directly to the server and the datasource is specified for each use.