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