question

markgoldin-3750 avatar image
0 Votes"
markgoldin-3750 asked markgoldin-3750 edited

SSRS report - going from on-prem to Azure

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

sql-server-reporting-services
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

markgoldin-3750 avatar image
0 Votes"
markgoldin-3750 answered markgoldin-3750 edited

I will need to find out what methods to use to get data, right?

· 3
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

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

0 Votes 0 ·

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?

0 Votes 0 ·

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

0 Votes 0 ·
Joyzhao-MSFT avatar image
0 Votes"
Joyzhao-MSFT answered

Hi @markgoldin-3750 ,
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.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

markgoldin-3750 avatar image
0 Votes"
markgoldin-3750 answered

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.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

OlafHelper-2800 avatar image
1 Vote"
OlafHelper-2800 answered

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)


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

markgoldin-3750 avatar image
0 Votes"
markgoldin-3750 answered OlafHelper-2800 commented

When I go to this link it prompts me with something that I cannot read.

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Just advertisement, click on the right button.

0 Votes 0 ·