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
![032617_0450_Howtosetupa1 How to set up a data source in BI Publisher](https://i1.wp.com/www.catgovind.com/wp-content/uploads/2017/03/032617_0450_Howtosetupa1.png?resize=1055%2C493)
2. Click on the link Administrator on the top right corner
![032617_0450_Howtosetupa2 How to set up a data source in BI Publisher](https://i2.wp.com/www.catgovind.com/wp-content/uploads/2017/03/032617_0450_Howtosetupa2.png?resize=1100%2C174)
3. Click JDBC Connection under Data Sources
![032617_0450_Howtosetupa3 How to set up a data source in BI Publisher](https://i0.wp.com/www.catgovind.com/wp-content/uploads/2017/03/032617_0450_Howtosetupa3.png?resize=477%2C347)
4. Click the button Add Data Sources. You can create multiple data sources
![032617_0450_Howtosetupa4 How to set up a data source in BI Publisher](https://i2.wp.com/www.catgovind.com/wp-content/uploads/2017/03/032617_0450_Howtosetupa4.png?resize=882%2C380)
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
![032617_0450_Howtosetupa5 How to set up a data source in BI Publisher](https://i2.wp.com/www.catgovind.com/wp-content/uploads/2017/03/032617_0450_Howtosetupa5.png?resize=1100%2C399)
No comments:
Post a Comment