Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Trouble using web-service as data source

Question
21
Views
0
Comments

Summary

Trouble using web-service as data source

Content

OS: RHEL 7.2

BIP 11.1.1.9 enterprise

Flexcube 11.6

Hi Team,

I am trying to integrate a Flexcube API into BI publisher as a data source, but consistently facing issues while trying to do so.

The API I am using is implemented in WSDL form and is populating the method names when trying to build data model using the same.

The Web source definition is as below

server protocol: HTTP

server: IP address of API server

Port: The active port

URL suffix: AppServices/services/XfaceAccountStatementInquiryWrapper?wsdl

Complex type: Yes

WS-security: 2002

Authentication: XML Soap

user/password not required

The Data model, data set properties are as below

BIP.PNG

Here I get numerous parameters to be set but compulsory parameters have been created and their values set. I dont see an option to exclude the other optional tags, so I have to set the values for them in one way or the other. Hence created a null value parameter "nil" which has been selected from dropdown against each.

When I go to data Tab, I m getting below

soapenv:Envelope

Click to collapsesoapenv:Body

Click to collapsesoapenv:Fault
faultcode (soapenv:Server)

faultstring (unknown)

detail

However if I run the same API from command line as a CURL request, it executes and returns proper results.

The curl contains only the mandatory tags.

Please help in identifying the cause of the issue. Let me know if I can provide any more info.

Thanks

Saurabh