将 SSAS 连接到 Teradata
在过去的六个月里，我一直在构建立方体，并且做得很好，直到接到一项新任务。这项新任务是设置一个使用 Teradata 作为数据源的多维数据集，这样我就可以构建该多维数据集，并且能够选择一个数据源并测试运行良好的连接。我能够构建一个数据源视图，从我们的 Teradata 基础设施中选择表。我能够在数据源级别探索数据。因此，我构建了多维数据集并选择了度量并构建了与该多维数据集相匹配的维度。因此，当我去处理这个多维数据集时，我收到 Idbconnection 错误，指出 teradata 客户端引发了异常。请记住，我可以右键单击数据源视图中的表并浏览数据。如果有人对我可能做错了什么有任何见解，并且如果需要任何其他信息，请告诉我。
I have been building cubes for the last six month and was doing well until I was approached with a new task. This new task was to setup a cube that uses Teradata as it's data source so I get to building the cube and I am able to select a data source and test connection that goes fine. I am able to build a data source view selecting tables from within our teradata infrastructure. I am able to explore the data at the datasource level. So I build the cube and select my measures and build a dimension to go with this cube. so when I go to process this cube I get and Idbconnection error saying that the teradata client has thrown an exception. Keep in mind I am able to right click on the tables in the data source view and explore the data. If anyone has any insight on what I may be doing wrong and if any other information is needed let me know.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
我提出的解决方案是使容纳 teradata 的服务器成为链接服务器。通过这样做，我能够查询构建和处理多维数据集所需的数据。我只是在谈论我的想法，但我认为分析服务更喜欢使用链接服务器，这样看起来就像是从微软对象中提取出来的。这将被认为是考虑到微软的专有开发策略。谁知道现在有效了，我很高兴。
The resolution that I came up with was to make the server that houses teradata a linked server. In doing so I was able to query the data I needed to build and process the cube. I am thinking just talking of the top of my head but I think analysis services prefers to use linked servers so that it looks like you are pulling from a microsoft object. This would be perceived to considering microsofts proprietary development tactics. Who knows it works now and I am happy.