8 Replies Latest reply on Sep 19, 2010 5:00 PM by 797472

    Consuming OBIEE Webservice using Java.

    797523
      Hi,

      I wanted to consume OBIEE Webservice using Java. I wanted a simple data extraction to be done.

      I have the following queries regarding the webservice call.

      1. Please let me know which OBIEE wsdl to be used for this implementation

      2. I am using Eclipse IDE, i wanted steps to configure the OBIEE Server in the Eclipse. ( I tried , but not able to configure the OBIEE/.../j2ee/home...properly, throws some error)
      .
      3. Please guide me in the webservice call and method implementation which is of ease in data retrieval.


      Thank You
        • 1. Re: Consuming OBIEE Webservice using Java.
          Madan Thota
          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
            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
              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
                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
                • 5. Re: Consuming OBIEE Webservice using Java.
                  797472
                  Hi Saichand,

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


                  Regards,
                  Vijay.
                  • 6. Re: Consuming OBIEE Webservice using Java.
                    SaichandVaranasi
                    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
                      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
                        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