question

Grant Fritchey avatar image
Grant Fritchey asked

SSRS Connection to Peoplesoft Web Service

I need to configure Reporting Services to get data from a PeopleSoft web service. I already have my data source set to XML with the correct URL. My problem is that I need to configure the query based on the WSDL of the web service. Here is the web service definition that I'm working from: - - - - - wsse:UserNameToken - - - From that, I'm attempting to configure the query like this: I've tried variations, including the SoapAction, adding in ElementPath, I keep getting "Error while reading xml response" and nothing else. I'm stuck and I need some help. Please let me know if you need more information. I'll be posting this to SQL Server Central as well.
ssrsreportingdatasetweb-servicepeoplesoft
2 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

@Grant Fritchey Maybe I am barking at the wrong tree here, but is there any way to use Visual Studio, add web reference and point it to URL of the wsdl? If so then VS should be able to generate a proxy class for your service. Then you can set the Url property of the proxy to some dummy location, say, at port 8080 and use the Microsoft's SOAP toolkit ( http://www.microsoft.com/downloads/en/details.aspx?FamilyID=c943c0dd-ceec-4088-9753-86f052ec8450&displaylang=en) to setup a trace on port 8080 and see what the request should look like. This should give you an idea how to bake the same by hand.
3 Likes 3 ·
It's a possibility. It's one I'd rather not use, but it might be what's required.
0 Likes 0 ·
Grant Fritchey avatar image
Grant Fritchey answered
The issue was directly related to the web service exposed by PeopleSoft. It was a two-step web service, it wanted a request with a response and then another request. The mechanisms within Reporting Services just don't support that. The solution was to rewrite the web service entirely.
2 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

@Grant Fritchey Isn't it amazing how many vendors label their nonsense as **web service**, and then expect people to find a way to call it? I had an issue with a third party "**web service**" which expected a SOAP request, but returned a plain XML as response, no envelope! There was no way to call it as a web service because of it, and I had to revert to the very ugly hand crafting of SOAP envelope and feeding it to the plain vanilla HttpWebRequest as a workaround. It was not pretty :(
0 Likes 0 ·
Well, the fact is, you can "comply" with SOAP multiple ways. What they have is completely "standard" even as it's completely useless if you're not writing C# code.
0 Likes 0 ·
Fatherjack avatar image
Fatherjack answered
3 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

PS. Dont give this any points. I had a free lunchtime and was just looking around the unanswered questions and thought I'd see what a few searches came up with. Glad its resolved. J
0 Likes 0 ·
It's not resolved unfortunately. I worked out how to do the report, but we're still hitting problems with consuming the web service.
0 Likes 0 ·
Oh. Rubbish. Um, saw this and thought of you http://theoatmeal.com/blog/utilikilt, well not like that but, you know ... Will try and find some time to research XML data sources. Is it a general thing or specific to PeopleSoft?
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.