This content has been marked as final.
Show 8 replies
-
1. Re: Consuming OBIEE Webservice using Java.
Madan Thota Sep 13, 2010 5:36 PM (in response to 797523)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 -
2. Re: Consuming OBIEE Webservice using Java.
SaichandVaranasi Sep 13, 2010 5:41 PM (in response to 797523)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 -
3. Re: Consuming OBIEE Webservice using Java.
797472 Sep 17, 2010 6:56 AM (in response to 797523)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. -
4. Re: Consuming OBIEE Webservice using Java.
SaichandVaranasi Sep 17, 2010 7:09 AM (in response to 797472)hi,
Are you using JDev or SOAP toolI am getting the following error when after importing the WSDL file and trying to generate the java classes.
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 -
5. Re: Consuming OBIEE Webservice using Java.
797472 Sep 17, 2010 8:07 AM (in response to SaichandVaranasi)Hi Saichand,
I am using Eclipse Tool for importing WSDL and implementing the webservice.
Regards,
Vijay. -
6. Re: Consuming OBIEE Webservice using Java.
SaichandVaranasi Sep 17, 2010 8:13 AM (in response to 797472)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 -
7. Re: Consuming OBIEE Webservice using Java.
797472 Sep 19, 2010 2:26 PM (in response to 797523)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. -
8. Re: Consuming OBIEE Webservice using Java.
797472 Sep 19, 2010 5:00 PM (in response to 797523)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