是否可以将 SQL Azure 报告与筛选的 SQL Azure 联合数据库一起使用？
是否可以将 SQL Azure Reporting Services 与使用联合的 SQL Azure 数据库一起使用，其中表由租户 ID 联合，并且要求所有对数据库的访问都通过由联合密钥过滤的连接（即按租户过滤）完成？
仅按照 此论坛帖子还不够，因为一个租户必须无法查看另一租户的数据。 SQL Azure 联合必须使用“FILTERING=ON”条件来过滤连接。
有没有办法让 SQL Azure Reporting Services 执行必要的 USE FEDERATION 命令来通过联合密钥筛选连接？
或者，让 Reporting Services 以任何其他可能被过滤的方式（如 OData Web 服务）访问数据？
期望的结果是每个租户都可以运行报告并且只能看到自己的数据。
Is it possible to use SQL Azure Reporting Services with a SQL Azure database using Federation, with tables federated by tenant ID, and the requirement that all access to the database is done through a connection filtered by the federation key, i.e., filtered by tenant?
Merely connecting to a specific federation member database as suggested in this forum post wouldn't be enough, because one tenant must not be able to view another tenant's data. The connection must be filtered by SQL Azure Federations through the use of the "FILTERING=ON" condition.
Is there any way to have SQL Azure Reporting Services execute the necessary USE FEDERATION command to have the connection filtered by the federation key?
Or alternatively, to have Reporting Services access data in any other way (like an OData web service) that might be filtered?
The desired result is that each tenant can run a report and only see their own data.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
SQL Azure Reporting Services 不支持联合（截至当前版本），因此您的最佳选择是编写一个服务并让 SARS 使用该服务作为数据源。
SQL Azure Reporting Services is not federation aware (as of the current version), so your best choice is to write a service and have SARS use that service as the data source.