Michael A
Michael A

Reputation: 9930

Can you consume OData in an SSRS report?

Is it possible to consume OData in an SSRS report? If so how do I go about this?

I found the following which seemed quite hopeful, but nothing recently confirms for whether this is actually possible:

http://connect.microsoft.com/SQLServer/feedback/details/559570/ssrs-should-be-able-to-use-odata-as-a-data-source

If this isn't yet implemented in SSRS 2008R2 are there any recommended workarounds?

Upvotes: 4

Views: 5957

Answers (1)

Nathan Griffiths
Nathan Griffiths

Reputation: 12766

Not directly, no. OData isn't a supported data source for Reporting Services in current versions.

However SSRS can use ODBC data sources, so perhaps an OData ODBC driver like this one might be an alternative? I haven't tried this myself but it seems like a good option.

Upvotes: 3

Related Questions