To add a PDS to Reports Builder:
Using a text editor, open the file cauprefs.ora
(Windows) or prefs.ora
(UNIX)
located in ORACLE_HOME
.
Locate Reports.PluggableDataSourceFactories.
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.
Add the PDS class to the classpath for both Reports Builder and Reports Server.
Restart Reports Builder for the changes to take effect.
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")
Accessing non-Oracle data sources
Connecting to a pluggable data source
Adding online Help to a pluggable data source
Pluggable data source interface definition
Oracle Reports Plugin Exchange on the Oracle Technology Network
(OTN): on the Oracle Reports 10g page (http://www.oracle.com/technology/products/reports/index.html
),
click Plugin Exchange.
Chapter "Configuring and Using the JDBC PDS" in the OracleAS
Reports Services Publishing Reports to the Web manual, available on the
OTN Oracle Reports Documentation page (http://www.oracle.com/technology/documentation/reports.html
)
Copyright © 1984, 2005, Oracle. All rights reserved.