Microsoft Reporting Services Web 服务和 Java
有人成功实施了使用 Microsoft SQL Server 2005 Reporting Services 的基于 Java 的解决方案吗？ Reporting Services 附带了一组 Web 服务，允许您控制报告的创建、报告的执行等，我刚刚开始开发此集成的 POC。 我尚未做出的几个选择是，是否要使用 Axis2 来实现 wsdl-to-java 功能，还是使用 WebLogic 的 clientgen (wsdl 2 java) 解决方案。 我想我还可以使用 JAX-WS 和 wsimport。 在深入探讨这一点之前，我想看看是否有人使用众多可用选项之一成功地做到了这一点。
过去，我遇到过一些关于如何在 .NET 和 Java Web 服务之间处理 null/blank/empty 的问题，我只是想看看这是否是 SSRS 和 Java 集成的问题。 谢谢
Has anyone successfully implemented a Java based solution that uses Microsoft SQL Server 2005 Reporting Services? Reporting Services comes with a set of Web Services that allow you to control the creation of a report, execution of a report, etc and I am just starting development on a POC of this integration. A couple of choices I have yet to make is whether I want to use Axis2 for the wsdl-to-java functionality or use WebLogic's clientgen (wsdl 2 java) solution. I guess I can also use JAX-WS and wsimport. Before I dive into this, I wanted to see if anyone was doing this successfully with one of the many options available.
In the past, I've had a few issues on how null/blank/empty's are handled between .NET and Java web-services and I just wanted to see if this had come up as an issue with SSRS and Java integration. Thanks
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（3）
根据我使用 RS 的经验，我建议您选择其他任何东西。 我认为 Web 服务部分可以正常工作，但我会担心 RS 如何管理内存以及在做出任何决定之前需要立即运行多少个报告。 今天我正在与 RS 的内存管理问题作斗争，即使在顶级硬件上也很难运行大型报告（返回大量行和广泛的结果集）。
话虽这么说，如果您认为 RS 可以满足您的使用情况，那么它可能会很好。 开发环境很好，很容易理解和布置报告。 它的表格布局范例非常好。
My experience with RS would lead me to suggest you go with just about anything else. I think the web services portion would work fine but I'd be concerned about how RS manages memory and how many reports you need to be running at once before making any decisions. I'm fighting with memory management problems today with RS and even on top of the line hardware it's hard to run large reports (large number of rows returned and a wide result set).
That being said if you think RS can handle your usage then it might be good. The development environment is sort of nice and it's easy to understand and lay out reports. The table layout paradigm it has is pretty good.
我只是想回来回答我自己的问题。 我从 Axis2 开始，它是 Apache 的 SOAP 实现。 使用WSDL2Java生成客户端后，我能够成功调用Microsoft Reporting Services WebService并生成报告，以Excel、PDF、CSV等格式输出。 就我而言，我还使用 Axis2 或 HttpClient 的 NTML 身份验证机制，让我的应用程序使用 Active Directory 中的凭据自动“登录”，并生成报告并将其分发给许多用户。
I just wanted to come back and answer my own question. I started with Axis2, Apache's implementation of SOAP. After generating the client using WSDL2Java, I was able to successfully invoke Microsoft Reporting Services WebService and generate reports, output in Excel, PDF, CSV and other formats. In my case, I also used Axis2 or HttpClient's NTML authentication mechanism to have my application automatically 'log-in' using credentials from Active Directory and generate and distribute reports to many users.
我们已经成功实现了：JBoss 5 -> IIS代理-> MS Reporting Services 2008（通过网络服务）。
存在一些缺陷：MS RS 2008 不再支持“匿名”访问（2005 年支持），并且强制使用 NTLM 身份验证。 这在 Java 世界中仍然是一个挑战，没有好的 NTLM 库可用。
为了克服这个问题，我们实现了简单的代理（IIS7 + ashx），它在 RS 上进行 NTLM 身份验证（用户/密码硬编码）并允许 JBoss 匿名访问（通过简单地重写 http 响应）。
工作正常:)
干杯
磷
we've successfully implemented that: JBoss 5 -> IIS proxy -> MS Reporting Services 2008 (via webservice).
There are few pitfalls: MS RS 2008 does not support 'Anonymous' access anymore (2005 does), and does enforce using NTLM authentication. That is still a challenge in Java world, there is no good NTLM library available.
To overcome that, we've implemented trivial proxy (IIS7 + ashx) that does NTLM authentication on RS (user/password hardcoded) and allows Anonymous access for JBoss (by simply rewriting http response).
Works ok :)
Cheers
P