Is it possible to configure a datasource using data from a web service (java) requiring basic http authentication?
thank you in advance
Technology Tips and News
Is it possible to configure a datasource using data from a web service (java) requiring basic http authentication?
thank you in advance
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
us
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?
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 Fu
Hi
Any news on this from Microsoft? I need SSRS to report from various WEB Services that require http authentication. The current XML data provider for SSRS does not support this basic requirement?
Regards