Web services / Interface to BI Publisher

[ConvertFromOldNGs]

by Anonymous >> Wed, 30 Jan 2008 3:56:08 GMT

We are trying to interface Oracle BI Publisher with Jade Web Services. Unfortunately BI Publisher only supports document/literal Web Service data sources that return XML as a string. Unfortunately Jade produces a structure based response ( with complex types )

Has anyone else attempted to interface Jade Web services with Oracle BI Publisher ?

Is it possible to alter the format of the XML passesd as a reponse to a Web Service request ?

Thanks

[ConvertFromOldNGs]

by Torrie Moore >> Wed, 30 Jan 2008 20:07:50 GMT

Is it possible to define a web service method in Jade that simply returns a string? You can then generate the XML manually and return it.

You may also want to look at the JadeWebServiceProvider::reply, JadeWebServiceProvider::processRequest and the JadeWebServiceProvider::processMessage methods. You may be able to trap the SOAP response from Jade and reformat it as appropiate. For example, we reimplement the reply method to optionally log the outgoing message. (see below)

Torrie

-------------------------------------------------------

reply(): String updating, protected;
vars
sResult : String; // The outgoing soap message.begin

sResult := inheritMethod();
if currentSession <> null then // TM P363
app.myWebServiceLog.trace( '--------OUTGOING SOAP----------------SESSION ID=' & currentSession.getSessionID.String & '--------------------------' & CrLf
& sResult & CrLf );
else // TM P363
app.myWebServiceLog.trace( '--------OUTGOING SOAP----------------SESSION ENDED --------------------------' & CrLf
& sResult & CrLf ); // TM P363
endif; // TM P363

return sResult;

epilog

end;

[ConvertFromOldNGs]

by rogerb >> Thu, 31 Jan 2008 19:48:42 GMT

Thanks for the suggestion.

We tried modifying the "reply" method to force the XML response to be of type string. Unfortunately this did not work as the format did not match the wsdl.

So BI Publisher still complained with the same error

Cheers,
Roger

[ConvertFromOldNGs]

by rogerb >> Thu, 31 Jan 2008 19:49:21 GMT

Thanks for the suggestion.

We tried modifying the "reply" method to force the XML response to be of type string. Unfortunately this did not work as the format did not match the wsdl.

So BI Publisher still complained with the same error

Cheers,
Roger

[ConvertFromOldNGs]

by rogerb >> Thu, 31 Jan 2008 19:49:48 GMT

Thanks for the suggestion.

We tried modifying the "reply" method to force the XML response to be of type string. Unfortunately this did not work as the format did not match the wsdl.

So BI Publisher still complained with the same error

Cheers,
Roger