Create datasource on webservice in Oracle BI Cloud

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.

  1. Click on Administration link on the main menu on Oracle BI Publisher

  2. Click on Manage BI Publisher

  3. 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).

  4. This page shows the list of existing webservice data sources. Click on Add Data Source button.

  5. 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.
  1. This will create a web service data source.

9 thoughts on “Create datasource on webservice in Oracle BI Cloud

  1. Pingback: Create ESS Job in fusion for BIP Report | Clarity Consulting

    1. Rajesh Annamalai

      I created ADF BC web service and configured BI web service data source as on your blog. In Response the name space also coming. How to remove the name space in ADF BC web service.

      ns0:getEmpDetailsResponse
      Click to expandns2:result [xmlns:ns2=/model/common/types/] [xmlns:ns1=/model/common/] [xmlns:ns0=http://xmlns.oracle.com/adf/svc/types/] [xmlns:xsi=http://www.w3.org/2001/XMLSchema-instance] [xsi:type=ns1:EmpViewObjSDO]
      ns1:CommissionPct [xsi:nil=true]
      ns1:Day [xsi:nil=true]
      ns1:DepartmentId (90)
      ns1:Email (SKING)
      ns1:EmployeeId (100)
      ns1:Experience (8)
      ns1:FirstName (Steven)
      ns1:HireDate (1987-06-17T00:00:00.0Z)
      ns1:Internal [xsi:nil=true]
      ns1:JobId (AD_PRES)
      ns1:LastName (King)
      ns1:ManagerId [xsi:nil=true]
      ns1:Pan (AGTRD7856L)
      ns1:PfNo (971548548963254)
      ns1:PhoneNumber (515.123.4567)
      ns1:Salary (24000)
      ns1:WebLink (www.erpstuffworks.com)
      ns1:WorkPlace (State of California)

  2. Sage Rothchild

    Hey just wanted to give you a quick heads up. The text in your post seem to be running off the screen in Safari. I’m not sure if this is a formatting issue or something to do with browser compatibility but I figured I’d post to let you know. The design and style look great though! Hope you get the issue solved soon. Kudos

  3. NarcosXXX

    Awesome blog! Is your theme custom made or did you download
    it from somewhere? A theme like yours with a few simple tweeks would really make
    my blog jump out. Please let me know where you got your theme.
    Thanks

Leave a Reply to NarcosXXX Cancel reply

Your email address will not be published. Required fields are marked *