从跨域访问 SSAS 多维数据集，无需直接数据库连接
我是第一次使用 SQL Server Analysis Services，并且在处理一个项目时遇到了困境，在该项目中，用户必须能够访问跨不同服务器和域的 SSAS 多维数据集（通过自定义 Web 仪表板），但又没有访问其他服务器的 SSAS 数据库连接字符串。因此，组织 A 和组织 B 将在各自的服务器上拥有自己的多维数据集，但组织 A 用户必须能够查看组织 B 的多维数据集，组织 B 用户必须能够查看组织 A 的多维数据集，但组织 A 和组织 B 都不能访问组织 A 的多维数据集。连接字符串。
我已阅读过有关允许从下面的链接对 SSAS 服务器和多维数据集进行 HTTP 访问的内容，但这需要设置用户进行身份验证或允许另一个组织的用户匿名访问一个组织的服务器，我不确定这是否可行对于这种情况是可以接受的，或者如果这是执行此操作的首选方法。这里的性能可以接受吗？
http://technet.microsoft.com/en-us/library/cc917711。 aspx
我还想知道是否有必要运行每晚/每周的流程，通过 Web 服务或其他方式访问其他组织的 SSAS 数据库，并将该数据拉入组织服务器上的数据库，然后重建立方体。然后，在查看该多维数据集时，无需连接到其他组织服务器即可查询该多维数据集。
还有其他人尝试过完成类似的事情吗？ HTTP 访问是实现此目的的标准方法吗？或者还有其他可能的选择吗？谢谢，如果您需要更多信息，请告诉我，但仍不清楚其中一些是如何工作的。
I'm working with SQL Server Analysis Services for the first time and have the dilemma of working on a project in which users must be able to access SSAS Cubes (via a custom web dashboard) that live across different servers and domains, but without having access to the other server's SSAS database connection strings. So Organization A and Organization B will have their own cubes on their own servers, but Organization A users must be able to view Organization B's cubes, and Organization B users must be able to view Organization A's cubes, but neither organization should have access to the connection string.
I've read about allowing HTTP access to the SSAS server and cube from the link below, but that requires setting up users for authentication or allowing anonymous access to one organization's server for users of another organization, and I'm not sure this would be acceptable for this situation, or if this is the preferred way to do this. Is performance acceptable here?
http://technet.microsoft.com/en-us/library/cc917711.aspx
I also wonder if perhaps it makes sense to run a nightly/weekly process that accesses the other organization's SSAS database via a web service or something, and pull that data into a database on the organization's server, and then rebuild the cube. Then that cube would be queried without having to go and connect to the other organization server when viewing the cube.
Has anyone else attempted to accomplish something similar? Is HTTP access the standard way to go for this? Or any other possible options? Thanks, and please let me know if you need more info, still unclear on how some of this works.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
对于您听起来想要做的事情来说，HTTP 可能是最好的选择。如果它们是同一网络但不是同一域的两台计算机，则在每台计算机上使用 ipaddress\username（相同的用户/密码）将起作用，就像工作组中的老式 Windows 网络一样。
您也可以在另一台计算机上备份、ftp 和下载/恢复多维数据集，可能适合您正在做的事情。
HTTP is probably the best option for what you sound like you are trying to do. if they are two machines on same network but not same domain, using ipaddress\username on each (same user/pass) will work, like old school windows networking in workgroups.
You could also just backup , ftp and download/restore the cube on the other machine, might work for what you are doing.
正如 ScaleOvenStove 建议的那样，HTTP 是适合您情况的最佳解决方案，但用户应该在两台服务器上同步才能通过 HTTP 进行访问。组织网络中的用户可以使用 AD 同步工具进行同步。必须在其他组织的网络中创建具有最低权限的用户，并且您可以为他们可以在多维数据集中访问的内容定义基于角色的安全性
as suggested by ScaleOvenStove HTTP is the best solution for your case, but users should be synced on both the servers to get access via HTTP. Users across both the organization's network can to be synced with a AD Sync tool. User has to be created in the other organization's network with bare minimum rights, and you can define role based security for what they can access in the cube