How to set up a Data Source in BI Publisher

Before start developing a report, the data source must be setup in BI Publisher. The data source is simply a database connection the report is looking for data to generate reports. For example, a user wants to generate a report that displays the list of countries. Here the list of countries may come from a database table.

In this section, we detailed how to set up a data source in BI Publisher 12C.

Version User: Bi Publisher 12.2.1

Setup Data Source in BI Publisher

1. Login into XMLPSERVER as WebLogic admin. The default user is http://HOST:PORT/xmlpserver

2. Click on the link Administrator on the top right corner

3. Click JDBC Connection under Data Sources

4. Click the button Add Data Sources. You can create multiple data sources 

5. Enter your database connection details that you are going to generate a report. Also, input pre/post process function if any. That’s it.We are done. 

Pre Process Function: Enter a PL/SQL function that you want to execute when a database connection is created. The function must return a Boolean

Post Process Function: Enter a PL/SQL function that you want to execute when a database connection is closed. The function must return a Boolean

Note: I have entered the HR schema here which is a demo schema bundled with Oracle database. By default this is locked, to unlock it, log in to your database as system user and issue the query

1 2 3

ALTER USER hr ACCOUNT UNLOCK IDENTIFIED BY hr;