BI Publisher reports rely on XML data. BI Publisher supports retrieving data from a variety of data sources.
The following data sources must be first set up in BI Publisher through the Administration page:
Database connections
BI Publisher supports direct JDBC connections and connections through a JNDI pool (recommended)
LDAP connections
OLAP connections
File directory connections - you can use existing XML files, Microsoft Excel files, or CSV files stored in a directory that BI Publisher can access
Web Service connections
HTTP XML connections
For more information on setting up these data source connections, see Setting Up Data Sources.
If you have integrated your system with Oracle Business Intelligence you can also take advantage of the following data sources:
Oracle BI Analysis
Oracle BI Server subject area
You can also upload some file types stored locally.