Usually the first step in creation of a BI Publisher report is to create a data source. Oracle gives an option to create data source on many different kinds, for instance they are supported with JDBC, JNDI, File, LDAP, OLAP, Web Services and HTTP. The data source then created can be used to build data models to be used in the report. In this post, I will discuss data source creation on a webservice data source. One of the use cases of this data source is discussed in Create ESS Job in fusion for BIP Report. Below are the list of the steps to be followed.
Click on Administration link on the main menu on Oracle BI Publisher
Click on Manage BI Publisher
Now you can create the data source from different types of sources. Among these click on Web Service Connection to create data source based on a webservice (WSDL file).
This page shows the list of existing webservice data sources. Click on Add Data Source button.
- Enter all the required field values on Add Data Source page. Make sure that server address does not contain http. You can leave the port to 80 by default. You can enter authentication details in case it is present.
- This will create a web service data source.