如果 WCF 数据服务也有提供程序模型 (请参阅我的博客系列），它允许您编写自定义代码来公开任何数据源，无论是其他 Web 服务、平面文件、NoSQL 数据库还是 ODBC 数据源。
希望这有帮助
Unfortunately I'm not aware of a provider that does this natively.
One option would be to use Entity Framework with a custom 'Entity Framework provider' that supports ODBC datasources and use WCF Data Services' ability to expose an Entity Framework model.
Failing that WCF Data Services also has a provider model (see my blog series) that allows you to write custom code to expose any datasource, be that other WebServices, Flat Files, NoSQL database or ODBC data source.
This is a great way to export your data from oData webservices. I tried it out on some in development services in house and it was extremely impressive... one of those WOW moments (I don't get many of these :).
Big caveat is that you can't import using PowerQuery (and please point out if I'm wrong here... I'd love to use it for import!).
I also came across the http://www.rssbus.com/odbc/odata/ solution (now up to $99/client) and will try this out for an import solution.
发布评论
评论（2）
不幸的是，我不知道有哪个提供商可以本地执行此操作。
一种选择是将实体框架与自定义“实体框架提供程序结合使用'，它支持 ODBC 数据源并使用 WCF 数据服务公开实体框架模型的能力。
如果 WCF 数据服务也有提供程序模型 (请参阅我的博客系列），它允许您编写自定义代码来公开任何数据源，无论是其他 Web 服务、平面文件、NoSQL 数据库还是 ODBC 数据源。
希望这有帮助
Unfortunately I'm not aware of a provider that does this natively.
One option would be to use Entity Framework with a custom 'Entity Framework provider' that supports ODBC datasources and use WCF Data Services' ability to expose an Entity Framework model.
Failing that WCF Data Services also has a provider model (see my blog series) that allows you to write custom code to expose any datasource, be that other WebServices, Flat Files, NoSQL database or ODBC data source.
Hope this helps
您绝对应该查看 Power Query for Excel (http://www. microsoft.com/en-us/download/details.aspx?id=39379）。
这是从 oData Web 服务导出数据的好方法。我在内部的一些开发服务上进行了尝试，结果非常令人印象深刻……这是令人惊叹的时刻之一（我没有得到很多这样的时刻:)。
需要注意的是，您无法使用 PowerQuery 进行导入（如果我错了，请指出...我很乐意使用它进行导入！）。
我还遇到了 http://www.rssbus.com/odbc/odata/ 解决方案（现在高达 99 美元/客户）并将尝试使用此导入解决方案。
You should definitely checkout Power Query for Excel (http://www.microsoft.com/en-us/download/details.aspx?id=39379).
This is a great way to export your data from oData webservices. I tried it out on some in development services in house and it was extremely impressive... one of those WOW moments (I don't get many of these :).
Big caveat is that you can't import using PowerQuery (and please point out if I'm wrong here... I'd love to use it for import!).
I also came across the http://www.rssbus.com/odbc/odata/ solution (now up to $99/client) and will try this out for an import solution.