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.
Pingback: Create ESS Job in fusion for BIP Report | Clarity Consulting
Hi,
Can you tell me how to use ADF BC SOAP web service as BI Web service Data Source.
Regard,
Rajesh.A
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)
It is not recommended to remove namespaces from an XML family document. At times, that input xml will be ill-formed, so my recommendation is not to remove the namespace.
All that you need to talk to webservice is concrete WSDL. So get WSDL from the server where your ADFBC is deployed and start using it in creation of data source.
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
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
is it still valid ?
Some what yes.