通过 SSIS 从 UniData 到 SQL Server 2005/以上版本的数据
我们正在对我们将向想要迁移到基于 .NET 的解决方案的客户提出的解决方案进行可行性研究。部分数据驻留在 UniData 中。可以使用以下工具实现所需内容：
http://www.welland.com/export.html
以上产品将UniData中的数据ETL到SQL Server。
第一步，我们希望确保通过 SSIS 将数据从 UniData 获取到 SQL Server 时不会出现任何问题。
由于我们没有测试环境，因此我们只能在网上进行检查。但大多数有关 UniDate 和 SSIS 的讨论看起来问题并没有得到解决。主要问题似乎是人们无法获得合适的 ODBC 驱动程序。如果数据转换为 XML，那么看起来工作正常。
有没有人这样做过并且知道这可以顺利完成？
We are doing a feasibility on what we're going to propose as a solution to a client who wants to migrate to a .NET based solution. Part of the data resides in UniData. What is required can be achieve using the following tool:
http://www.welland.com/export.html
The above product ETLs data from UniData to SQL Server.
As a first step, we want to be sure that there are no hitches in getting the data through SSIS from UniData to SQL Server.
Since we don't have an environment to test this we have to check mostly on the net. But most of the discussions regarding UniDate and SSIS don't look like the problem got solved. The main problem seems to be that people aren't able to get hold of a proper ODBC driver. If the data is converted into XML, then it looks like it's working fine.
Has anyone done this and know that this can go through without any problems?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
不能说我已经做到了，但是 Rocket Software 提供了 UniData 的 2 用户许可版本，可用于 下载，所以至少你有一个可以测试的系统。
Cannot say I've done it, but Rocket Software has 2-user license versions of UniData available for download, so at least you would have a system to test on.
我们现在实际上正在研究这个过程——通过 SSIS 从 Unidata 到 SQL。我们与 Rocket Software 合作，让 OLE DB 正常工作...ODBC 从来都不够快，以前没有 OLE DB...现在有了。安装 OLE DB 后，您必须在 UNIDATA 方面做一些工作，但这是另一天的答案。到目前为止，除了设置工作之外，我们没有遇到任何问题。
We are actually working on this process now -- Unidata to SQL through SSIS. We worked with Rocket Software to get the OLE DB working... ODBC was never fast enough and before there was not OLE DB... Now there is. You have to do some work on the UNIDATA side once the OLE DB is install but that is an answer for another day. So far we have no issues except the work to get it setup.