DN Debed wrote:Is it possible to interface sql server reporting services with a java desktop application?
The article that you reference
A Java proxy for MS SQL Server Reporting Services suggests that that is not a good idea:
Donner/Papas wrote:Whatever form of authentication is used, the user must have access to the report server, either through a domain account or a local account.
...
Thus, direct access to RS proves impractical if you must authenticate a large user base that does not have Windows domain accounts. In our case, the Web application uses IBM's Tivoli Access Manager and an LDAP (lightweight directory access protocol) directory to manage user permissions.
...
Because of these concerns about the limited out-of-the-box ability to directly authenticate users, the direct-access option is not attractive for our purposes.
The entire motivation behind that article is to decouple
any java client from MS SQL Server RS. For the purpose of the article the clients of the ReportRequest
servlet are assumed to be browsers.
However it should be possible to convert the report data content of the response body returned by the ReportRequest servlet to XML (or even XHTML with a
Microformat). A java desktop application could then use a
URLConnection or
HttpClient to issue a report request and get the report data in the HTTP response. The XML data can then be parsed (or bound with
JAXB) by the java desktop application for its own use.
