I have a list on SharePoint 2010 which has a number of columns with some basic data types (Text, Yes/No, Number). I m using a third party BI tool which consumes SharePoint list data using ODBC interface. Currently I have been using plain text
file, Excel or Access to feed SharePoint list data to the BI tool as they have the facility to use the list as a datasource.
I am wondering if there is a more generic way to use the list as a datasource
for any ODBC consuming application.
Any thoughts?
