Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

MS SQL Server 2005 Reporting Services in a java desktop environment

 
DN Debed
Greenhorn
Posts: 10
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Is it possible to interface sql server reporting services with a java desktop application?

If yes, can you teach or give me an idea how is it done?

I successfully interfaced it to a web application using this as guide (http://www.javaworld.com/javaworld/jw-01-2005/jw-0110-sqlrs.html). I now want to try it in a desktop application.

This is because our program is comprised of a web app and a desktop app (used for end of day and as utility app).

Thanks!
 
Peer Reynders
Bartender
Posts: 2933
5
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic