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

Adding a pluggable data source

To add a PDS to Reports Builder:

  1. Using a text editor, open the file cauprefs.ora (Windows) or prefs.ora (UNIX) located in ORACLE_HOME.

  2. Locate Reports.PluggableDataSourceFactories.

  3. Add the name of your PDS using the following syntax:

    Reports.PluggableDataSourceFactories = ("pluginClassname"[, "pluginClassname"]...)

    where

    pluginClassname is the name of the PDS class.

    Note
    : Multiple pluggable data sources are separated by a comma.

  4. Add the PDS class to the classpath for both Reports Builder and Reports Server.

  5. Restart Reports Builder for the changes to take effect.

Example

The following lines add XML and JDBC as pluggable data sources:

Reports.PluggableDataSourceFactories=
("oracle.reports.plugin.datasource.xmlpds.XMLDataSourceFactory",
"oracle.reports.plugin.datasource.jdbcpds.JDBCDataSourceFactory")

See also