Perform the following steps to access the
SQL Query Designer:
- In the Data tab, right-click on Data Sets and select JDBC.
The JDBC Data Source window appears.
- Select your data source in the Connections pane on the left, then click the round green + icon above the Available Queries pane on the right.
- Type a concise yet sufficiently descriptive name for your query in the Query Name field.
- Click the pencil icon above the upper right corner of the Query field.
The
SQL Query Designer tool appears, as
shown in the following example: