Consuming OBIEE Webservice using Java.

Here is the WSDL link if the BI server running on your machine,If its different server and port, please change the url accordingly.

http://localhost:9704/analytics/saw.dll?WSDL

For using in Java IDEs refer to this link http://oraclebizint.wordpress.com/2007/07/31/customizing-obi-ee-soap-api/

- Madan

hi,
>simple data extraction to be done

you need the output to be in PDf or excel ??


Use the ibot web service to get your output pdf or excel into your local drive

http://oraclebizint.wordpress.com/2007/12/17/oracle-bi-ee-101332-calling-java-scripts-and-java-classes-from-ibots/

I will suggest you to use J Developer easy to understand

For eclipse have a look at

http://gerardnico.com/wiki/ide/eclipse/eclipse_how_to_consume_a_webservice_with_wtp


To get XML data and sample code refer

http://gerardnico.com/wiki/dat/obiee/xmlviewservice

http://oraclebizint.files.wordpress.com/2007/07/samplecode_soap_api.pdf

Please guide me in the web service call and method implementation

Following link will give you which web service will do what

http://oraclebizint.wordpress.com/2007/07/31/customizing-obi-ee-soap-api/


thanks,
Saichand.v

Thanks so much of all your replies.

I have trying the same over a week.

I have used the same approach as mentioned for getting the wsdl from this location "http://localhost:9704/analytics/saw.dll?WSDL".

I am using Oracle BI Version 10.1.3.4 and Eclipse for the consuming the webservice.


I am getting the following error when after importing the WSDL file and trying to generate the java classes.

The targetNamespace in the wsdl is creatiing the problem. com.siebel.analytics.web/soap/v5  which is creating problem in creation of the java classes in package


Please help in this regard. I wanted to share my screenshot but not able to display in this forum.


Thanks & Regards,
Vijay.

hi,

I am getting the following error when after importing the WSDL file and trying to generate the java classes.

Are you using JDev or SOAP tool


Have a look http://oraclebizint.wordpress.com/2007/07/31/customizing-obi-ee-soap-api/

topic :Open Jdeveloper and create a new application. (With no templates)

thanks,
saichand.v

Hi Saichand,

I am using Eclipse Tool for importing WSDL and implementing the webservice.


Regards,
Vijay.

hi Vijay,
Did u checked in the option Define custom mapping for name space of package

http://gerardnico.com/wiki/_media/ide/eclipse/eclipse_wtp_web_service_client_2.jpg


thanks,
saichand.v

Hi Saichand,

I have done with checked option for Define Custom Mapping for Namespace to Package.

After that, it asked for the Option to Import, Add or Remove. I have not done anything and i just clicked finished.


This is the erro msg i get :


IWAB0399E Error in generating Java from WSDL: WSDLException (at /wsdl:definitions/wsdl:import): faultCode=OTHER_ERROR: Unable to resolve imported document at 'http://del-hwyy2bs:9704/analytics/res/wsdl/schemas/sawservices.xsd', relative to 'file:/C:/Workspace/Echo_Test/WebContent/wsdl/saw_wsdl.wsdl': Connection refused: connect: java.net.ConnectException: Connection refused: connect
     at java.net.PlainSocketImpl.socketConnect(Native Method)
     at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333)
     at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195)
     at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182)
     at java.net.Socket.connect(Socket.java:519)
     at java.net.Socket.connect(Socket.java:469)
     at sun.net.NetworkClient.doConnect(NetworkClient.java:157)
     at sun.net.www.http.HttpClient.openServer(HttpClient.java:388)
     at sun.net.www.http.HttpClient.openServer(HttpClient.java:500)
     at sun.net.www.http.HttpClient.<init>(HttpClient.java:233)
     at sun.net.www.http.HttpClient.New(HttpClient.java:306)
     at sun.net.www.http.HttpClient.New(HttpClient.java:318)
     at sun.net.www.protocol.http.HttpURLConnection.getNewHttpClient(HttpURLConnection.java:792)
     at sun.net.www.protocol.http.HttpURLConnection.plainConnect(HttpURLConnection.java:733)
     at sun.net.www.protocol.http.HttpURLConnection.connect(HttpURLConnection.java:658)
     at sun.net.www.protocol.http.HttpURLConnection.getInputStream(HttpURLConnection.java:981)
     at java.net.URLConnection.getContent(URLConnection.java:688)
     at java.net.URL.getContent(URL.java:1023)
     at com.ibm.wsdl.util.StringUtils.getContentAsInputStream(Unknown Source)
     at com.ibm.wsdl.xml.WSDLReaderImpl.parseImport(Unknown Source)
     at com.ibm.wsdl.xml.WSDLReaderImpl.parseDefinitions(Unknown Source)
     at com.ibm.wsdl.xml.WSDLReaderImpl.readWSDL(Unknown Source)
     at com.ibm.wsdl.xml.WSDLReaderImpl.readWSDL(Unknown Source)
     at com.ibm.wsdl.xml.WSDLReaderImpl.readWSDL(Unknown Source)
     at org.apache.axis.wsdl.symbolTable.SymbolTable.populate(SymbolTable.java:516)
     at org.apache.axis.wsdl.symbolTable.SymbolTable.populate(SymbolTable.java:495)
     at org.apache.axis.wsdl.gen.Parser$WSDLRunnable.run(Parser.java:361)
     at java.lang.Thread.run(Thread.java:619)


Can you please suggest me step to step process.

Thanks & Regards,
Vijay.

Hi Saichand,

I was able to successfully able to import the java class thro wsdl.

Thanks for your help.


Thanks & Regards,
Vijay.

Edited by: 794469 on Sep 19, 2010 9:58 AM