This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(112.00000000000001, 13%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMG%3C/text%3E%3C/svg%3E)
There is a report that pulls data from on-prem SQL server. Now it's moving to Azure. The provider is giving a SOAP envelope to access data. How that can be used in SSRS?
Thanks
I will need to find out what methods to use to get data, right?
Yes, you need to know the existing methods and the structure of the returned result.
In common you can get the information from a WSDL file = Web Service Definition, see WSDL, Web Services, and More
Several years ago I create an example, sorry, only in German, but you can let translate the article:
https://translate.google.com/translate?hl=en&sl=de&u=http://olafhelper.over-blog.de/article-der-aktuelle-wetter-ssrs-bericht-73766985.html&prev=search&pto=aue
I need to use parameters and the methods are all POSTs. In case it would have been a GET the only way to use parameters would be a query string, right?
I was able to get it working in Postman as POST. Two things I had to do there. First I needed to specify additional headers, second it only worked if I used body/raw with the following:
<soap:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
<soap:Body>
<LoginOTP xmlns="xxx/yyy">
<ClientID>string</ClientID>
<GUID>string</GUID>
<User>string</User>
<Password>string</Password>
</LoginOTP>
</soap:Body>
</soap:Envelope>
Knowing all of this is it possible to make it ork in SSRS?
Thanks
SOAP API returns data as XML and SSRS reports can cosume XML as data source, see XML Connection Type (SSRS) and XML Query Syntax for XML Report Data (SSRS)
Hi @mark goldin ,
I guess you may need to refer to: The Role of SOAP in Reporting Services.
Best Regards,
Joy
If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Isn't that link about using SSRS reporting services web services? I need to know how to use SOAP to access Azure SQL Server database.
When I go to this link it prompts me with something that I cannot read.
Just advertisement, click on the right button.