Configuring the Data Source in BI PUBLISHER

Types of Supported Data Sources

Oracle BI Publisher supports various types of Data Sources such as JDBC data sources (Oracle Database, and other Databases), XML Files, BI EE Reports (Answers), JNDI data sources, OLAP data sources, Fusion Application Data sources, Web Services, HTTP data sources, and Discoverer.
Before you create a data model based on these data sources, you need to configure a connection to these data sources first.

Defining a JDBC Connection

1.	To define a JDBC connection click the Administration link found on the right side of the BI Publisher page. This displays the BI Publisher Administration page as shown below (Observe the Data Sources section in the screen below):
2.	Click the JDBC Connection link found under the Data Sources section in the Administration page.
3.	This displays the Data Sources page. In the JDBC section, click Add Data Source to create a JDBC connection to your database.
4.	In the Add Data Source page that is displayed, enter the details as given below - Data Source Name - OE Driver Type - Select a driver type to suit your Database (for example, you can select Oracle 10g or Oracle 11g to suit your Database). Database Driver Class - oracle.jdbc.driver.OracleDriver (Define a driver class to suit your Database) Connection String - Provide the database connection details. For example hostname:port:sid. User name - OE (Database user name) Password - OE (Database user password) Do not click Apply or Cancel after defining the above details. Click Test Connection.
5 .	If the connection to the database is established, a confirmation message is displayed indicating the success. ( As shown in the screen below). Then click Apply.
6 .	You can see this newly defined connection (OE) in the list of JDBC Data Sources.