How to add Data Source in BI Publisher using JDBC

                      The JDBC driver for the selected database must be available to BI Publisher. If you are using an Oracle database or one of the DataDirect drivers provided by WebLogic Server, then the drivers must be installed in the correct location and there is no further setup required.

                     

                      If you plan to use a different version of any of the drivers installed with WebLogic Server, then you can replace the driver file in D:\OBI_MW\wlserver_10.3\server\lib with an updated version of the file or add the new file to the front of your CLASSPATH.

Click Administration on the right hand side top after you logged in with BI Administration Privilege

Then under data source click JDBC Connection

Click Add Data Source

Give the appropriate information in the fields, Mandatory fields are marked with asterisk *

Data Source Name — Enter a display name for the data source. This name is displayed in the Data Source selection list in the Data Model Editor.

Driver Type — Select the database type from the list. When you select a driver type, BI Publisher automatically displays the appropriate Database Driver Class and provides the appropriate Connection String format for your selected database.

Database Driver Class — This is automatically entered based on your selection for Driver Type. You can update this field if desired.

For example: oracle.jdbc.OracleDriver 

Connection String — Enter the database connection string.

When you select the driver type, this field automatically displays the appropriate connection string format for your database type.

For an Oracle database the connect string must have the following format:

jdbc:oracle:thin:@[host]:[port]:[sid]

For example: jdbc:oracle:thin:@myhost.us.example.com:1521:prod

Use System User — This is reserved for connections to the Oracle BI Server.

User Name — Enter the user name required to access the data source on the database.  Password — Enter the password associated with the user name for access to the data source on the database.

Pre Process Function and Post Process Function — (Optional) Enter a PL/SQL function to execute when a connection is created (Pre Process) or closed (Post Process).

Use Proxy Authentication — Select this box to enable Proxy Authentication.

Click Test Connection. A confirmation is displayed. 

(Optional) Enable a backup database for this connection by entering the following:

Use Backup Data Source — Select this box.

Connection String — Enter the connection string for the backup database.

Username / Password — Enter the username and password for this database.

Click Test Connection. A confirmation is displayed. 

Define security for this data source. Use the shuttle buttons to move roles from the Available Roles list to the Allowed Roles list. Only users assigned the roles on the Allowed Roles list can create or view reports from this data source.

The settings defined here are passed down to the backup data source, if one is defined.

Once you are done click Apply

New Data Source has been added Successfully.