Data Connection: Web Service with HTTP Basic Authentication

[Former Member]

Hi,

I am trying to add a data connection to a dashboard that calls a non-SAP web service.  The web service requires basic http authentication.  I can import the WSDL URL and map the input/output values for the web services' methods, but it is not clear to me how/where I should to add the username and password. Hopefully it is something simple.  Can someone please provide direction?

Thanks!

[Former Member]

Hii Matt ,

username and password shud be harcoded for particular users and bind the cell to Web Services Connection Parameters .

Regards

Jeetan

[mh97]

Hi Matt,

I don't know if you still need this, but I ran across it while looking for something else.

In the BO Dashboards documentation (which you can access with F1 if your help file is set up correctly; it is p. 220 in the pdf version that I have), it has the following about setting up a data connection using a web service - note the example given:

If your Web Service connection requires information to be passed in the SOAP header, click the Advanced tab. Type the information in HTML format or click the Cell Selector button to select cells in the embedded spreadsheet that contain the information.
Note: When you use the Cell Selector button , the <soap:Header> HTML tags are automatically added to the text values in the cell. For example, the selected cell would only need to contain “<username>joe</username> <password>1234</password>”. 

I hope that helps. I haven't tried it so can't vouch for it, but it's what the documentation says.

Margaret