Configuring RDS

You must configure one RDS server for each ColdFusion MX server for which you define reports. After you configure an RDS server, you can use the Query Builder to access data sources that you defined in the associated ColdFusion MX server, and select database columns for use as query fields in a report.

To add an RDS server:

  1. Open the Preferences dialog box by selecting Edit > Preferences from the menu bar.
  2. Click Server Connection.
  3. Click the plus sign (+) next to the drop-down list in the upper-left corner of the dialog box.

    The Configure RDS Server dialog box appears.

  4. Specify the following information:

    Description A name for the server connection. This name appears in the drop-down list on the left side of the Query Builder.

    Host name The host on which ColdFusion runs. Type localhost or an IP address.

    Port Web server port number. Accept the default port (80) or enter the port number of the ColdFusion server's built-in web server (8500 is the default).

    Context Root (J2EE configuration only) Specifies the context root (if any) for the ColdFusion web application.

    Use Secure Sockets Layer Select this option if needed for SSL security.

    User Name Not applicable to ColdFusion RDS.

    Password RDS password. You set this password in the ColdFusion MX Administrator.

    Tip: Do not confuse the RDS password with the ColdFusion MX Administrator password, which you also manage through the ColdFusion MX Administrator.

    Prompt for password Specifies whether to prompt for an RDS password each time you use the Query Builder. If you select this option, leave the User Name and Password fields blank.

  5. Click OK.

To designate a default RDS server:

  1. Open the Preferences dialog box by selecting Edit > Preferences from the menu bar.
  2. Click Server Connection.
  3. Select an RDS server from the Preferred RDS Server drop-down list.
  4. Click OK.

    The Report Builder automatically connects to the specified server when you display the Query Builder or Chart Wizard.

View comments in LiveDocs