Creating SQL Spreadsheets

  To create a SQL spreadsheet:

1. Start Web Analysis Studio.

2. Perform one:

   • Select File, then New, then Document.

   • Click .

   • Click , and select Document.

   • In the View Pane Browser tab, right-click a document and select Edit.

   • Press Ctrl+N.

     The Document Designer is displayed.

3. Drag the SQL Spreadsheet icon from the component toolbar to a document panel.

   The Enter SQL Query dialog box is displayed.

4. Select a supported JDBC driver type from the JDBC Driver drop-down list.

   You can select from Microsoft SQL Server, IBM DB2, Oracle, JDBC-ODBC Bridge, and Other.

   When the selection is made, a driver name populates the corresponding Driver text box. If Other is selected, you must enter a driver name definition.

   When the selection is made, a sample database connection string syntax populates the corresponding JDBC Connection String text box. When Other is selected, you must enter a JDBC database connection string.

5. Edit the sample database connection string syntax so that it specifies your RDBMS computer name and database name.

6. Enter a user name and password for the relational data source in the corresponding text boxes, or select Username/Password to enter your current logon credentials.

7. Optional: Define query governor parameters for row limits and fetch size.

   The default settings limit the result set to 250 rows, being fetched 100.

8. Define a SQL query, using one of these methods:

   • Enter a SQL query, using standard SQL syntax, in the panel at the bottom of the dialog box.

   • Click Query Builder to display the SQL Query Builder Wizard.

     See SQL Query Builder Wizard.

9. Click OK.

   The query is sent to the relational data source and a SQL spreadsheet is displayed on the document panel.