A script-enabled browser is required for this page to function properly.

Creating a JDBC data source query manually

To create a JDBC query manually:

  1. In Reports Builder, display the Data Model view.

  2. In the Data Model view, single-click the JDBC Query tool in the tool palette.

  3. Click in the main area (canvas region) of the window.  

  4. In the JDBC Query dialog box, define the JDBC query or procedure and the connection parameters for the data source. Click Help for assistance.

  5. Click Connect to display the Connect dialog box.

  6. In the Connect dialog box, enter your user name, password and database name, choose the Driver Type you want to use, then click Connect.

  7. In the JDBC Query dialog box, click OK to close the dialog box and display your new JDBC query in the Data Model view.