Web service as dadatource with basic authentication
Is it possible to configure a datasource using data from a web service (java) requiring basic http authentication? thank you in advance
August 2nd, 2011 10:45am

Hi SwissSeb, Reporting Services is a comprehensive reporting tool that integrates with a diverse set of data sources. We can also query directly from XML data sources and Web services. This is obtained by using the XML data provider. The XML data provider flattens the XML structure into a data set that can be accessed by the reporting engine. Please refer to this whitepaper which concludes with examples showing how to create reports using the XML data provider http://technet.microsoft.com/en-us/library/aa964129(v=sql.90).aspx Thanks, Challen Fu Forum Support If you have feedback for TechNet Subscriber Support, please contact usPlease remember to mark the replies as answers if they help and unmark them if they provide no help.
Free Windows Admin Tool Kit Click here and download it now
August 3rd, 2011 1:52am

Thank you for your reply. The procedure I followed it exactly and this is my observation: If the web service is used with anonymous authentication, no problem configuration : Shared data Source Properties > Credentials > Do not us credentials If the web service requires basic authentication, I tried two configurations: configuration 1 : Shared data Source Properties > Credentials > Use this user and password configuration 2 : Shared data Source Properties > Credentials > Prompt for credentials it does not work I have the following message : An error occurred while connecting to the data source … The data extension supports Windows Integrated Security and No Credentials only. I conclude that I can not call a web service with basic authentication in this way. Is there a workaround?
August 3rd, 2011 3:21am

Hi SwissSeb, You are correct, from a report which retrieve data source from Web services, when authoring client, the following options are available to specify credentials: · Current Windows user (also known as integrated security). · No credentials are required. If you select no credentials, Anonymous access is used. Make sure that you have defined the unattended execution account for the report server to connect to an external data source. The XML data processing extension does not pass credentials to the target URL or the Web service; the connection will be unsuccessful unless you have defined the unattended execution account. For more information, see Configuring the Unattended Execution Account in the Reporting Services documentation Stored and prompted credentials are not supported. If you disable Windows integrated security, you cannot use it to retrieve data. If you specify stored or prompted credentials, an error will occur at run time. However here I still would recommend you to submit a feedback to Microsoft Connect at this link at this link https://connect.microsoft.com/SQLServer/Feedback This connect site is a connection point between you and Microsoft. Your feedback enables Microsoft to make software and services the best that they can be, Microsoft might consider to add this feature in the following release after official confirmation. Fore more information about credentail for XML Connection Type, please see: http://msdn.microsoft.com/en-us/library/dd220468.aspx Regards, Challen FuPlease remember to mark the replies as answers if they help and unmark them if they provide no help.
Free Windows Admin Tool Kit Click here and download it now
August 3rd, 2011 11:30pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics