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

Creating an XML data source query manually

Accessing an XML data source does not require any database connection information as required for SQL queries.

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

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

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

  4. In the Define XML Query dialog box, define the XML query based on the fields defined in the data definition file (DTD) selected. The query is run against the data in the XML data file. If an XSL file is specified, it translates the XML data file before running the query.

  5. In the Define XML Query dialog box, click Browse next to Data Definition Location to select your data definition file location (DTD / XML Schema). You can also type the URL location containing your Data Definition.

  6. (Optional) Click Select Columns to display the Select Columns dialog box and select the columns you want to have in the query in your report.

  7. Click Browse next to Data Source Location to select your data source file. You can also type the URL location containing your XML data.

  8. If you want to validate the data source or specify an XSL, continue with Steps 9 through 11. If not, skip to Step 12.

  9. Click Show Advanced to extend the Define XML Query dialog box. You can click Hide Advanced to hide the advanced selection   options.

  10. Check Validate Data Source if you want to validate your data source strictly against your data definition. If checked, the XML PDS will use the DOM parser internally. If you don't want to validate your data dource against your data definition, make sure that Validate Data source is not checked so that the XML PDS will use the SAX parser.

  11. (Optional) Specify the location of an XSL file by typing its URL. This is required if your Data Source XML is in a different format than the expected format for the XML PDS. This XSL file should contain the necessary transformation to convert your XML format to the expected format specified in About document type definition (DTD) formats.

  12. Click OK to close the dialog box and display your new XML query in the Data Model view.

See also

The chapter titled "Building a Report with an XML Pluggable Data Source" in the Oracle Reports Building Reports manual, available on the Oracle Technology Network Oracle Reports Documentation page (http://www.oracle.com/technology/documentation/reports.html).