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

Creating a Text data source query manually

Before you use a Text pluggable data source, you might want to examine the text file by opening it in a text editor first to see what it looks like.

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

To create a Text query manually:

  1. First, set up the Text PDS configuration file (textpds.conf) with your text file's format information.

  2. Launch Reports Builder.

    Tip: If Reports Builder was already open when you modified the textpds.conf file, you must shut down Reports Builder and restart it for Reports Builder to recognize your text file as a valid data source.

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

  4. In the Data Model view, single-click the Text Query tool in the tool palette.

  5. Click in the main area (canvas region) of the window to display the Define Text Query dialog box.

    If you get an error message and cannot display the Define Text Query dialog box, check your configuration file (textpds.conf) to confirm the code you added.

  6. In the Define Text Query dialog box, under Data Definition, select the format for your Text data source. The formats listed here are registered in the textpds.conf file.

  7. Under Data Source, click Browse to find the file for the Text PDS, or type a URL where the Text PDS is located in the Location field.

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

See also

The chapter titled "Building a Report with a Text 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).

About the Text pluggable data source

Creating a Text data source query using the Report Wizard