Hi.
I am attempting to integrate with Microsoft SQL Reporting Services (SSRS) on SQL Server 2014.
Our SSRS server has a custom authentication module installed, (not windows integrated, and not sharepoint).
I searched the forums and founds some SSRS demo apps, but they seem to be in a much earlier version and the "SalesReportingDemo.osp" cannot be opened inside service studio.
Has anyone integrated SSRS with a custom authentication module?
Does anyone have an up to date example they can share?
Many thanks,
Hi Alan
I am not aware of how the integration with SSRS is done. Is it direct access to the database? SOAP/REST web services?
The integration with SSRS is done through a SOAP web service with web methods.
https://msdn.microsoft.com/en-us/library/ms152787(v=sql.120).aspx
SSRS allows for a custom authentication module to be used which replaces the built-in windows authentication. I am using "custom authentication".
This custom authentication module is written to implement the IAuthenticationExtension interface.I have previously written a ReportServerProxy class which allows a standard asp.net webforms application to use SSRS. First the LOGON soap method is called, and then the authorization cookie is grabbed from the response. The Proxy class then re-injects that cookie into each subsequent request to the webservice.
Q. How can I examine the response to Logon inside outsystems to save this cookie?
Q. How can I then inject that cookie into all further requests?
I have done this in webforms, but I'm not sure where to start in OutSystems.
Hi,
We have done Reporting Services extension to publish a report, execute report with custom authentication etc. if you need I can share extension with you.
Mika Roivainen wrote:
Hi Mika,
Can you share it with us. We are interested in your concept.
Thanks!
Can you share it with me.
Yes please!!! That would be lovely!