Enter SQL Query Dialog Box

The Enter SQL Query dialog box enables you to define a relational SQL query that supports the SQL Spreadsheet custom document component. The Enter SQL Query dialog box prompts you to specify a supported JDBC driver, JDBC connection string, log on credentials, and a SQL query. You can compose the SQL query using standard SQL syntax in the panel at the bottom of the dialog box, or you can use a SQL Query Builder Wizard. You can also define row limits and fetch limit parameters for the SQL query.

Control

Description

JDBC Driver Configuration

Enables you to select a supported JDBC driver from a drop-down list:

  • IBM DB2

  • Microsoft SQL Server

  • Oracle

  • Teradata

  • JDBC-ODBC Bridge—leverages a Microsoft Windows ODBC driver as a JDBC connection. To use this option, you must manually configure the JDBC Connection String using "JDBC:ODBC:<DSN>" (where DSN is the ODBC connection name).

  • Other—Specifies alternative JDBC driver parameters.

JDBC Connection String

A sample database connection string syntax is provided in this text box. You must edit the string so that it specifies your RDBMS computer name and database name. In the case of Other, you must enter a database connection string syntax.

JDBC Username

Indicate a user name for the relational database. You cannot create a relational database connection without specifying a password.

JDBC Password

Indicate a password for the user name. Important! Web Analysis Studio requires this text box to be populated. You cannot create a relational database connection without specifying a user name and password.

JDBC Row Limit

Enables you to enter an optional query governor limiting the result set to a number of rows.

JDBC Fetch Size

Enables you to enter an optional query governor limiting the number of rows returned at time. In other words, transactions limited to the fetch size are conducted until the overall row limit is reached.

SQL Query Panel

Enables you to enter a SQL query manually.

Query Builder

Displays the SQL Query Builder Wizard, enabling you to make selections from tabs that are subsequently parsed into a SQL query.