are there any odbc drivers that connect to odata or similar web data sources [closed]

Closed. This question does not meet Stack Overflow guidelines. It is not currently accepting answers.

---

开发者_JS百科

Questions asking us to recommend or find a tool, library or favorite off-site resource are off-topic for Stack Overflow as they tend to attract opinionated answers and spam. Instead, describe the problem and what has been done so far to solve it.

Closed 8 years ago.

Improve this question

I want to connect using odbc to datasources I can expose over webservice like oData or a custom webservice that can accept SQL.

Are there any drivers out there that can do it?

---

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

---

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.