- Click the Test button to execute the SQL statement.
- The Confirm Password dialog box is displayed. In the Please confirm database password: field, type the password for the ODBC connection, and click OK.
-
The Data Set Results dialog box displays the Keyword Values returned.
If the statement is properly formatted and the external data source is available, the statement retrieves up to ten values. An error message displays if no values are retrieved.
- When the configuration is successful, click Save to exit the External Keyword Data Set Configuration dialog box.