使用 REST WCF 数据服务作为 SQL 报告服务的数据源
谁能向我指出一个明确的 Microsoft 地图，说明 Reporting Services 将使用 WCF 数据服务（ADO.NET 数据服务，Astoria）作为数据源？
那里有碎片化的信息。有一些关于创建自定义数据提供程序，一些关于某种扩展启用到 Azure 存储层的连接（我相信公开为 REST 数据服务），还有一些关于连接到最新版本的 sharepoint（同样，Sharepoint 将其数据公开为 REST）服务？）。关于 REST 服务的报告似乎没有任何统一的愿景。我对 WCF 数据服务特别感兴趣。我错过了一个门户吗？这两项技术有什么故事？
一点背景；我们有一个系统，通过 WCF（ADO.NET、Astoria）数据服务公开数据。在这一层中，我们有各种影响返回数据的业务规则。我们想要做的是使用 SQL 报告服务来满足我们的报告需求，但将数据服务作为数据源。我们正在考虑使用 Report Builder 或 BI Studio 来创建报告。
看来我们必须生成自己的数据模型，这很好。我们必须创建一个自定义数据提供程序 - 然后还创建一个语义查询扩展以将报告查询转换为 REST 调用。报表查询可以执行的操作与 WCF 数据服务 REST api 可以执行的操作之间存在脱节。
当微软如此大力推动 WCF 数据服务时，这似乎是一项艰巨的工作。我错过了什么吗？故事中是否存在需要报道的空白？我们在 MS 最终要做的事情上是否处于领先地位？
Can anyone point me to a definitive Microsoft map for where Reporting Services is going using WCF Data Services (ADO.NET Data Services, Astoria) as a data source?
There's fragmented information out there. There is some about creating custom data providers, some about some sort of extension enable connection to the Azure storage layer (exposed as REST data service I believe) and some about connecting to latest versions of sharepoint (again, Sharepoint exposing its data as a REST service?). There doesn't seem to be any sort of unified vision as regards reporting on REST services. I'm particularly interested in WCF Data Services. Have I missed a portal? What's the story with these two technologies?
Bit of background; we have a system where we've got our data exposed via WCF (ADO.NET, Astoria) data services. In this layer we've got all sorts of business rules shaping the data returned. What we'd like to do is use SQL Reporting services for our reporting needs, but give it the data service as the data source. We're thinking of using either Report Builder or BI Studio to create the reports.
It looks like we'll have to generate our own data model, which is fine. We'll have to create a custom data provider - and then also create a semantic query extension to translate the report queries into REST calls. There's a disconnect between what the report queries can do and what the WCF Data services REST api can do.
This seems like a lot of work when Microsoft seem to be pushing WCF data services so hard. Have I missed something? Is there a gap in the story for reporting? Are we ahead of the curve with what MS will do eventually?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
如果您的服务返回 XML，如果您能够处理一些限制，那么您可能会很幸运。
SSRS 支持 XML 作为数据源，并支持通过 URL 检索该 XML。此文档包含更多详细信息： http://msdn.microsoft .com/en-us/library/aa964129(SQL.90).aspx
请注意，仅支持 HTTP 协议（我认为这意味着不支持 https），并且请求使用 GET 方法。但是，如果指定了参数，则将使用 POST 方法。
我自己没有尝试过（我也不知道有谁尝试过）。文档暗示这是可能的，但可能会有眼泪。
If your service returns XML you may be in luck if you can deal with several restrictions.
SSRS supports XML as a datasource, and supports retrieving that XML via a URL. This document has more details: http://msdn.microsoft.com/en-us/library/aa964129(SQL.90).aspx
Notice that only the HTTP protocol is supported (I assume that means https is not), and the request uses the GET method. However, if parameters are specified, the POST method will be used.
I have not attempted this myself (nor do I know anyone who has). The docs imply that it is possible, but there may be tears.